MySQL µ¼Èëµ¼³öÃüÁî
×î½ü±ðÈËÔÚ¸øÎÒ sql Îļþʱ¼òµ¥µÄÌáÁËÏ µ¼Èë/µ¼³ö ÃüÁÔÚ´Ë»ù´¡ÉÏѧϰÁËÏ£¬×ܽᵽ myhere¡£
¹æ¶¨£º
Óû§Ãû£ºdb_user
Õʺţº db_pass
Êý¾Ý¿â£º db_name
񡜧 table_name_1, table_name_2
˵Ã÷£º һЩ²Ù×÷ÐèÒªÓÐÊʵ±µÄȨÏÞ¡£
1. µ¼³ö
mysqldump -udb_name -pdb_pass db_name > db_name.bak.sql
// µ¼³öÕû¸öÊý¾Ý¿â db_name
// ÎļþĬÈϱ£´æÔÚÖ´ÐÐ mysql ÃüÁîµÄĿ¼
mysqldump -udb_name -pdb_pass db_name table_name_1 > db_bame-table_name_1.bak.sql
// µ¼³öÊý¾Ý¿â db_name Öбí table_name_1
// ÎļþĬÈϱ£´æÔÚÖ´ÐÐ mysql ÃüÁîµÄĿ¼
// ˵Ã÷£ºµ¼³öµÄÎļþÊǺ¬Óн¨±íÓï¾äµÄ¡£
2. µ¼Èë
mysql -udb_name -pdb_pass db_name < table_name_1.bak.sql
// µ¼Èë±íµ½Êý¾Ý¿â db_name
// ÔÚûÓÐÁ¬½ÓÊý¾ÝµÄʱºòµ¼Èë
// ÎļþĬÈÏÔÚÖ´ÐÐ mysql ÃüÁîµÄĿ¼
source table_name_1.bak.sql
// ÒѾÁ¬½ÓºÃÊý¾Ý¿â·þÎñÆ÷£¬²¢ÇÒÑ¡ÔñÁËÊý¾Ý¿â use db_name
// ÎļþĬÈÏÔÚÖ´ÐÐ mysql ÃüÁîµÄĿ¼
// ˵Ã÷£º µ¼ÈëµÄÎļþÐèÊǺ¬Óмû±íÓï¾äµÄ¡£
3. select...into outfile select * from table_name_1 limit 20 into outfile 'db_name-table_name_1.bak.sql'
// ÎļþĬÈϵ¼³öµ½·þÎñÆ÷Êý¾Ý¿â db_name ËùÔÚĿ¼
select * from table_name_2 into outfile 'F:/db_name-table_name_1.bak2.sql'
// µ¼³öµ½ F Ŀ¼ÏÂ
// ˵Ã÷£º
// * ÕâÖÖ·½Ê½µ¼³öµÄÖ»ÓÐÊý¾Ý£¬ÊDZíÖеÄÒ»ÐÐÒ»ÐеÄÊý¾Ý
// * ÎļþÃû±ØÐëÓÃÒýºÅÒýÆðÀ´
4. load data infile...from load data infile 'db_name-table_name_1.bak.sql' into table table_name_1
// µ¼ÈëÊý¾Ýµ½ db_name Öбí table_name_1
// ÐèÏÈÑ¡ÖÐ db_name£¬
// ĬÈÏ db_name-table_name_1.bak.sql ·ÅÔÚ·þÎñÆ÷Êý¾Ý¿â db_name Ŀ¼ÏÂ
load data infile 'F:/db_name-table_name_1.bak2.sql' into table table_name_1
//
load data local infile 'F:/db_name-table_name_1.bak.sql' into table table_name_1
// ¼Ó local,ÎļþÏȱ»¿Í»§Ö÷»úÉϵĿͻ§¶Ë¶ÁÈ¡£¬È»ºó·¢µ½·þÎñÆ÷
// Òò´ËʹÓà local ËÙ¶È»áÉÔÂý
Ïà¹ØÎĵµ£º
²ÉÓõÄÊÇMySql¹Ù·½ÌṩµÄ.NET connector£¬´ËÇý¶¯Ö»ÐèÒªÏÂÔØ¼´¿ÉʹÓãºhttp://dev.mysql.com/downloads/connector/net/1.0.html
ÔÚʹÓÃÖлýÀÛÁ˼¸µã¾Ñ飺
1)ʹÓÃParameter²ÎÊýÐÎʽÌá½»Commandʱ±ØÐëÒª°Ñ"@"ºÅ»»³É"?"ºÅ£¬ÕâÒ»µãÈÃÎÒÀ§»óÁËÒ»Ì죬ֻÊDz»Ã÷°×MySQLΪºÎÒª¸ãÌØÊâÄØ£¬ÏóMS¡¢ODP.NE ......
MysqlÊý¾Ý¿âÌṩÁ½ÖÖÀàÐ͵ÄË÷Òý£¬Èç¹ûûÕýÈ·ÉèÖã¬Ë÷ÒýµÄÀûÓÃЧÂÊ»á´ó´òÕÛ¿ÛÈ´ÍêÈ«²»ÖªÎÊÌâ³öÔÚÕâ¡£
CREATE TABLE test (
id INT NOT NULL,
last_name CHAR(30) NOT NULL,
first_name CHAR(30) NOT NULL,
PRIMARY KEY (id),
INDEX name (last_name,first_name)
);
ÒÔÉÏ´ ......
[Ó²¼þÅäÖÃ]
CPU : AMD2500+ (1.8G)
ÄÚ´æ: 1G/ÏÖ´ú
Ó²ÅÌ: 80G/IDE
[Èí¼þÅäÖÃ]
OS : Windows XP SP2
SE : PHP5.2.1
DB : MySQL5.0.37
Web: IIS6
[MySQL±í½á¹¹]
CREATE TABLE `myisam` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) default NULL,
`content` text,
&nbs ......
20 MySQL¿Í»§¹¤¾ßºÍAPI
20.1 MySQL C API
C API´úÂëÊÇËæMySQL·Ö·¢µÄ£¬Ëü±»°üº¬ÔÚmysqlclient¿âÇÒÔÊÐíC³ÌÐò´æÈ¡Ò»¸öÊý¾Ý¿â¡£
ÔÚ MySQLÔ´´úÂë·Ö·¢Öеĺܶà¿Í»§ÊÇÓÃC±àдµÄ¡£Èç¹ûÄãÕýÔÚѰÕÒÑÝʾÔõÑùʹÓÃC APIµÄÀý×Ó£¬¿´Ò»ÏÂÕâЩ¿Í»§³ÌÐò¡£
´ó¶àÊýÆäËû¿Í»§ API(³ýÁËJavaµÄËùÓÐ)¶¼Ê¹ÓÃmysqlclient¿âÓëMySQL·þÎñÆ÷ͨÐÅ ......
mysql alter Óï¾äÓ÷¨,Ìí¼Ó¡¢Ð޸ġ¢É¾³ý×ֶεÈ
//Ö÷¼ü549830479
alter table tabelname add new_field_id int(5) unsigned default 0 not null auto_increment ,add primary key (new_field_id);
//Ôö¼ÓÒ»¸öÐÂÁÐ549830479
alter table t2 add d timestamp;
alter table infos add ex tinyint not null default ......