Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

mysql Ôõôɾ³ýÎ¨Ò»Ô¼Êø£¿

±íÃû nnn ÁÐÃû myname£¨¿ÉÒÔΪ¿Õ£©

Ïëɾ³ýÎ¨Ò»Ô¼Êø


MYSQLÓÐÇëСÁº

GoogleÕÒÁ˰ëÌ죬ºÜÎÞÁ¦¡«¡«£¬Ö»ÕÒµ½´´½¨£¬Ã»ÕÒµ½É¾³ý

ÕæÊÇÖ»¹Ü½á»é²»¹ÜÉúº¢×Ó¡«¡«¡«¡«


ÒýÓÃ
show create table nnn;

ÌùÒ»ÏÂÄÚÈÝ¡£

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


Ïà¹ØÎÊ´ð£º

apache+PHP+mysqlÔÚwin7ÏÂʹÓÃ

ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£

win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£

µ±È»Äã×î ......

Mysql Êý¾Ý¿âɾ³ý²»ÁËÔõô°ì

ÎÒ֮ǰµ¼ÈëµÄÊý¾Ý¿â£¬ÏÖÔÚɾ³ý²»ÁË£¬ÓÃÁËÃüÁîÐк͹¤¾ß¶¼²»ÐУ¬ÖØÆôÒ²²»ÐУ¬ÕâÊÇÎªÊ²Ã´ÄØ£¿
ÄãÊÇÈçºÎɾ³ýµÄ£¿
ÓÐʲôÌáʾ£¿


ÎÊÌâ˵Ã÷Ô½Ïêϸ£¬»Ø´ðÒ²»áԽ׼ȷ£¡²Î¼ûÈçºÎÌáÎÊ¡££¨ÌáÎʵÄÖǻۣ©

......

MySqlÎÊÌâ

MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now()

SQL code:

sqlÀïÊÇ£º
getdate()

ÒýÓÃ
now()


ѧϰ

SQL code:
select now();

SQL code:
TODAY()
?

SQL code:
select now();
/* ......

mysql²éѯ½á¹ûÅÅÐòÎÊÌâ

ÎÒÏÖÔÚÓÐÒ»¸ö±í,itemµÄ±í

±í×Ö¶Î:id  text 

ÓÐÒ»¸öarray('5','3','1','2','4')

idÖÐÓÐÖµ1 2 3 4 5 6 7 8 9 10,Õý³£ÅÅÐò

ÎÒÏÖÔÚÏëÒ ......

ÇóÒ»ÌõMySqlÓï¾ä

±ÈÈç±íAÓÐÒ»Ìõ¼Ç¼
ID  Name    Number    GroupId
1    nm1  50493831      6

ID×Ö¶ÎÊDZíAµÄÖ÷¼ü£¬ÓÐ×Ô¶¯Ôö¼ÓµÄÊôÐÔ£¬GroupIdΪÁíÒ»¸ö±íBµÄ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ