MySQL access through C #

1. MySQL does not use single quotes, but uses '(that is, the ~ in the upper left corner of the keyboard ~) , This is not a single quote'

2. Drop schema, drop Schema

3. Enumeration table

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. String Pattern Matching, regular expression:

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:] +'

To find"W"Name:

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       |

+----------+-------+---------+------+------------+------------+

To find a name that exactly contains five characters, use"_"Mode character:

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  |

+-------+--------+---------+------+------------+-------+

Regular Expression: http://dev.mysql.com/doc/refman/5.1/zh/regexp.html

Pattern Match: http://dev.mysql.com/doc/refman/5.1/zh/tutorial.html#pattern-matching

5. enumerate databasename

Select 'schema _ name' from 'information _ scheme'. 'schema'