· 8 years ago · Jan 18, 2018, 10:38 AM
1drop database IF EXISTS login;
2
3create database login1;
4
5use login1;
6
7DROP TABLE if exists users CASCADE;
8
9CREATE TABLE `login1`.`users` (
10 `username` VARCHAR(15) NOT NULL,
11 `password` VARCHAR(15) NOT NULL
12)
13ENGINE = InnoDB;
14
15insert into login1.users (username,password) values ('admin','admin');