创建emp和dept

最新推荐文章于 2021-02-18 22:08:44 发布
最新推荐文章于 2021-02-18 22:08:44 发布
阅读量861 收藏
点赞数
分类专栏： mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/wangshuminjava/article/details/79832009
版权





create table dept(
deptno int ,
dname varchar(14) ,
loc varchar(13) 
) ;


create table emp(
eno int ,
ename varchar(10),
job varchar(9),
mgr int,
hirdate date,
sal int,
comm int,
deptno int not null
);
INSERT INTO dept VALUES(10,'ACCOUNTING','NEW YORK');
INSERT INTO dept VALUES(20,'RESEARCH','DALLAS');
INSERT INTO dept VALUES(30,'SALES','CHICAGO');
INSERT INTO dept VALUES(40,'OPERATIONS','BOSTON');
INSERT INTO emp VALUES(7369,'SMITH','CLERK',7902,'1980-12-17',800,NULL,20);
INSERT INTO emp VALUES(7499,'ALLEN','SALESMAN',7698,'1981-02-20',1600,300,30);
INSERT INTO emp VALUES(7521,'WARD','SALESMAN',7698,'1981-02-22',1250,500,30);
INSERT INTO emp VALUES(7566,'JONES','MANAGER',7839,'1981-04-02',2975,NULL,20);
INSERT INTO emp VALUES(7654,'MARTIN','SALESMAN',7698,'1981-09-28',1250,1400,30);
INSERT INTO emp VALUES(7698,'BLAKE','MANAGER',7839,'1981-05-01',2850,NULL,30);
INSERT INTO emp VALUES(7782,'CLARK','MANAGER',7839,'1981-06-09',2450,NULL,10);
INSERT INTO emp VALUES(7788,'SCOTT','ANALYST',7566,'1987-06-13',3000,NULL,20);
INSERT INTO emp VALUES(7839,'KING','PRESIDENT',NULL,'1981-11-17',5000,NULL,10);
INSERT INTO emp VALUES(7844,'TURNER','SALESMAN',7698,'1981-09-08',1500,0,30);
INSERT INTO emp VALUES(7876,'ADAMS','CLERK',7788,'1987-06-13',1100,NULL,20);
INSERT INTO emp VALUES(7900,'JAMES','CLERK',7698,'1981-12-03',950,NULL,30);
INSERT INTO emp VALUES(7902,'FORD','ANALYST',7566,'1981-12-03',3000,NULL,20);
INSERT INTO emp VALUES(7934,'MILLER','CLERK',7782,'1983-01-23',1300,NULL,10);



 will not be shown, you would have to be root to see it all.)

Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name    
tcp        0      0 0.0.0.0:111             0.0.0.0:*               LISTEN      -                   
tcp        0      0 192.168.72.142:8019     0.0.0.0:*               LISTEN      2165/java           
tcp        0      0 192.168.122.1:53        0.0.0.0:*               LISTEN      -                   
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      -                   
tcp        0      0 127.0.0.1:631           0.0.0.0:*               LISTEN      -                   
tcp        0      0 0.0.0.0:8480            0.0.0.0:*               LISTEN      2424/java           
tcp        0      0 0.0.0.0:8485            0.0.0.0:*               LISTEN      2424/java           
tcp6       0      0 192.168.72.142:3882     :::*                    LISTEN      1905/java           
tcp6       0      0 :::3306                 :::*                    LISTEN      -                   
tcp6       0      0 192.168.72.142:42827    :::*                    LISTEN      3136/java           
tcp6       0      0 :::40492                :::*                    LISTEN      1905/java           
tcp6       0      0 :::111                  :::*                    LISTEN      -                   
tcp6       0      0 :::8080                 :::*                    LISTEN      2971/java           
tcp6       0      0 :::8081                 :::*                    LISTEN      3136/java           
tcp6       0      0 192.168.72.142:6066     :::*                    LISTEN      2971/java           
tcp6       0      0 :::22                   :::*                    LISTEN      -                   
tcp6       0      0 ::1:631                 :::*                    LISTEN      -                   
tcp6       0      0 :::36664                :::*                    LISTEN      3560/java           
tcp6       0      0 192.168.72.142:44610    :::*                    LISTEN      3560/java           
tcp6       0      0 192.168.72.142:7077     :::*                    LISTEN      2971/java           
tcp6       0      0 :::2181                 :::*                    LISTEN      1905/java           
tcp6       0      0 192.168.72.142:34824    :::*                    LISTEN      3560/java           
tcp6       0      0 :::44232                :::*                    LISTEN      3560/java           
[wangshumin@CentOSNode2 ~]$  mysql -uroot -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[wangshumin@CentOSNode2 ~]$  cat /root/.mysql_secret
cat: /root/.mysql_secret: 权限不够
[wangshumin@CentOSNode2 ~]$ sudo  cat /root/.mysql_secret




[sudo] wangshumin 的密码：
对不起，请重试。
[sudo] wangshumin 的密码：
对不起，请重试。
[sudo] wangshumin 的密码：
# The random password set for the root user at Fri Apr  6 01:01:17 2018 (local time): pz9vuV6e0ATmSppY


[wangshumin@CentOSNode2 ~]$  mysql -uroot -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[wangshumin@CentOSNode2 ~]$  mysql -uroot -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[wangshumin@CentOSNode2 ~]$  mysql -uroot -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[wangshumin@CentOSNode2 ~]$  mysql -uroot -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[wangshumin@CentOSNode2 ~]$  mysql -uroot -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[wangshumin@CentOSNode2 ~]$  mysql -uroot -h CentOSNode2 -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'CentOSNode2' (using password: YES)
[wangshumin@CentOSNode2 ~]$  mysql -uroot -h CentOSNode2 -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'CentOSNode2' (using password: YES)
[wangshumin@CentOSNode2 ~]$  mysql -uroot -h CentOSNode2 -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 17
Server version: 5.6.36


Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.


Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.


Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


mysql>  select host,user ,password from user;
ERROR 1046 (3D000): No database selected
mysql> use mysql;
ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
mysql> SET PASSWORD = PASSWORD('root');
Query OK, 0 rows affected (0.24 sec)


mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A


Database changed
mysql> select host,user from user;
+-------------+------+
| host        | user |
+-------------+------+
| %           | root |
| 127.0.0.1   | root |
| ::1         | root |
| centosnode2 | root |
+-------------+------+
4 rows in set (0.00 sec)


mysql>  select host,user ,password from user;
+-------------+------+-------------------------------------------+
| host        | user | password                                  |
+-------------+------+-------------------------------------------+
| %           | root | root                                      |
| centosnode2 | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| 127.0.0.1   | root | *E2238AA1A058543BA0CF696A99FB4A6CDAD37B10 |
| ::1         | root | *E2238AA1A058543BA0CF696A99FB4A6CDAD37B10 |
+-------------+------+-------------------------------------------+
4 rows in set (0.00 sec)


mysql> flush privileges;
Query OK, 0 rows affected (0.08 sec)


mysql> exit;
Bye
[wangshumin@CentOSNode2 ~]$  mysql -uroot  -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[wangshumin@CentOSNode2 ~]$  mysql -uroot -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[wangshumin@CentOSNode2 ~]$  mysql -uroot -h CentOSNode2 -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 25
Server version: 5.6.36 MySQL Community Server (GPL)


Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.


Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.


Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


mysql> 
mysql> 
mysql> 
mysql> 
mysql> 
mysql> 
mysql> 
mysql> 
mysql> 
mysql> 
mysql> 
mysql> 
mysql> 
mysql> 
mysql> 
mysql> 
mysql> 
mysql> 
mysql> 
mysql> 
mysql> 
mysql> 
mysql> use test;
Database changed
mysql> show tables;
Empty set (0.00 sec)


mysql> create table dept(
    -> deptno int ,
    -> dname varchar(14) ,
    -> loc varchar(13) 
    -> ) ;
Query OK, 0 rows affected (0.58 sec)


mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| dept           |
+----------------+
1 row in set (0.00 sec)


mysql> desc dept;
+--------+-------------+------+-----+---------+-------+
| Field  | Type        | Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+-------+
| deptno | int(11)     | YES  |     | NULL    |       |
| dname  | varchar(14) | YES  |     | NULL    |       |
| loc    | varchar(13) | YES  |     | NULL    |       |
+--------+-------------+------+-----+---------+-------+
3 rows in set (0.08 sec)


mysql> create table emp(
    -> eno int ,
    -> ename varchar(10),
    -> job varchar(9),
    -> mgr int,
    -> hirdate date,
    -> sal int,
    -> comm int,
    -> deptno int not null
    -> );
Query OK, 0 rows affected (0.15 sec)


mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| dept           |
| emp            |
+----------------+
2 rows in set (0.00 sec)


mysql> desc emp
    -> ;
+---------+-------------+------+-----+---------+-------+
| Field   | Type        | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| eno     | int(11)     | YES  |     | NULL    |       |
| ename   | varchar(10) | YES  |     | NULL    |       |
| job     | varchar(9)  | YES  |     | NULL    |       |
| mgr     | int(11)     | YES  |     | NULL    |       |
| hirdate | date        | YES  |     | NULL    |       |
| sal     | int(11)     | YES  |     | NULL    |       |
| comm    | int(11)     | YES  |     | NULL    |       |
| deptno  | int(11)     | NO   |     | NULL    |       |
+---------+-------------+------+-----+---------+-------+
8 rows in set (0.00 sec)


mysql> INSERT INTO dept VALUES(10,'ACCOUNTING','NEW YORK');
Query OK, 1 row affected (0.09 sec)


mysql> INSERT INTO dept VALUES(20,'RESEARCH','DALLAS');
Query OK, 1 row affected (0.10 sec)


mysql> INSERT INTO dept VALUES(30,'SALES','CHICAGO');
Query OK, 1 row affected (0.07 sec)


mysql> INSERT INTO dept VALUES(40,'OPERATIONS','BOSTON');
Query OK, 1 row affected (0.02 sec)


mysql> select  * from dept ;
+--------+------------+----------+
| deptno | dname      | loc      |
+--------+------------+----------+
|     10 | ACCOUNTING | NEW YORK |
|     20 | RESEARCH   | DALLAS   |
|     30 | SALES      | CHICAGO  |
|     40 | OPERATIONS | BOSTON   |
+--------+------------+----------+
4 rows in set (0.03 sec)


mysql> INSERT INTO emp VALUES(7369,'SMITH','CLERK',7902,'1980-12-17',800,NULL,20);
7566,'JONES','MANAGER',7839,'1981-04-02',2975,NULL,20);
INSERT INTO emp VALUES(7654,'MARTIN','SALESMAN',7698,'1981-09-28',1250,1400,30);
INSERT INTO emp VALUES(7698,'BLAKE','MANAGER',7839,'1981-05-01',2850,NULL,30);
INSERT INTO emp VALUES(7782,'CLARK','MANAGER',7839,'1981-06-09',2450,NULL,10);
INSERT INTO emp VALUES(7788,'SCOTT','ANALYST',7566,'1987-06-13',3000,NULL,20);
INSERT INTO emp VALUES(7839,'KING','PRESIDENT',NULL,'1981-11-17',5000,NULL,10);
INSERT INTO emp VALUES(7844,'TURNER','SALESMAN',7698,'1981-09-08',1500,0,30);
INSERT INTO emp VALUES(7876,'ADAMS','CLERK',7788,'1987-06-13',1100,NULL,20);
INSERT INTO emp VALUES(7900,'JAMES','CLERK',7698,'1981-12-03',950,NULL,30);
INSERT INTO emp VALUES(7902,'FORD','ANALYST',7566,'1981-12-03',3000,NULL,20);
INSERT INTO emp VALUES(7934,'MILLER','CLERK',7782,'1983-01-23',1300,NULL,10);
Query OK, 1 row affected (0.08 sec)


mysql> INSERT INTO emp VALUES(7499,'ALLEN','SALESMAN',7698,'1981-02-20',1600,300,30);
Query OK, 1 row affected (0.00 sec)


mysql> INSERT INTO emp VALUES(7521,'WARD','SALESMAN',7698,'1981-02-22',1250,500,30);
Query OK, 1 row affected (0.02 sec)


mysql> INSERT INTO emp VALUES(7566,'JONES','MANAGER',7839,'1981-04-02',2975,NULL,20);
Query OK, 1 row affected (0.01 sec)


mysql> INSERT INTO emp VALUES(7654,'MARTIN','SALESMAN',7698,'1981-09-28',1250,1400,30);
Query OK, 1 row affected (0.00 sec)


mysql> INSERT INTO emp VALUES(7698,'BLAKE','MANAGER',7839,'1981-05-01',2850,NULL,30);
Query OK, 1 row affected (0.00 sec)


mysql> INSERT INTO emp VALUES(7782,'CLARK','MANAGER',7839,'1981-06-09',2450,NULL,10);
Query OK, 1 row affected (0.01 sec)


mysql> INSERT INTO emp VALUES(7788,'SCOTT','ANALYST',7566,'1987-06-13',3000,NULL,20);
Query OK, 1 row affected (0.00 sec)


mysql> INSERT INTO emp VALUES(7839,'KING','PRESIDENT',NULL,'1981-11-17',5000,NULL,10);
Query OK, 1 row affected (0.02 sec)


mysql> INSERT INTO emp VALUES(7844,'TURNER','SALESMAN',7698,'1981-09-08',1500,0,30);
Query OK, 1 row affected (0.00 sec)


mysql> INSERT INTO emp VALUES(7876,'ADAMS','CLERK',7788,'1987-06-13',1100,NULL,20);
Query OK, 1 row affected (0.03 sec)


mysql> INSERT INTO emp VALUES(7900,'JAMES','CLERK',7698,'1981-12-03',950,NULL,30);
Query OK, 1 row affected (0.03 sec)


mysql> INSERT INTO emp VALUES(7902,'FORD','ANALYST',7566,'1981-12-03',3000,NULL,20);
Query OK, 1 row affected (0.00 sec)


mysql> INSERT INTO emp VALUES(7934,'MILLER','CLERK',7782,'1983-01-23',1300,NULL,10);
Query OK, 1 row affected (0.00 sec)


mysql> select  * from emp ;
+------+--------+-----------+------+------------+------+------+--------+
| eno  | ename  | job       | mgr  | hirdate    | sal  | comm | deptno |
+------+--------+-----------+------+------------+------+------+--------+
| 7369 | SMITH  | CLERK     | 7902 | 1980-12-17 |  800 | NULL |     20 |
| 7499 | ALLEN  | SALESMAN  | 7698 | 1981-02-20 | 1600 |  300 |     30 |
| 7521 | WARD   | SALESMAN  | 7698 | 1981-02-22 | 1250 |  500 |     30 |
| 7566 | JONES  | MANAGER   | 7839 | 1981-04-02 | 2975 | NULL |     20 |
| 7654 | MARTIN | SALESMAN  | 7698 | 1981-09-28 | 1250 | 1400 |     30 |
| 7698 | BLAKE  | MANAGER   | 7839 | 1981-05-01 | 2850 | NULL |     30 |
| 7782 | CLARK  | MANAGER   | 7839 | 1981-06-09 | 2450 | NULL |     10 |
| 7788 | SCOTT  | ANALYST   | 7566 | 1987-06-13 | 3000 | NULL |     20 |
| 7839 | KING   | PRESIDENT | NULL | 1981-11-17 | 5000 | NULL |     10 |
| 7844 | TURNER | SALESMAN  | 7698 | 1981-09-08 | 1500 |    0 |     30 |
| 7876 | ADAMS  | CLERK     | 7788 | 1987-06-13 | 1100 | NULL |     20 |
| 7900 | JAMES  | CLERK     | 7698 | 1981-12-03 |  950 | NULL |     30 |
| 7902 | FORD   | ANALYST   | 7566 | 1981-12-03 | 3000 | NULL |     20 |
| 7934 | MILLER | CLERK     | 7782 | 1983-01-23 | 1300 | NULL |     10 |
+------+--------+-----------+------+------------+------+------+--------+
14 rows in set (0.05 sec)


mysql> select  * from emp ;
+------+--------+-----------+------+------------+------+------+--------+
| eno  | ename  | job       | mgr  | hirdate    | sal  | comm | deptno |
+------+--------+-----------+------+------------+------+------+--------+
| 7369 | SMITH  | CLERK     | 7902 | 1980-12-17 |  800 | NULL |     20 |
| 7499 | ALLEN  | SALESMAN  | 7698 | 1981-02-20 | 1600 |  300 |     30 |
| 7521 | WARD   | SALESMAN  | 7698 | 1981-02-22 | 1250 |  500 |     30 |
| 7566 | JONES  | MANAGER   | 7839 | 1981-04-02 | 2975 | NULL |     20 |
| 7654 | MARTIN | SALESMAN  | 7698 | 1981-09-28 | 1250 | 1400 |     30 |
| 7698 | BLAKE  | MANAGER   | 7839 | 1981-05-01 | 2850 | NULL |     30 |
| 7782 | CLARK  | MANAGER   | 7839 | 1981-06-09 | 2450 | NULL |     10 |
| 7788 | SCOTT  | ANALYST   | 7566 | 1987-06-13 | 3000 | NULL |     20 |
| 7839 | KING   | PRESIDENT | NULL | 1981-11-17 | 5000 | NULL |     10 |
| 7844 | TURNER | SALESMAN  | 7698 | 1981-09-08 | 1500 |    0 |     30 |
| 7876 | ADAMS  | CLERK     | 7788 | 1987-06-13 | 1100 | NULL |     20 |
| 7900 | JAMES  | CLERK     | 7698 | 1981-12-03 |  950 | NULL |     30 |
| 7902 | FORD   | ANALYST   | 7566 | 1981-12-03 | 3000 | NULL |     20 |
| 7934 | MILLER | CLERK     | 7782 | 1983-01-23 | 1300 | NULL |     10 |
+------+--------+-----------+------+------------+------+------+--------+
14 rows in set (0.00 sec)


mysql> select  * from dept ;
+--------+------------+----------+
| deptno | dname      | loc      |
+--------+------------+----------+
|     10 | ACCOUNTING | NEW YORK |
|     20 | RESEARCH   | DALLAS   |
|     30 | SALES      | CHICAGO  |
|     40 | OPERATIONS | BOSTON   |
+--------+------------+----------+
4 rows in set (0.00 sec)


mysql> 
王树民
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
mysql emp_mysql建立emp表
weixin_30072693的博客
01-18 1815
create table DEPT(DEPTNO int(2) not null,DNAME varchar(14),LOC varchar(13));alter table DEPTadd constraint PK_DEPT primary key (DEPTNO);create table EMP(EMPNO int(4) not null,ENAME varchar(10),JOB var...
3.3 ORACLE 的 EMP&DEPT表 建表语句
BF-Lone Silver Wind 的博客
12-18 1578
ORACLE 的 EMP&DEPT表 建表语句 -- 创建表与数据 CREATE TABLE EMP (EMPNO NUMBER(4) NOT NULL, ENAME VARCHAR2(10), JOB VARCHAR2(9), MGR NUMBER(4), HIREDATE DATE, SAL NUMBER(7, 2), COMM NUMBER(7, 2), DEPTNO NUMBER(...
数据库创建emp和dept练习表
热门推荐
啊哈程序
05-03 1万+
--新数据库 create database name1 --创建dept表 use  name1 create table dept ( deptno int primary key, dname varchar(30), loc varchar(30), ); --创建emp表 create table emp (empno int pr
oracle之 手动创建 emp 表 与 dept 表
weixin_34163553的博客
11-12 861
说明： 有时候我们需要通用的实验数据，emp表 与 dept表 但是数据库中有没有。 这时，我们可以手动创建。 -- 创建表与数据 CREATE TABLE EMP (EMPNO NUMBER(4) NOT NULL, ENAME VARCHAR2(10), JOB VARCHAR2(9), MGR NUMBER(4), HIREDATE DATE,...
最全三大框架整合（使用映射）——Dept.java
weixin_33726943的博客
05-31 100
package org.entity; import java.util.HashSet; import java.util.Set; /** * Dept entity. @author MyEclipse Persistence Tools */ public class Dept implements java.io.Serializable { // Fields ...
oracle 创建emp表和dept表
01-10
在oracle 创建 emp表和dept表, 可以直接导入 plsqldev中使用
在MySQL中创建dept，emp，salgrade三张表，以供学习使用
06-19
在MySQL中创建dept，emp，salgrade三张表，以供学习测试使用
在MySQL中创建Oracle中的dept、emp、salgrade表
11-01
创建Emp表 接下来，我们创建`emp`表。这个表用于存储员工的信息，包括员工编号(`empno`)、姓名(`ename`)、职位(`job`)、上级编号(`mgr`)、入职日期(`hiredate`)、薪资(`sal`)、奖金(`comm`)以及所属部门编号(`...
Oracle练习的三个表emp，dept，salgrade
08-08
总的来说，`emp`，`dept`，和`salgrade`这三个表构成了一个简单的Oracle数据库实例，它们涵盖了员工信息、部门信息和薪资等级等核心元素，是学习和练习Oracle数据库操作的理想起点。通过深入研究和实践，可以建立起...
Mysql版创建含emp,dept,salarygrade,bonus表的数据
01-07
Mysql版创建含emp,dept,salarygrade,bonus表的数据，适合sql语句学习练手
mysql版emp表
03-26
用mysql创建的emp表 跟oracle的emp表没有什么区别 有需要的下
SSH架构整合的Dept、Emp的CRUD
10-15
SSH整合完成了Dept、Emp两张表的CRUD,有事务+日志记录异常。
emp-2.1.2-0.noarch.rpm
01-19
emp-2.1.2-0.noarch.rpm
OCP-1Z0-051 第25题 create table 建表
Oracle
04-29 5851
一、原题 You need to create a table with the following column specifications: 1. Employee ID (numeric data type) for each employee 2. Employee Name (character data type) that stores the employee name
MySQL版emp员工信息表
guchunchao的专栏
09-21 6658
create table DEPT ( DEPTNO int(2) not null, DNAME varchar(14), LOC varchar(13) ); alter table DEPT add constraint PK_DEPT primary key (DEPTNO); create table EMP ( EMPNO int(4) not n...
007--MySQL版的Oracle员工表
weixin_42288943的博客
08-05 596
1.MYSQL版的Oracle员工表 create table EMP ( EMPNO numeric(4) PRIMARY KEY, ENAME VARCHAR(10), JOB VARCHAR(9), MGR numeric(4), HIREDATE DATE, SAL numeric(7,2), COMM numeric(7,2), DEPNO nu...
Oracle中手动创建emp表和dept表
qq_39241239的博客
10-16 3725
以下的gw为用户名，把gw改成自己的用户名即可使用 CREATE TABLE gw.DEPT ( DEPTNO NUMBER(2) CONSTRAINT PK_DEPT PRIMARY KEY, DNAME VARCHAR2(14), LOC VARCHAR2(13) ); CREATE TABLE gw.EMP ( EMPNO NUMBER(4) CONSTRAINT PK_EMP PRIMAR...
mysql数据库中新增emp_mysql整理-常用sql语句
weixin_31440211的博客
02-18 539
一、常用sqlshow variables like ‘character_set_client‘;#查询字符集show databases;#列出所有的服务器上的数据库altercreate database if not exists test;#创建一个数据库drop database fk;#删除数据库show tables from test;#显示一个数据库中的表use test;cr...
oracle 创建 dept和emp表
最新发布
06-28
创建dept和emp表的命令为： CREATE TABLE dept( deptno NUMBER(2) PRIMARY KEY, dname VARCHAR2(14), loc VARCHAR2(13) ); CREATE TABLE emp( empno NUMBER(4) PRIMARY KEY, ename VARCHAR2(10), job VARCHAR2(9),...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值