Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

MYSQL »ù±¾ÃüÁî

½øÈëMySQL:mysql -u root -p password;
Í˳öMySQL:quit/exit;
´´½¨Êý¾Ý¿â£ºcreate database database-name;
ÏÔʾËùÓеÄÊý¾Ý¿â: show databases; ×¢ÒâÓиös;
ɾ³ýÊý¾Ý¿â£ºdrop database databasename;
lÁ¬½ÓÊý¾Ý¿â£ºuse databasename;Ìáʾ£ºdatabase changed;
Ñ¡Ôñµ±Ç°Êý¾Ý¿â£ºselect database();
µ±Ç°Êý¾Ý¿âËù°üº¬µÄ±í£ºshow tables;
´´½¨Óû§²¢¸³ÓèȨÁ¦£ºgrant all privileges on dbname.* to username@localhost identified by password;
´´½¨Êý¾Ý±í£ºcreate table table-name(<×Ö¶Î1><ÀàÐÍ1>,<×Ö¶Î2><ÀàÐÍ2>, <×Ö¶Î...n><ÀàÐÍn>)£»
»ñÈ¡±í½á¹¹£ºdesc table-name/show columns from table-name;
ɾ³ý±í£ºdrop table table-name;
²åÈëÊý¾Ý£ºinsert into table-name (<×Ö¶Î1>,<×Ö¶Î2>, <×Ö¶Î...n>) values('','','');
²éѯÊý¾Ý±íÖеÄÊý¾Ý£ºselect * from table-name(²éѯȫ²¿Êý¾Ý);
²éѯǰ¼¸ÐÐÊý¾Ý£ºselect * from table-name order by id limit 0,n;
ɾ³ý±íÖеÄÊý¾Ý£ºdelete from table-name where Ìõ¼þ;
¸úбíÖеÄÊý¾Ý£ºupdate table-name set ×Ö¶Î=ÐÂÖµ,... where Ìõ¼þ£»
ÔÚ±íÖÐÌí¼Ó×ֶΣºalter table table-name add <×Ö¶Î> <lÀàÐÍ>..;
¸ü¸Ã±íÃû£º rename table oldtablename to newtablename;
¸üÐÂ×Ö¶ÎÄÚÈÝ£ºupdate table-name set ×Ö¶ÎÃû=ÐÂÄÚÈÝ£»
µ¼³öÕû¸öÊý¾Ý¿â:mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû > µ¼³öµÄÎļþÃû   
µ¼³öÒ»¸ö±í:mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû±íÃû> µ¼³öµÄÎļþÃû
µ¼³öÒ»¸öÊý¾Ý¿â½á¹¹ : mysqldump -u root -p -d --add-drop-table lcc >d:\lcc.sql-d ûÓÐÊý¾Ý --add-drop-table ÔÚÿ¸öcreateÓï¾ä֮ǰÔö¼ÓÒ»¸ödrop table
µ¼ÈëÊý¾Ý¿â
  ³£ÓÃsource ÃüÁî
  ½øÈëmysqlÊý¾Ý¿â¿ØÖÆÌ¨£¬
  Èçmysql -u root -p 
 mysql>use Êý¾Ý¿â
 È»ºóʹÓÃsourceÃüÁºóÃæ²ÎÊýΪ½Å±¾Îļþ£¨ÈçÕâÀïÓõ½µÄ.sql£©
 mysql>source d:\1.sql
 


Ïà¹ØÎĵµ£º

java´úÂëÖ´ÐÐmysqlµÄÊý¾Ý±¸·ÝºÍÅúÁ¿Êý¾Ý²åÈ룡

mysqlÊý¾Ý¿â±¾ÉíÓÐÊý¾Ý±¸·ÝºÍÅúÁ¿Êý¾Ý²åÈëµÄÃüÁjava´úÂë¿ÉÖ´ÐÐÕâЩÃüÁî¡£
°²×°mysqlºó£¬ÐèÒªÉèÖû·¾³±äÁ¿£ºÎҵĵçÄÔÓÒ»÷--ÊôÐÔ--¸ß¼¶--»·¾³±äÁ¿£¬Ôö¼ÓMYSQL_HOME=“mysql°²×°Â·¾¶”£¬È»ºópath=%MYSQL_HOME%\bin
´úÂëÈçÏ£º
import java.io.BufferedReader;
import java.io.FileInputStream;
import java. ......

MysqlÖÐlimitµÄÓ÷¨Ïê½â


MysqlÖÐlimitµÄÓ÷¨£ºÔÚÎÒÃÇʹÓòéѯÓï¾äµÄʱºò£¬¾­³£Òª·µ»ØÇ°¼¸Ìõ»òÕßÖмäij¼¸ÐÐÊý¾Ý£¬Õâ¸öʱºòÔõô°ìÄØ£¿²»Óõ£ÐÄ£¬mysqlÒѾ­ÎªÎÒÃÇÌṩÁËÕâÑùÒ»¸ö¹¦ÄÜ¡£
SELECT * from table   LIMIT [offset,] rows | rows OFFSET offset
LIMIT ×Ó¾ä¿ÉÒÔ±»ÓÃÓÚÇ¿ÖÆ SELECT Óï¾ä·µ»ØÖ¸¶¨µÄ¼Ç¼Êý¡£LIMIT ½ÓÊÜÒ»¸ö»òÁ½¸öÊý ......

MySQL showµÄÓ÷¨

a. show tables»òshow tables from database_name; // ÏÔʾµ±Ç°Êý¾Ý¿âÖÐËùÓбíµÄÃû³Æ
   b. show databases; // ÏÔʾmysqlÖÐËùÓÐÊý¾Ý¿âµÄÃû³Æ
   c. show columns from table_name from database_name; »òshow columns from database_name.table_name;   // ÏÔʾ±íÖÐÁÐÃû³Æ
   ......

ÅäÖÃTOMCAT+ECLIPSE+MYSQLµÄJSP»·¾³

ÅäÖÃTOMCAT+ECLIPSE+MYSQLµÄJSP»·¾³
¹Ø¼ü´Ê£º JSP»·¾³ÅäÖà    TOMCAT+ECLIPSE+                                     &nbs ......

mysql ÖÐÎÄÂÒÂë

mysql Ŀ¼Ï嵀 my.ini ÓÐÁ½´¦ÒªÐÞ¸Ä Ò»´¦ÊÇ [mysql] default-character-set=gbk »¹ÓÐÒ»´¦ÊÇ·ñÈϽ¨±íʱʹÓõÄ×Ö·û¼¯ default-character-set=gbk Á½´¦ÐÞ¸Äһϣ¬ÖØÐ½¨Á¢Êý¾Ý¿âºÍ±íºó¾Í²»»á³öÏÖÂÒÂëÁË¡£ ½¨±íʱҲ¿ÉÒÔÖ¸¶¨Êý¾Ý¿â»ò±íËùʹÓõÄ×Ö·û¼¯ Èç¹û²»ÄÜÖØ½¨Êý¾Ý¿âÔòÖ»ÄÜÔÚÖ¸¶¨µÄÊý¾Ý¿âĿ¼Ï°ѶÔÓ¦µÄ db.opt À ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ