建立数据库代码:CREATE DATABASE `zhc_friend` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
用户信息表
create table friend_user(id int auto_increment primary key, username varchar(50) not null,password varchar(50) not null, name varchar(50) not null, age int, gendar varchar(2), phone varchar(20) not null);
图片信息表
create table friend_pic(id int auto_increment primary key, picName varchar(100) not null, userId int not null);
insert into friend_user(id, username, password, name, age, phone) values(1, "admin", "123456", "张华厂", 20, "男", "13277426684");
- 1
- 2
前往页