½â¾ömysqlÖÐÎÄÂÒÂëÎÊÌâ
1¡¢´ò¿ªÎı¾±à¼my.cnf
sudo gedit /etc/mysql/my.cnf
ÔÚ[client]
½Úµã£¬Ìí¼Ó
default-character-set=utf8 (¿Í»§¶ËȱʡÒÔutf8´æ´¢)
ÔÚ[mysqld]
½Úµã£¬Ìí¼Ó
default-character-set=utf8 (Êý¾Ý¿âȱʡÒÔutf8´æ´¢)
init_connect='SET NAMES utf8'
£¨É趨Á¬½ÓmysqlÊý¾Ý¿âʱʹÓÃutf8±àÂ룬ÒÔÈÃmysqlÊý¾Ý¿âΪutf8ÔËÐУ©
±£´æ£¬¹Ø±Õ
2¡¢ÖØÆômysql
Í£Óãº
sudo mysqladmin shutdown -u root -p
ÆôÓãº
sudo mysqld_safe -user=mysql &
3¡¢²é¿´mysql±àÂë
sudo mysql -u root -p
mysql>show variables like 'character%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 &nb
Ïà¹ØÎĵµ£º
»¹ÔÒ»¸öÊý¾Ý¿â:mysql -h localhost -u root -p123456 www<c:\www.sql
±¸·ÝÒ»¸öÊý¾Ý¿â:mysqldump -h localhost -u root -p123456 www > d:\www2008-2-26.sql
//ÒÔÏÂÊÇÔÚ³ÌÐòÖнøÐвâÊÔ
//$command = "mysqldump --opt -h $dbhost -u $dbuser -p $dbpass $dbname | gzip > $backupFile";
$command="mysqldum ......
´Ë´¦ÔËÓÃÁËÒ»¸ö¼¯³ÉµÄxampp¼Ü¹¹¡£²»Óõ¥¶ÀÈ¥°²×°apache·þÎñÆ÷£¬mysqlÊý¾Ý¿â£¬µÈµÈ¡£
£¨Ò»£©XamppµÄ°²×°
ÏÂÔØxampp
1. Ë«»÷xampp£¬µã»÷ÏÂÒ»²½£¬ÏÂÒ»²½£¬ÈçÊÇ£¬¾Í°²×°ÁËxampp¡££¨´Ë´¦°²×°ÔÚÁËc£º\sandboxÏÂÃæÁË£©
2. ½øÐÐxampp°²×°ÊÇ·ñ³É¹¦µÄ²âÊÔ£º
´ò¿ª£ºc:\ ......
ÏÈÏÂÔØÒ»¸ömysqlµÄÇý¶¯Æ÷£º£¨ÎÒϵÄÊÇmysql-connector-java-3.1.11-bin.jar£©
½«Ëü·Åµ½java\libĿ¼ÏÂ
ÔÚ»·¾³±äÁ¿µÄCLASSPATHÀïÌí¼Ó¸ÃÀࣨ%JAV_HOMG%\lib\mysql-connector-java-3.1.11-bin.jar)
³ö²âÊԸöδúÂë¼´¿É£º
import java.net.URL;
import java.sql.*;
public class sqlTest {
public static void mai ......
×÷/ÒëÕߣºÒ¶½ðÈÙ£¨Email: £©£¬À´Ô´£ºhttp://imysql.cn£¬×ªÔØÇë×¢Ã÷×÷/ÒëÕߺͳö´¦£¬²¢ÇÒ²»ÄÜÓÃÓÚÉÌÒµÓÃ;£¬Î¥Õ߱ؾ¿¡£
Ê×ÏÈ,ÕâÆ¬ÎÄÕ´¿´âÊÇÎҵĸöÈ˾Ñé̸֮,ÊÊÓÃÓÚÎÒ³£¼ûµÄ»·¾³¼°ÏîÄ¿ÖÐ.
¸öÈ˽¨Òé,Êý¾Ý¿â×Ö·û¼¯¾¡Á¿Ê¹ÓÃutf8(HTMLÒ³Ãæ¶ÔÓ¦µÄÊÇutf-8),ÒÔʹÄãµÄÊý¾ÝÄܺÜ˳ÀûµÄʵÏÖÇ¨ÒÆ,ÒòΪutf8×Ö·û¼¯ÊÇĿǰ×îÊʺÏÓÚÊ ......
#!/bin/bash
#ɾ³ý100¸öÊý¾Ý¿âÖеÄ1000¸ö±íµÄ¹ýÆÚÊý¾Ý
DBHOST="127.0.0.1"
DBPWD="pwd"
DBUSER="root"
MYSQLBIN="/usr/local/mysql/bin/mysql"
for((dbindex = 0;dbindex < 100;dbindex++))
do
for((tabindex = 0;tabindex < 10;tabindex++))
do
if [&n ......