|
create database ipu_mydb;
use ipu_mydb;
DROP TABLE IF EXISTS TABLE_IPU_MEMBER;
CREATE TABLE TABLE_IPU_MEMBER (
STAFF_ID int PRIMARY KEY,
STAFF_NAME varchar(64) default NULL,
PASSWORD varchar(10) default NULL
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO TABLE_IPU_MEMBER VALUES (66009, '黄波', '000000');
INSERT INTO TABLE_IPU_MEMBER VALUES (71335, '阳彪', '123456');
SELECT * FROM TABLE_IPU_MEMBER;
|