***
Welcome...
Type ‘help;‘ or
‘h‘ for help. Type
‘c‘ to
clear the current input statement.
/* view databases */
mysql>
show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| leave_info_system |
| mysql |
| performance_schema |
| sys |
+--------------------+
5 rows
in set (
0.03 sec)
/* create new database */
mysql>
create database testDB;
Query OK, 1 row affected (
0.01 sec)
/* If you want to operate at a specific database, you have to change to the db */
mysql>
use testDB;
Database changed
/* create new tables in testDB */
mysql>
create table testTB(
-> testNum VARCHAR(
16) NOT NULL,
-> testName VARCHAR(
32) NOT NULL,
->
testDate DATE NOT NULL);
Query OK, 0 rows affected (
0.12 sec)
/* view fields in testTB */
mysql>
describe testTB;
+----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| testNum | varchar(
16) | NO | | NULL | |
| testName | varchar(
32) | NO | | NULL | |
| testDate |
date | NO | | NULL | |
+----------+-------------+------+-----+---------+-------+
3 rows
in set (
0.01 sec)
Create a database in mysql for mac
标签：arc use key blog system esc row ecif com
本文系统来源：http://www.cnblogs.com/22Kon/p/6713652.html
【说明】：
本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！