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λÊý×Ö
Ïà¹ØÎĵµ£º
====================================================
Òý×Ô£ºhttp://blog.sina.com.cn/s/blog_538a9d1901008f9g.html
ʲôÊÇC2¼¶°²È«ÐÔ£¿°²È«ÐԵķÖÀàÊÇÔõÑùµÄ£¿(2008-01-30 17:04:39)
DÀࣺ×îµÍ±£»¤£¬±£Áô¸ø²»ÄÜͨ¹ý¸ü¸ß¼¶±ð¼ì²éµÄϵͳ
C1£º½÷É÷±£»¤£¬ÒªÇóÓлùÓÚÓû§¼¶±ðµÄ¿ØÖÆÀ´±£»¤Êý¾Ý£¬Ö÷Òª·ÀÖ ......
¡¾ÊéÃû¡¿¸ßÐÔÄÜMySQL£¨µÚ¶þ°æ£©
¡¾ÔÊéÃû¡¿High Performance MySQL, second edition
¡¾×÷Õß¡¿Baron Schwartz£¬Peter Zaitsev£¬Vadim
Tkachenko£¬Jeremy D.Zawodny£¬Arjen Lentz£¬Derek
J.Balling Öø
¡¾ÒëÕß¡¿ÍõС¶« Àî¾ü ¿µ½¨Ñ« Òë
¡¾³ö°æÉç¡¿µç×Ó¹¤Òµ³ö°æÉç
¡¾ÊéºÅ¡¿978- ......
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 ......
1. Á¬½Ómysql:
mysql -h Ö÷»úµØÖ· -u Óû§Ãû £p
2.Í˳ömysql:exit
3. ÐÞ¸ÄÃÜÂë:
mysqlbinmysqladmin -uroot -p(oldpassword) password newpassword
4.Ôö¼ÓÓû§£º
Ìí¼ÓÒ»¸öÓû§test1 ÃÜÂëΪABC£»ÈÃËû¿ÉÒÔÔÚÈκÎÖ÷»úÉϵǼ,²¢¶ÔËùÓÐÊý¾Ý¿âÓвéѯ¡¢²åÈë¡¢Ð޸ġ¢É¾³ýµÄȨÏÞ¡£Ê×ÏÈÓÃÒÔrootÓû§Á¬Èë
mysql,È»ºó¼üÈëÒÔÏÂÃü ......
1.myisam±í²»Ö§³ÖÍâ¼ü£¬innodb²ÅÖ§³ÖÍâ¼ü
2.mysqlÍâ¼üµÄÁÐÀàÐͺÍÖ÷±íÖÐÏàÓ¦µÄÖ÷¼üÁÐÀàÐͱØÐëÒ»Ö£¬¼´ÀàÐÍÒ»Ö¡¢³¤¶ÈÒ»Ö£¬·ñÔò»á±¨´í¡£ERROR 1005: Can't create table (errno: 150)
3.ÔÚÒ»¸öÊý¾Ý¿âÖÐÍâ¼üÃû×Ö²»ÄÜÖØ¸´£¬·ñÔò»á±¨ERROR 1005: Can't create table 'XXXXXX' (errno: 121) ......