mysql Ôõôɾ³ýÎ¨Ò»Ô¼Êø£¿
±íÃû nnn ÁÐÃû myname£¨¿ÉÒÔΪ¿Õ£©
Ïëɾ³ýÎ¨Ò»Ô¼Êø
MYSQLÓÐÇëСÁº
GoogleÕÒÁ˰ëÌ죬ºÜÎÞÁ¦¡«¡«£¬Ö»ÕÒµ½´´½¨£¬Ã»ÕÒµ½É¾³ý
ÕæÊÇÖ»¹Ü½á»é²»¹ÜÉúº¢×Ó¡«¡«¡«¡«
mysql> show create table nnn;
+-------+------------------------------------------
---------------------------------------------------
-------------------------------------------+
| Table | Create Table
|
+-------+------------------------------------------
---------------------------------------------------
-------------------------------------------+
| nnn | CREATE TABLE `nnn` (
`id` int(11) NOT NULL auto_increment,
`myname` varchar(20) default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `myname` (`myname`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312 |
+-------+------------------------------------------
---------------------------------------------------
-------------------------------------------+
1 row in set (0.00 sec)
´ó¸ç£¬ÎÒÕÒÄãºÃ¾ÃÁË
SQL code
Code highlighting produced by Actipro CodeHighlighter
Ïà¹ØÎÊ´ð£º
ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£
win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£
µ±È»Äã×î ......
ÎÒ֮ǰµ¼ÈëµÄÊý¾Ý¿â£¬ÏÖÔÚɾ³ý²»ÁË£¬ÓÃÁËÃüÁîÐк͹¤¾ß¶¼²»ÐУ¬ÖØÆôÒ²²»ÐУ¬ÕâÊÇÎªÊ²Ã´ÄØ£¿
ÄãÊÇÈçºÎɾ³ýµÄ£¿
ÓÐʲôÌáʾ£¿
ÎÊÌâ˵Ã÷Ô½Ïêϸ£¬»Ø´ðÒ²»áԽ׼ȷ£¡²Î¼ûÈçºÎÌáÎÊ¡££¨ÌáÎʵÄÖǻۣ©
......
MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now()
SQL code:
sqlÀïÊÇ£º
getdate()
ÒýÓÃ
now()
ѧϰ
SQL code:
select now();
SQL code:
TODAY()
?
SQL code:
select now();
/* ......
ÎÒÏÖÔÚÓÐÒ»¸ö±í,itemµÄ±í
±í×Ö¶Î:id text
ÓÐÒ»¸öarray('5','3','1','2','4')
idÖÐÓÐÖµ1 2 3 4 5 6 7 8 9 10,Õý³£ÅÅÐò
ÎÒÏÖÔÚÏëÒ ......
±ÈÈç±íAÓÐÒ»Ìõ¼Ç¼
ID Name Number GroupId
1 nm1 50493831 6
ID×Ö¶ÎÊDZíAµÄÖ÷¼ü£¬ÓÐ×Ô¶¯Ôö¼ÓµÄÊôÐÔ£¬GroupIdΪÁíÒ»¸ö±íBµÄ ......