MySQL 通过 C#访问的一些问题



1.   MySQL 中不使用 单引号 , 而是用   `    ( 就是键盘左上角的那个~)   , 这个不是单引号 '      


2. drop schema , drop schema


3. 枚举表


  string MyConString = "SERVER=localhost;" +
                "DATABASE=information_schema;" +
                "UID=root;" +
                "PASSWORD=password;";


            var strSelect = @"select * from information_schema.tables where left(TABLE_SCHEMA,6)='galaxy'";


4.字符串的模式匹配, 正则表达式:

select * from information_schema.tables where left(TABLE_SCHEMA,6)='galaxy'


select * from information_schema.tables where  TABLE_SCHEMA REGEXP 'galaxy_ks_v6_s_[[:digit:]]+'



要想找出包含w的名字:

mysql> SELECT * FROM pet WHERE name LIKE '%w%';
+----------+-------+---------+------+------------+------------+
| name     | owner | species | sex  | birth      | death      |
+----------+-------+---------+------+------------+------------+
| Claws    | Gwen  | cat     | m    | 1994-03-17 | NULL       |
| Bowser   | Diane | dog     | m    | 1989-08-31 | 1995-07-29 |
| Whistler | Gwen  | bird    | NULL | 1997-12-09 | NULL       |
+----------+-------+---------+------+------------+------------+

要想找出正好包含5个字符的名字,使用_模式字符:

mysql> SELECT * FROM pet WHERE name LIKE '_____';
+-------+--------+---------+------+------------+-------+
| name  | owner  | species | sex  | birth      | death |
+-------+--------+---------+------+------------+-------+
| Claws | Gwen   | cat     | m    | 1994-03-17 | NULL  |
| Buffy | Harold | dog     | f    | 1989-05-13 | NULL  |
+-------+--------+---------+------+------------+-------+



正则表达式: http://dev.mysql.com/doc/refman/5.1/zh/regexp.html

模式匹配: http://dev.mysql.com/doc/refman/5.1/zh/tutorial.html#pattern-matching



5. 枚举DatabaseName

SELECT `SCHEMA_NAME` FROM `information_schema`.`SCHEMATA`

posted on 2012-10-05 16:49  norsd  阅读(135)  评论(0编辑  收藏  举报

导航