MySQL
lihongye_10
aim to be a java expert.
展开
-
MySQL display data structure using command line
1. show the table data struction:describe table_name;2. show the table you have created as well as the sql you used creating this ta原创 2011-09-25 13:58:12 · 451 阅读 · 0 评论 -
MySQL import SQL file using comand line
1. Click "Start" Menu, input "cmd", then click Enter.2. Type the following command:mysql -u -p For example:mysql -u test -p原创 2011-09-27 13:41:22 · 1073 阅读 · 0 评论 -
navicat 快捷键
1.ctrl+q 打开查询窗口2.ctrl+/ 注释sql语句3.ctrl+shift +/ 解除注释4.ctrl+r 运行查询窗口的sql语句5.ctrl+shift+r 只运行选中的sql语句6.F6 打开一个mysql命令行窗口7.ctrl+l 删除一转载 2011-12-03 14:14:26 · 31069 阅读 · 3 评论