本人从来没有接触过MySql,平时做程序一直使用MS-SQl,对MySql一点也不了解,如果问出傻问题请多多见谅!
我最近装了一款MySql是5.0.27版本,请问在MS-SQl中T-Sql语句是打在查询分析器里的,换到MySql中T-Sql代码打在哪里?
非常感谢解答!
我最近装了一款MySql是5.0.27版本,请问在MS-SQl中T-Sql语句是打在查询分析器里的,换到MySql中T-Sql代码打在哪里?
非常感谢解答!
。
C:\Documents and Settings\daqun>cd\C:\>cd C:\Program Files\MySQL\MySQL Server 5.0\binC:\Program Files\MySQL\MySQL Server 5.0\bin>mysql -uroot -p密码
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 476 to server version: 5.0.16-ntType 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql>
mysql> use test2;
Database changed
mysql> select * from test2;
+------+------+------------+
| id | name | num |
+------+------+------------+
| 1 | a | 001 |
| 2 | b | 002 |
| 3 | d | 003 |
| 4 | d | 00003 |
| 5 | d | 001003 |
| 6 | d | 0010000000 |
+------+------+------------+
6 rows in set (0.05 sec)mysql>