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

mysqlÖеÄÕýÔò±í´ïʽËÑË÷

Óï·¨£º
select * from table_name where column_name regexp 'ÕýÔò±í´ïʽ'
»òÇø·Ö´óСд
select * from table_name where column_name regexp binary 'ÕýÔò±í´ïʽ'
Ö§³ÖµÄÕýÔò±í´ïʽ·ûºÅ£º
.    ÈÎÒâ×Ö·û
|    »ò£¬È磺a|b|c
[]   ·¶Î§£¬±ÈÈ磺[a-z],[0-9],[^0-9]²»°üÀ¨0-9×Ö·û
^   ÔÚ[]ÖбíʾÅųý£¬·ñÔò±íʾƥÅ俪ͷ
\\   תÒ壬È磺\\\±íʾƥÅä\£¬\\.±íʾƥÅä.
*   0¸ö»ò¶à¸ö
+   1¸ö»ò¶à¸ö
?   0¸ö»ò1¸ö
{n}  n¸ö
{n,}  ²»ÉÙÓÚn¸ö
{n,m} nµ½m¸ö
$  Æ¥Åä½áβ
=====================
[:alnum:]  ÈÎÒâ×ÖĸºÍÊý×Ö£¬Ï൱ÓÚ[a-zA-Z0-9]
[:alpha:]   ÈÎÒâ×Ö·û[a-zA-Z]
[:blank:]   ¿Õ¸ñºÍÖÆ±í[\\t]
[:cntrl:]     ascii¿ØÖÆ×Ö·û
[:digit:]     Êý×Ö[0-9]
[:graph:][:print:]   ¿É´òÓ¡×Ö·û
[:lower:]   Сд×Öĸ
[:upper:]   ´óд×Öĸ
[:xdigit:]   Ê®Áù½øÖÆÊý[a-fA-F0-9]
ÀýÈ磺[[:digit:]]{4}£¬Æ¥ÅäÈÎÒâ4λÊý×Ö


Ïà¹ØÎĵµ£º

mysqlºÍoracle·ÖÒ³×¢Òâµã

ÕâÀïÊ×ÏÈ˵ÏÂoracle·ÖÒ³²»Ïñmysql·ÖÒ³ÄÇô¼òµ¥Ö±½Ólimit ¾Í¿ÉÒÔÁË.
mysql£ºsql ="select * from talbe limit 0,10";
µÚÒ»¸öÊý±íʾϱ꣬¾ÍÊÇ´ÓµÚ¼¸ÌõÊý¾Ý¿ªÊ¼£¬
µÚ¶þ¸öÊý±íʾÿҳÏÔʾ¶àÉÙÌõÊý¾Ý£¬¿ÉÒÔ˵Êǵ±ÄãÈ·¶¨Ã¿Ò³ÏÔʾ¶àÉÙÐÐʱºò£¬Ëü¾ÍÊÇÒ»¸ö¹Ì¶¨µÄÊý¡£
ÕâÀïÐèҪעÒâµÄÊÇ£¬mysqlµÄ·ÃÎÊϱêÊÇ´Ó0¿ªÊ¼µÄ¡£Õ ......

mysqlµÄÈýÖÖ°²×°·½Ê½

°²×°µÄOSΪSolaris10,mysql °æ±¾ÊÇ5.1.38
Ò»¡¢Ê¹ÓÃRPM°ü½øÐа²×°

    Ê×ÏÈ¿ÉÒÔ´Ó°²×°¹âÅÌÖлòÕßµ½mysqlµÄÍøÕ¾ÉÏÏÂÔØ¶ÔÓ¦°æ±¾µÄrpm°üÈçÏ£º
MySQL-server-community-5.1.38-0.rhel5.i386.rpm
MySQL-client-community-5.1.38-0.rhel5.i386.rpm
    ½Ó×ÅÎÒÃÇ¿ÉÒÔʹÓÃrpmÃü ......

Mysql ¸´ÖÆ±í¼°½á¹¹

Ò»¡¢CREATE TABLE ·½·¨
Õû±í¸´ÖÆ # create table бí select * from ¾É±í;
½á¹¹¸´ÖÆ # create table бí select * from ¾É±í where 1<>1;
¶þ¡¢INSERT INTO ·½·¨
µÃµ½½¨±íÓï¾ä # show create table ¾É±í;
н¨±í
¸´ÖÆÊý¾Ýµ½Ð±í INSERT INTO new_table(col1,col2,...) (SELECT col1,col2,... from old_table); ......

mysql´æ´¢¹ý³ÌÖвÎÊýµÄin,out,inoutÇø±ð


MySQL´æ´¢¹ý³ÌµÄ²ÎÊýÓÃÔÚ´æ´¢¹ý³ÌµÄ¶¨Ò壬¹²ÓÐÈýÖÖ²ÎÊýÀàÐÍ,IN,OUT,INOUT,ÐÎʽÈ磺
CREATE PROCEDURE([[IN |OUT |INOUT ] ²ÎÊýÃû Êý¾ÝÀàÐÎ...])
1¡¢IN ÊäÈë²ÎÊý:±íʾ¸Ã²ÎÊýµÄÖµ±ØÐëÔÚµ÷Óô洢¹ý³Ìʱָ¶¨£¬ÔÚ´æ´¢¹ý³ÌÖÐÐ޸ĸòÎÊýµÄÖµ²»Äܱ»·µ»Ø£¬ÎªÄ¬ÈÏÖµ
2¡¢OUT Êä³ö²ÎÊý:¸ÃÖµ¿ÉÔÚ´æ´¢¹ý³ÌÄÚ²¿±»¸Ä±ä£¬²¢¿É·µ»Ø
3¡¢I ......

mysqlÖÐcountº¯Êý×¢ÒâÊÂÏî

񡜧
CREATE TABLE `user` (
  `id` int(5) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(10) DEFAULT NULL,
  `password` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1
ÆäÖÐÓÐÊý¾ÝΪ£º
1 name1 123456
2&nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ