MySQL数据库命令行笔记1.基本用法

</pre><p></p><pre name="code" class="sql">

mysql 命令行

创建数据库

mysql> create database raspberrypidb;
Query OK, 1 row affected (0.00 sec)

显示数据库

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| raspberrypidb      |
| test               |
+--------------------+
5 rows in set (0.01 sec)

选定数据库

mysql> use raspberrypidb;
Database changed
mysql> show tables;
Empty set (0.00 sec)

创建数据表

mysql> CREATE TABLE users (userid int auto_increment primary key, title varchar(20), fname varchar(20) , sname varchar(20), age int, email varchar(50) );
Query OK, 0 rows affected (2.17 sec)

显示数据表

mysql> show tables;
+-------------------------+
| Tables_in_raspberrypidb |
+-------------------------+
| users                   |
+-------------------------+
1 row in set (0.00 sec)

插入数据表内容

mysql> INSERT INTO users (title, fname, sname, age, email) VALUES ('Mr', 'Jake','Chen','16','somewhere@somedomain.com