摘要: CREATE TABLE EMP1 AS SELECT * FROM EMP WHERE EMPNO=1SELECT * INTO NEW_TABLE FROM EMP WHERE EMPNO=1 (IF NEW_TABLE IS EXIST ) 数据表基本操作1.create database name; //创建数据库 (create 内部命令)mysql>create database 数据库名;2.use databasename; //选择数据库 (use内部命令)mysql>use 数据库名;3.drop database name; //直接删除数据库,不提醒 (dr 阅读全文
posted @ 2013-05-30 12:33 Auther709 阅读(278) 评论(0) 推荐(0) 编辑