MySql³£ÓÃÃüÁî
Æô¶¯£ºnet start mySql;
½øÈ룺mysql -u root -p/mysql -h localhost -u root -p databaseName;
ÁгöÊý¾Ý¿â£ºshow databases;
Ñ¡ÔñÊý¾Ý¿â£ºuse databaseName;
Áгö±í¸ñ£ºshow tables£»
ÏÔʾ±í¸ñÁеÄÊôÐÔ£ºshow columns from tableName£»
½¨Á¢Êý¾Ý¿â£ºsource fileName.txt;
Æ¥Åä×Ö·û£º¿ÉÒÔÓÃͨÅä·û_´ú±íÈκÎÒ»¸ö×Ö·û£¬£¥´ú±íÈκÎ×Ö·û´®;
Ôö¼ÓÒ»¸ö×ֶΣºalter table tabelName add column fieldName dateType;
Ôö¼Ó¶à¸ö×ֶΣºalter table tabelName add column fieldName1 dateType,add columns fieldName2 dateType;
¶àÐÐÃüÁîÊäÈë:×¢Òâ²»Äܽ«µ¥´Ê¶Ï¿ª;µ±²åÈë»ò¸ü¸ÄÊý¾Ýʱ£¬²»Äܽ«×ֶεÄ×Ö·û´®Õ¹¿ªµ½¶àÐÐÀ·ñÔòÓ²»Ø³µ½«±»´¢´æµ½Êý¾ÝÖÐ;
Ôö¼ÓÒ»¸ö¹ÜÀíÔ±ÕÊ»§£ºgrant all on *.* to user@localhost identified by "password";
ÿÌõÓï¾äÊäÈëÍê±ÏºóÒªÔÚĩβÌî¼Ó·ÖºÅ';'£¬»òÕßÌî¼Ó'\g'Ò²¿ÉÒÔ£»
²éѯʱ¼ä£ºselect now();
²éѯµ±Ç°Óû§£ºselect user();
²éѯÊý¾Ý¿â°æ±¾£ºselect version();
²éѯµ±Ç°Ê¹ÓõÄÊý¾Ý¿â£ºselect database();
1¡¢É¾³ýstudent_courseÊý¾Ý¿âÖеÄstudentsÊý¾Ý±í£º
rm -f student_course/students.*
2¡¢±¸·ÝÊý¾Ý¿â£º(½«Êý¾Ý¿âtest±¸·Ý)
mysqldump -u root -p test>c:\test.txt
±¸·Ý±í¸ñ£º(±¸·ÝtestÊý¾Ý¿âϵÄmytable±í¸ñ)
mysqldump -u root -p test mytable>c:\test.txt
½«±¸·ÝÊý¾Ýµ¼Èëµ½Êý¾Ý¿â£º(µ¼»ØtestÊý¾Ý¿â)
mysql -u root -p test
3¡¢´´½¨ÁÙʱ±í£º(½¨Á¢ÁÙʱ±ízengchao)
create temporary table zengchao(name varchar(10));
4¡¢´´½¨±íÊÇÏÈÅжϱíÊÇ·ñ´æÔÚ
create table if not exists students(……);
5¡¢´ÓÒѾÓеıíÖи´ÖƱíµÄ½á¹¹
create table table2 select * from table1 where 1<>1;
6¡¢¸´ÖƱí
create table table2 select * from table1;
7¡¢¶Ô±íÖØÐÂÃüÃû
alter table table1 rename as table2;
8¡¢ÐÞ¸ÄÁеÄÀàÐÍ
alter table table1 modify id int unsigned;//ÐÞ¸ÄÁÐidµÄÀàÐÍΪint unsigned
alt
Ïà¹ØÎĵµ£º
mysqlÓÐÒ»¸ö¹¦ÄܾÍÊÇ¿ÉÒÔlogÏÂÀ´ÔËÐеıȽÏÂýµÄsqlÓï¾ä£¬Ä¬ÈÏÊÇûÓÐÕâ¸ölogµÄ£¬ÎªÁË¿ªÆôÕâ¸ö¹¦ÄÜ£¬
ÒªÐÞ¸Ämy.cnf»òÕßÔÚmysqlÆô¶¯µÄʱºò¼ÓÈëһЩ²ÎÊý¡£Èç¹ûÔÚmy.cnfÀïÃæÐ޸ģ¬ÐèÔö¼ÓÈçϼ¸ÐÐ
long_query_time = 1
log-slow-queries = /var/youpath/slow.log
log-queries-not-using-indexes
long_query_time ÊÇÖ¸Ö´ ......
¡¡ÍøÉÏÓкܶàµÄÎÄÕ½ÌÔõôÅäÖÃMySQL·þÎñÆ÷£¬µ«¿¼Âǵ½·þÎñÆ÷Ó²¼þÅäÖõIJ»Í¬£¬¾ßÌåÓ¦ÓõIJî±ð£¬ÄÇЩÎÄÕµÄ×ö·¨Ö»ÄÜ×÷Ϊ³õ²½ÉèÖòο¼£¬ÎÒÃÇÐèÒª¸ù¾Ý×Ô¼ºµÄÇé¿ö½øÐÐÅäÖÃÓÅ»¯£¬ºÃµÄ×ö·¨ÊÇMySQL·þÎñÆ÷Îȶ¨ÔËÐÐÁËÒ»¶Îʱ¼äºóÔËÐУ¬¸ù¾Ý·þÎñÆ÷µÄ”״̬”½øÐÐÓÅ»¯¡£
mysql> show global status;
¡¡¡¡¿ÉÒÔÁгöMySQL·þÎ ......
ÏÂÎç¿´ÁËÒ»¶ÎPHP100µÄÊÓÆµ¡£
Ò²ËãÓеãÊÕ»ñ¡£
ÀïÃæµÄÒ»¶Î×ÔдµÄfindallµÄSQLº¯Êý£º
public function findall($table) {
$this->query("SELECT * from $table");
}
ÔÀ´Ö»ÊÇÕâô¼òµ¥£¬¸Õ»¹ÔÚ˼¿¼¡£
ʹÓÃÁËTAB¼üÉÏÃæµÄ¶ÙºÅÀ´ÐÞÊÎMYSQLÀïµÄ×Ö¶ÎÃû£¬È磺
UPDATE tablename SET `fieldname`='values' wh ......
ÏÔʾmysql»ù±¾ÐÅÏ¢£ºmysql>status;
²é¿´±äÁ¿£ºshow variables like '%version%';
±¸·ÝÓ뻹ÔÃüÁÔÚ×îºó»¹ÓÐ
1.±¸·ÝMySQLÊý¾Ý¿âµÄÃüÁî:
ÔÚcmdÖнøÈëµ½mysqlµÄlibĿ¼ÏÂÖ´ÐÐÈçÏ£º
mysqldump -hhostname -uusername -ppassword databaseName > backupfile.sql
Àý£ºmysqldump -hlocalhost -uroot -p123456 test ......
ÊÖ¶¯½¨±í£º
CREATE TABLE `excel` (
`id` int(11) DEFAULT NULL,
`name` varchar(50) DEFAULT NULL,
`passwd` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=gb2312; ×¢ÒâÊÇgb2312
È»ºóÔÚÁ¬½ÓÊý¾Ý¿âʱ¼ÓÉÏ:
useUnicode=true&characterEncoding=gb2312.
¾ÍokÀ²£¡ ......