$sql="update tb_reg set password='{$npass}',qrpass='{$qrnpass}' where id='{$element[id]}'";
create database db_163;
use db_163;create table db_register(
id int auto_increment primary key,
email varchar(20) not null,
password varchar(20) not null,
phnnum varchar(20) not null
);
insert into db_register (email,password,phnnum) values ('tom','111','12343566');
insert into db_register (email,password,phnnum) values ('jery','111','12343566');
insert into db_register (email,password,phnnum) values ('mary','111','12343566');
创建 唯一索引
CREATE UNIQUE INDEX catename ON db_register(email);
删除索引
ALTER TABLE db_register DROP INDEX catename;
//显示数据库
show databases;
use db_test;
drop database db_test;
//创建表
create table if not exists db_person (id int(20) primary key not null,name varchar(20) not null);
//查看表结构
show columns from db_person;
describe db_person;
//修改表结构
alter
//重命名表
rename table db_person to db_persons;
//插入
insert into db_persons (id,name) value (0,"tom");
//
create table db_person(
id int auto_increment primary key,
username varchar(50) not null,
password varchar(50) not null);
insert into db_person (username,password) values ('tom','123456');