MYSQLÖÐÈçºÎ½øÐбíµÄ´¦Àí °ÑËü¸Ä³ÉÐèÒªµÄ±íµÄ½á¹¹
ÐÕÃû µç»° סַ ÓÊ±à ±àºÅ ÊÇ·ñÓз¿
±ä³É
ÐÕÃû µç»° ±àºÅ Óʱà ÊÇ·ñÓз¿ סַ ÊÔÓÃÆÚ Ê¹ÓÃÐÔÖÊ ×´Ì¬
ÇëÎʸ÷λͬ־ÃÅÈçºÎÐ޸İ¡ ¾Ù¸öÀý×Ó°Ñ ¼± ¼± ¼±~~~~~~~~
Ö±½Ó½¨Á¢ÐÂ±í£¬×Ö¶Î
ÐÕÃû µç»° ±àºÅ Óʱà ÊÇ·ñÓз¿ סַ ÊÔÓÃÆÚ Ê¹ÓÃÐÔÖÊ ×´Ì¬
ÔÙ²åÈë
insert into бí
(ÐÕÃû µç»° סַ ÓÊ±à ±àºÅ ÊÇ·ñÓз¿ )
select ÐÕÃû µç»° סַ ÓÊ±à ±àºÅ ÊÇ·ñÓз¿
from ¾É±í
CREATE TABLE ttaa2
(ÐÕÃû VARCHAR(10),µç»° VARCHAR(10),±àºÅ INT, Óʱà VARCHAR(10),
ÊÇ·ñÓз¿ BOOLEAN,סַ VARCHAR(10), ÊÔÓÃÆÚ DATE ,ʹÓÃÐÔÖÊ VARCHAR(10), ״̬ INT)
insert into бí
(ÐÕÃû,µç»°,סַ,Óʱà,±àºÅ,ÊÇ·ñÓз¿ )
select ÐÕÃû,µç»°,סַ,Óʱà,±àºÅ,ÊÇ·ñÓз¿
from ¾É±í
ÀïÃæµÄ×Ö¶ÎÊÇÂÒÐòµÄ ÎÒÏ뽨Á¢µÄбí¸úÀïÃæµÄ×Ö¶ÎÅÅÁв»Ò»Ñù
ÀýÈç:µØÖ· Óʱà ÐÕÃûµç»° ״̬
ÒªÐ޸ijÉÕâÑùµÄ½á¹¹
ÐÕÃû µç»° ״̬ ÓÊ±à µØÖ·
ÀïÃæ»¹Òª´©²åЩ ×Ö¶Î
ÇëÎÊÕâ¸ö±í¸ÃÈçºÎÐ޸ĺÍÕûÀí¡£
ûÓбØÒª°É£¬
Òªµ÷Õû×Ö¶Î˳Ðò£¬ÔÙ²åÈë×ֶΣ¬±È½Ï¸´ÔÓ
create table newtt
select ÐÕÃû,µç»°,space(10) as ±àºÅ,space(10) as Óʱà, 1 as ÊÇ·ñÓз¿,space(10) as סַ,
1 ÊÔÓÃÆÚ,1 as ʹÓÃÐÔÖÊ, ״̬ from oldtt
SQL code:
mysql> desc t_hiphopthehook;
+-------+---------+------+-----+---------+---
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
¼ÙÈçÊý¾Ý¿âÖÐÓиötest±í£¬±íÖÐÓÐid£¬Name£¬num£¬¼Ç¼ʱ¼ä
idΪ×ÔÔö³¤Ö÷¼ü£¬nameÊÇÃû×Ö£¬num±íʾÆäÊýÁ¿
1 nike 100 ϵͳʱ¼ä
2 nike 300 &n ......
ÎÒÏÖÔÚѧϰMYSQL£¬ÎÊÏÂmysql´¢´æ¹ý³ÌÈçºÎ½¨Á¢ºÍʹÓã¬×îºÃд³É$sql="sqlÓï¾ä",$re=mysql_query($sql);лл
½¨ÒéÄãÏÈ×Ô¼º¿´Ò»ÏÂÎĵµÖеÄÀý×Ó¡£
http://dev.mysql.com/doc/refman/5.1/zh/stored-pro ......
select * from table where '123456789' like '%'+×ֶαí+'%'
Õâ¾äsqlÔÚsqlserverÏÂͨ¹ý£¬ÔÚmysqlÏÂÓб¨´í£¬mysqlÏÂÈçºÎʵÏÖÕâÑùµÄ²éÑ¯ÄØ
SQL code:
select * from table whe ......
ÓÉÓÚÒÔǰûÓÐinnodbµÄÓ¦ÓþÑ飬ÔÚÅäÖÃinnodbµÄinnodb_data_file_pathÑ¡ÏîʱÓõÄÊÇĬÈÏÅäÖã¨ibdata1:10M:autoexte
nd£© ,½ñÌì·¢ÏÖ´ËÊý¾Ý¿âÔÚͬ²½Ö÷Êý¾Ý¿âÊý¾Ýʱ£¨´ËinnodbÊÇ×÷Ϊһ̨myisam dbµÄÀ䱸»úÆ÷£©£¬ibda ......