遨翔在知识的海洋里(mysql)

库操作

show databases;
create database test314;

表操作

create table users(
    id INT NOT NULL AUTO_INCREMENT,
    username VARCHAR(100) NOT NULL,
    password VARCHAR(100) NOT NULL,
    PRIMARY KEY (id)
);

字段操作

select * from users;

insert into users set username = 1,password="a";

update users set username=2 where id =1;

delect from users where id =1;