Mysql µÄһЩ¼òµ¥µÄÃüÁî
¼ÇÏÂЩlinuxÏÂmysqlµÄ²Ù×÷£¬ÒÔ±ãÒÔºó²é¿´£º
1. Æô¶¯£¬¹Ø±Õmysql£º
Æô¶¯£ºsudo /etc/init.d/mysql start
¹Ø±Õ£º/usr/bin/mysqladmin -uroot -p shutdown
2.ÏÔʾ ±í½á¹¹£º
describe:tableName
3.±¸·Ý£º
Ö»±¸·Ý±í½á¹¹£ºmysqldump -d -uroot -p DataBase TableName> xxx.sql
±¸·Ý±í½á¹¹ºÍÊý¾Ý£ºmysqldump -uroot -p DataBase TableName> xxx.sql
4.»Ö¸´£º
mysql>source xxx.sql
5.Ð޸ıíÃû£º
alter table tableName rename to newTableName;
6:ɾ³ýÁУº
alter table tableName drop column columnName;
7:ÐÞ¸ÄÁÐÃû˳Ðò
alter table tableName modify fieldName fieldType after filedName
alter table tableName modify fieldName fieldType first;//ÉèÖÃΪµÚÒ»ÁÐ
Ïà¹ØÎĵµ£º
ΪʲôѡÔñÔ´Âë±àÒë°²×°mysql£ºÎÒÔÚʹÓÃrpm»òÕßÊÇyum°²×°Ê±myql£¬ÀÏÊÇÌáʾÎÒÕÒ²»µ½*.sockÎļþ£¬ÕÒÁ˵ã
×ÊÁÏ˵ÊǸðüÊǷǹٷ½°æ±¾£¨Ã÷Ã÷Êǹٷ½ÏÂÔØ µÄ£©£¬ÆäÖÐÔÒòµ½ÏÖÔÚ»¹Ã»ÓиãÇå³þ¡£Ï£ÍûÖªÇéÈËÊ¿¸æÖª¡££¨¿ªÊ¼±àÒëµÄʱºò£¬ÏµÍ³»·¾³Ò»¶¨ÒªÅäÖúã¬GCC£¬GC++...µÈµÈµÄ±àÒëÆ÷Ò»¶¨Òª×öºÃ,±¾È˵ÄcentosÓÉÓÚ¿ªÊ¼
ϵͳ»·¾³Ã»ÅäÖ ......
ÔÚmysqlÊÖ²áÀïÃæÓÐÒ»¶ÎÃèÊö¹ØÓÚlock tablesµÄÓï·¨µÄ. LOCK TABLES
tbl_name [AS alias] {READ [LOCAL] | [LOW_PRIORITY] WRITE}
[, tbl_name [AS alias] {READ [LOCAL] | [LOW_PRIORITY] WRITE}] ...
UNLOCK TABLES
READ
µ±±í²»´æÔÚ WRITE дËøʱ READ ¶ÁËø±»Ö´ÐÐ,Õâ¸Ã ......
1.Ê×ÏȵöÔmysql ÀïÃæµÄ²ÎÊý½øÐнéÉÜÏÂ:
procedure--in:ÊäÈë²ÎÊý,outÊä³ö²ÎÊý,inoutÕâ¸ö¾Í²»ÓÃ˵ÁË,´ó¸ÅÒ²²Âµ½ÁË
declare:ÉùÃ÷±äÁ¿.¼ÇÖ÷, ......
----------------------------------------------------------------------
--¸Ã´æ´¢¹ý³ÌÓû§´¦ÀíÐÅÏ¢,µ±Êý¾Ý²»´æÔÚ±íÖÐʱÔò²åÈç,·ñÔò¾Íɾ³ý
--Ö»ÓÃÁ˼òµ¥µÄÊÂÎñ,ÏÂÃ潫Óиü¸´ÔÓµÄÀý×Ó
--pro_produce ²úÆ·±í(pname.p_id(±àºÅ,Ö÷¼ü),ptime(Ìí¼Óʱ¼ä))
--
--
--
---------------------------------------------------- ......
×î½üÓöµ½ÕâÑùµÄÎÊÌâ
»á±¨at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1905)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2351)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.MysqlIO.sqlQuery ......