FilesExpand file tree

 master

/

createTable.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

executable file

·

11 lines (10 loc) · 414 Bytes

 master

/

createTable.sql

Copy path

Top

File metadata and controls

• Code
• Blame

executable file

·

11 lines (10 loc) · 414 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

DROP TABLE T_JDBC_BASIC_STUDENT;

CREATE table T_JDBC_BASIC_STUDENT(

`stuid` bigint(20) unsigned NOT NULL,

`stuname` varchar(20) default NULL,

PRIMARY KEY (`stuid`),

UNIQUE KEY (`stuname`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO T_JDBC_BASIC_STUDENT VALUES ('1', 'Sondy');

INSERT INTO T_JDBC_BASIC_STUDENT VALUES ('2', 'Lanny');

INSERT INTO T_JDBC_BASIC_STUDENT VALUES ('3', 'Michael Woo');