MysqlÎļ¯
µ¼ÈëÊý¾ÝÖ¸¶¨ÁÐ
load data local infile 'D:\\service_func_utf8.txt' into table service_func fields terminated by '\t' (service_id, func_id1, func_id2, func_id3, func_id4, func_id5, func_id6);
MYSQL½«²éѯ½á¹ûµ¼³öµ½Îļþ
select * from tablename into outfile '/tmp/test.txt';
MYSQLÁªºÏÖ÷¼ü
create table oldmail(
id varchar(200) not null,
username varchar(255) not null ,
primary key(id,username)
)
3 mysqlµÄÖ÷¼üÎÊÌ⣺
MysqlµÄÁ½ÖÖÖ÷¼ü¡£Primary key ºÍnot null auto_incrimentÔÚ½¨Á¢mysql±íʱ£¬¸øÒ»¸ö×Ö¶ÎÌí¼ÓÁËÖ÷¼üprimary key ÔÚinsertÊý¾Ýʱ¿ÉÒÔ²»ÓÃinsertÖ÷¼ü£¬mysql»á×Ô¶¯Ìí¼Ó0£¬µ«ÊÇÔÚµÚ¶þ´ÎinsertʱûÓÐÌîдֵmysqlÊý¾Ý¿â»¹ÊÇĬÈÏÌí¼Ó0£¬»áµ¼ÖÂÓÐÖØ¸´µÄÖ÷¼ü£¬ÕâÊDz»¿ÉÒԵġ£ËùÓÐÔÚ¶¨ÒåÁËprimary keyʱ£¬ÔÚinsertÊý¾ÝʱҪ¸øÖ÷¼üÌîдֵ¡£ÔÚ½¨Á¢mysql±íʱ£¬¸øÒ»¸ö×Ö¶ÎÌí¼ÓÁËÖ÷¼ünot null auto_increment=1;ÕâÒ²ÊÇÒ»¸öÖ÷¼ü¡£Ê±×ÔÔö³¤µÄÒÔ1Ϊ¿ªÊ¼¡£Õâ¸ö×Ö¶ÎÊÇ¿ÉÒÔ²»ÓÃÌîдֵµÄ£¬mysqlÊý¾Ý¿â»á×Ô¶¯¸øÌîдֵ£¬²»»á³öÏÖprimary keyµÄ×´¿ö¡£Alter table tb add primary key(id);Alter table tb change id id int(10) not null auto_increment=1;
4 ɾ³ý×ÔÔö³¤µÄÖ÷¼üidÏÈɾ³ý×ÔÔö³¤ÔÚɾ³ýÖ÷¼ü
Alter table tb change id id int(10);//ɾ³ý×ÔÔö³¤
Alter table tb drop primary key;//ɾ³ýÖ÷½¨
ÖØÃüÃû±í
ALTER TABLE ¾É±íÃû RENAME TO бíÃû;
Ïà¹ØÎĵµ£º
MYSQLÓжàÖÖ´æ´¢ÒýÇæºÍ±íÀàÐÍ£¬InnoDBºÍBDBÖ§³ÖÊÂÎñ£¬Èç¹ûҪʹÓÃÊÂÎñ£¬±íµÄÀàÐ;ÍÓ¦¸ÃÊÇInnoDB.
Ìá¸ß±íµÄÐÔÄÜ£º
1¡¢ÓÃ×îСµÄÊý¾ÝÀàÐÍ¡£Õ¼ÓÿռäС£¬½ÚÊ¡´ÅÅ̿ռäºÍÄÚ´æ¡£
2¡¢±í¸ñµÄÖ÷Ë÷ÒýÒª¾¡¿ÉÄܵĶ̣¬ÒÔÃ÷ÏÔÌá¸ßЧÂÊ¡£
3¡¢Ë÷Òý×îºÃ½¨ÔÚΨһµÄÁÐÉÏ£¬Ë÷ÒýÔ½¶Ì£¬ËÙ¶ÈÔ½¿ì¡£
4¡¢¶àÁÐË÷Òý±ØÐë°üº¬×î×ó±ßµÄǰ׺²ÅÓÐЧ¡£ ......
½ñÌìµÄѧϰÄÚÈÝÊÇsqliteºÍPDO mysql¡£
ÓÃ×Ô¼ºµÄ»°ËµËµÁ½¸ö¶«Î÷°É£º
sqliteËãÊÇÒ»ÖÖ²»ÏµÍ³µÄÊý¾Ý¿â´æ´¢·½Ê½£¬ËüµÄ´æ·Å¸ñʽÊÇÒ»¸ö.dbºó׺µÄÎļþ£¬ÔÚphpÖÐËü´æ·ÅÔÚµ±Ç°µÄĿ¼Ï£¬Ã²ËƲ»ÓÃÓû§ÃûÃÜÂ룬°²È«ÐԽϵͣ¬È´±È½Ï·½±ã¡£PHP5ÖÐ×Ô´øµÄһЩϵͳº¯Êý£¬¶¼ÊÇÒÔsqlite_¿ªÍ·µÄ¡£
PDOÈ«³ÆPHP Data Object£¬¹ËÃû˼Òå¾ÍÊÇPHPµÄÒ ......
1.mysqlÖ÷´ÓÊý¾Ý¿âͬ²½ÎÊÌâ
ÔÚʹÓÃmysql 5.0 Ö÷´ÓÊý¾Ý¿âͬ²½Ê±Óöµ½ÎÊÌâһЩÎÊÌ⣺
ÔÚÖ÷´ÓÊý¾Ý¿âͬ²½Ê±£¬ÎÒÃÇ¿ÉÄÜ»áÑ¡ÔñÄÄЩÊý¾Ý¿âÒªÇóͬ²½£¬¶øÄÇЩÊý¾Ý¿âºöÊÓ£¬ÕâÁ½¸ö¹¦ÄÜÊÇ¿¿/etc/my.cnfÎļþÖеÄÁ½¸ö¼üÃû binlog_do_db ºÍ binlog_ignore_db À´ÊµÏÖµÄ
binlog_do_db = ÌîдÐèҪͬ²½µÄÊý¾Ý¿â£¬¶à¸öÊý¾Ý¿âÔòÓÃ&lsqu ......
¹ØÓÚ·ÖÒ³µÄÓÅ»¯¡£
ÎÒÃÇÖªµÀ£¬ÔÚMySQLÖзÖÒ³ºÜ¼òµ¥£¬Ö±½ÓLIMIT page_no,page_total ¾Í¿ÉÒÔÁË¡£
¿ÉÊǵ±¼Ç¼ÊýÂýÂýÔö´óʱ£¬Ëý¾Í²»ÄÇôºÃʹÁË¡£
ÕâÀïÎÒÃÇ´´½¨ÕªÒª±íÀ´¼Ç¼ҳÂëºÍÔ±íÖ®¼äµÄ¹ØÁª¡£
ÏÂÃæÎª²âÊÔÊý¾Ý¡£
Ô±í£º
CREATE TABLE `t_group` (
`id` int(11) NOT NULL auto_increment,
`money` decim ......
<?php
/*
* Ãû³Æ : MySQLÊý¾Ý¿â»ù±¾²Ù×÷
* ×÷Õß : pjx
* °æ±¾ : v 2010/02/25 v 1.0
* ˵Ã÷ : ¸ÃÀàÓÃÓÚ¶ÔMySQL×öһЩ¼òµ¥µÄ²Ù×÷
* ʾÀý £º
* ʵÀý => $db = new DB_MYSQL($database),´ò¸ö$databaseÊý¾Ý¿â
* ²éѯÊý¾Ý¿â => $db->query($sql_str),²éѯ$sql_st ......