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ͳһÓÃlatin1µÄ±àÂë£¬ÕæÊǽÐÈ˿಻¿°ÑÔ¡£DjangoÓÃĬÈÏUTF8·ÃÎÊMYSQLÊý¾Ý¿â¡£ÔÚ²Ù×÷Êý¾Ý¿âʱ£¬²»¹ÜÄãÔõôתÂ룬×îÖÕдµ½Êý¾Ý¿âÀïµÄÖÐÎͼÊÇÂÒÂë¡£ÔÚÍøÉÏÕÒÁ˺ܾã¬Ò²Ã»½â¾öÕâ¸öÎÊÌâ¡£
ºóÀ´¿´ÁËÒ»¸öDJANGOµÄMYSQL²Ù×÷µÄÔ´Â룬·¢ÏÖÁËһЩÎÊÌâ ÏÈÊÇ/d ......
ÄÚ´æ±íʹÓùþϣɢÁÐË÷Òý°ÑÊý¾Ý±£´æÔÚÄÚ´æÖУ¬Òò´Ë¾ßÓм«¿ìµÄËÙ¶È£¬Êʺϻº´æÖÐСÐÍÊý¾Ý¿â£¬µ«ÊÇʹÓÃÉÏÊܵ½Ò»Ð©ÏÞÖÆ£¬ÒÔÏÂÊÇÀ¶²ÝʹÓõÄһЩ¸ÐÊÜ¡£
1¡¢heap¶ÔËùÓÐÓû§µÄÁ¬½ÓÊǿɼûµÄ£¬ÕâʹµÃËü·Ç³£ÊʺÏ×ö»º´æ¡£
2¡¢½öÊʺÏʹÓõij¡ºÏ¡£heap²»ÔÊÐíʹÓÃxxxTEXTºÍxxxBLOBÊý¾ÝÀàÐÍ£»Ö»ÔÊÐíʹÓÃ=ºÍ<=>²Ù×÷·ûÀ´ËÑË÷¼Ç¼£¨²» ......
½ñÌìµÄѧϰÄÚÈÝÊÇsqliteºÍPDO mysql¡£
ÓÃ×Ô¼ºµÄ»°ËµËµÁ½¸ö¶«Î÷°É£º
sqliteËãÊÇÒ»ÖÖ²»ÏµÍ³µÄÊý¾Ý¿â´æ´¢·½Ê½£¬ËüµÄ´æ·Å¸ñʽÊÇÒ»¸ö.dbºó׺µÄÎļþ£¬ÔÚphpÖÐËü´æ·ÅÔÚµ±Ç°µÄĿ¼Ï£¬Ã²ËƲ»ÓÃÓû§ÃûÃÜÂ룬°²È«ÐԽϵͣ¬È´±È½Ï·½±ã¡£PHP5ÖÐ×Ô´øµÄһЩϵͳº¯Êý£¬¶¼ÊÇÒÔsqlite_¿ªÍ·µÄ¡£
PDOÈ«³ÆPHP Data Object£¬¹ËÃû˼Òå¾ÍÊÇPHPµÄÒ ......
<?php
/*
* Ãû³Æ : MySQLÊý¾Ý¿â»ù±¾²Ù×÷
* ×÷Õß : pjx
* °æ±¾ : v 2010/02/25 v 1.0
* ˵Ã÷ : ¸ÃÀàÓÃÓÚ¶ÔMySQL×öһЩ¼òµ¥µÄ²Ù×÷
* ʾÀý £º
* ʵÀý => $db = new DB_MYSQL($database),´ò¸ö$databaseÊý¾Ý¿â
* ²éѯÊý¾Ý¿â => $db->query($sql_str),²éѯ$sql_st ......