From http://dev.mysql.com/doc/mysql/en/index.htmlmysql> CREATE DATABASE menagerie; mysql> USE menagerie Database changed mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20), -> species VARCHAR(20), sex CHAR(1), birth DATE, death DATE); mysql> INSERT INTO pet -> VALUES ('Puffball','Diane','hamster','f','1999-03-30',NULL); mysql> SELECT * FROM pet; ...... mysql> exit
你的服务能启动吗? 启动后才可以啊D:\>cd mysqlD:\mysql>cd binD:\mysql\bin>mysql Welcome to the MySQL monitor Your MySQL connection id isType 'help;' or '\h' for helmysql> use database1;//database1已经存在 Database changed mysql> select * from table1;
我建议你 USE test 然后在test数据库上创建表格,因为你默认权限是不能创建数据库的,除非你改权限或用root登录
建议使用MySQL Control Center 就和sqlserver的企业管理器差不多了 操作很容易的:)
mysql我没用过,和大家学习!
谢谢各位大哥,问题解决了,我按如下操作即可,不报错,可这样操作mysql好麻烦啊,请大哥推荐一个当今最普遍用的可视化的mysql软件, dep_boy(力狼) ,发一份我吧 [email protected] 操作为:我在开始处运行mysql,打开dos黑屏后,输入密码,按enter键后, mysql> CREATE DATABASE note; mysql> USE note Database changedCREATE TABLE admin ( admin_name char(20) NOT NULL, admin_password char(20) NOT NULL, PRIMARY KEY(admin_name) ) TYPE=MyISAM;
mysql> USE menagerie
Database changed
mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20),
-> species VARCHAR(20), sex CHAR(1), birth DATE, death DATE);
mysql> INSERT INTO pet
-> VALUES ('Puffball','Diane','hamster','f','1999-03-30',NULL);
mysql> SELECT * FROM pet;
......
mysql> exit
需要我发给你[email protected]
启动后才可以啊D:\>cd mysqlD:\mysql>cd binD:\mysql\bin>mysql
Welcome to the MySQL monitor
Your MySQL connection id isType 'help;' or '\h' for helmysql> use database1;//database1已经存在
Database changed
mysql> select * from table1;
USE test
然后在test数据库上创建表格,因为你默认权限是不能创建数据库的,除非你改权限或用root登录
操作为:我在开始处运行mysql,打开dos黑屏后,输入密码,按enter键后,
mysql> CREATE DATABASE note;
mysql> USE note
Database changedCREATE TABLE admin (
admin_name char(20) NOT NULL,
admin_password char(20) NOT NULL,
PRIMARY KEY(admin_name)
) TYPE=MyISAM;