</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