1. 命令行登陆:
windows
>mysql -u root -p
>password
mac:
>./mysql -u root - p
>password
2. 查看表结构命令
mysql>describe table名称;
+-----------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+----------------+
| userId | int(11) | NO | PRI | NULL | auto_increment |
| loginNm | varchar(23) | NO | | NULL | |
| createdDt | datetime | NO | | NULL | |
| createdBy | int(11) | NO | | NULL | |
+-----------+-------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)
3. 插入数据命令
mysql>insert into User (userId,loginNm,createdDt,createdBy) values(-1,test,sysdate,-1);
mysql> select * from User;
+--------+---------+---------------------+-----------+
| userId | loginNm | createdDt | createdBy |
+--------+---------+---------------------+-----------+
| -1 | test | 2009-09-30 21:48:41 | -1 |
+--------+---------+---------------------+-----------+
1 row in set (0.00 sec)
4. 运行脚本命令
mysql>source 文件路径 //第一种方法
e.g. mysql>source /User/aa.sql
>
mysql -uroot -proot 数据库名
e.g. > mysql -uroot -proot test