Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ÖеÄ×Ö·û´®Á¬½Ó CONCAT(str1,str2,...)

·µ»ØÀ´×ÔÓÚ²ÎÊýÁ¬½áµÄ×Ö·û´®¡£Èç¹ûÈκβÎÊýÊÇNULL£¬·µ»ØNULL¡£¿ÉÒÔÓг¬¹ý2¸öµÄ²ÎÊý¡£Ò»¸öÊý×Ö²ÎÊý±»±ä»»ÎªµÈ¼ÛµÄ×Ö·û´®ÐÎʽ¡£
mysql> select CONCAT('My', 'S', 'QL');
-> 'MySQL'
mysql> select CONCAT('My', NULL, 'QL');
-> NULL
mysql> select CONCAT(14.3);
-> '14.3'
È磺update test set ......

linux mysqlÍü¼ÇÃÜÂëµÄ¶àÖÖ½â¾ö·½·¨¡£


ÎÒµÄϵͳÊÇubuntu6.06£¬×î½üÐÂ×°ºÃµÄmysqlÔÚ½øÈëmysql¹¤¾ßʱ£¬×ÜÊÇÓдíÎóÌáʾ:
# mysql -uroot -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
ʹÓÃÍøÉϽéÉܵķ½·¨ÐÞ¸ÄrootÓû§µÄÃÜÂ룺
# mysqladmin -uroot -p password 'newpassword'
Enter pass ......

SpringÅäÖÃmysqlÊý¾Ý¿â


<! -- beans ÔªËØÊÇSpringÅäÖÃÎļþµÄ¸ùÔªËØ£¬ËùÓеÄSpring µÄÅäÖÃÎļþ¶¼Ó¦°´ÈçϽṹÊéдһ¡µ
<beans>
<!Ò»ÅäÖÃid ΪdataSource µÄbean£¬¸Ãbean ÊǸöÊý¾ÝԴʵÀýÒ»¡µ
<bean ¹¤d="dataSource" class="org.apache.corrunons.dbcp.BasicDataSource"
destroy-method="close">
<! È·¶¨Êý¾ÝÔ´µÄÇ ......

mysqlÖвåÈëÒ»Ìõ¼Ç¼·µ»Ø¸Ã¼Ç¼id

1.select max(id) from user;
2.select last_insert_id() as id from user limit 1; 
(Õâ¸ö²âÊԵķµ»ØidÒ»Ö±ÊÇ0£¬ÓеãÎÊÌâ)
3.´¢´æ¹ý³Ì
1£©
oracelÖÐ
create sequence seqID
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
nocache
order;
create or replace procedure ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ