首页 > 代码库 > MySQL Keynote

MySQL Keynote

MySQL Keynote

1、Keywords may be entered in any lettercase. The following queries are equivalent:

  技术分享

2、Here is another query. It demonstrates that you can use mysql as a simple calculator:

  技术分享

3、所有查询以;结尾。

4、显示数据库。 SHOW DATABASES does not show databases that you have no privileges

  技术分享

5、If the test database exists, try to access it:

  技术分享

6、创建数据库。

  技术分享

  nder Unix, database names are case sensitive (unlike SQL keywords), so you must always refer to your database as menagerie, not asMenagerieMENAGERIE, or some other variant. 

7、显示tables

  技术分享

8、查看表定义.

  技术分享

 

9、使用insert插入数据

  技术分享

10、更新数据 

  技术分享

参考:https://dev.mysql.com/doc/refman/5.7/en/entering-queries.html

MySQL Keynote