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;//ÉèÖÃΪµÚÒ»ÁÐ
Ïà¹ØÎĵµ£º
<?php
/*
* by:lenush
* qicq:707207845
* email:lenus-h@163.com
* site:www.hackthiswebsite.cn
* that's all
*
*/
class mysql{
private $db_host; //Êý¾Ý¿âÖ÷»ú
private $db_user; //Êý¾Ý¿âÓû§Ãû
private $d ......
mysql³ö´íÁË,ÒÔǰÍùÍù¿¿²Â.ÓÐÁËÕâÕűí,Ò»²é¾Í³öÀ´ÁË.·½±ã²»ÉÙ.ÌØ¹²ÏíÓÚÖÚ
1005£º´´½¨±íʧ°Ü
1006£º´´½¨Êý¾Ý¿âʧ°Ü
1007£ºÊý¾Ý¿âÒÑ´æÔÚ£¬´´½¨Êý¾Ý¿âʧ°Ü
1008£ºÊý¾Ý¿â²»´æÔÚ£¬É¾³ýÊý¾Ý¿âʧ°Ü
1009£º²»ÄÜɾ³ýÊý¾Ý¿âÎļþµ¼ÖÂɾ³ýÊý¾Ý¿âʧ°Ü
1010£º²»ÄÜɾ³ýÊý¾ÝĿ¼µ¼ÖÂɾ³ýÊý¾Ý¿âʧ ......
1¡¢mysql Êý¾Ý¿âûÓÐÔöÁ¿±¸·ÝµÄ»úÖÆ£¬µ±Êý¾ÝÁ¿Ì«´óµÄʱºò±¸·ÝÊÇÒ»¸öºÜ´óµÄÎÊÌâ¡£»¹ºÃ mysql Êý¾Ý¿âÌṩÁËÒ»ÖÖÖ÷´Ó±¸·ÝµÄ»úÖÆ£¬Æäʵ¾ÍÊǰÑÖ÷Êý¾Ý¿âµÄËùÓеÄÊý¾Ýͬʱдµ½±¸·ÝÊý¾Ý¿âÖС£ÊµÏÖ mysql Êý¾Ý¿âµÄÈȱ¸·Ý¡£
¡¡¡¡2¡¢ÒªÏëʵÏÖË«»úµÄÈȱ¸Ê×ÏÈÒªÁ˽âÖ÷´ÓÊý¾Ý¿â·þÎñÆ÷µÄ°æ±¾µÄÐèÇó¡£ÒªÊµÏ ......
1¡¢Èç¹ûʹÓÃsqlite3ʱ³öÏÖÈçÏ´íÎó£º
/!\ FAILSAFE /!\ Thu Jul 30 22:16:15 +0800 2009
Status: 500 Internal Server Error
unknown error
c:/ruby/lib/ruby/1.8/dl/import.rb:29:in `initialize'
c:/ruby/lib/ruby/1.8/dl/import.rb:29:in `dlopen'
&nb ......
1¡¢´´½¨Ò»¸öÊý¾Ý¿â
create database Êý¾Ý¿âÃû
2¡¢´´½¨Ò»¸öÊý¾Ý±í
create table Êý¾Ý±íÃû(
×Ö¶ÎÃû ÀàÐÍ(³¤¶È),
×Ö¶ÎÃû ÀàÐÍ(³¤¶È),
×Ö¶ÎÃû ÀàÐÍ(³¤¶È),
×Ö¶ÎÃû ÀàÐÍ(³¤¶È),
......
×Ö¶ÎÃû ÀàÐÍ(³¤¶È)
);
3¡¢²é¿´Êý¾Ý±í½á¹¹
describe Êý¾Ý±íÃû;
4¡¢²åÈëÒ»ÌõмǼ
insert into Êý¾Ý±íÃû values(Öµ1,Öµ2,....Öµn ......