MysqlSyntax

Description: this article is talking about some basic syntax about Mysql

---

termial connect mysql

mysql -u root -p

show database

show database;

show tables

show tables;

create database

create database name;

connect database

use datbasename;

describe table

describe tablename;

create table

-- user table 
create table User(
	id int(11) not null auto_increment,
	email varchar(255) not null,
	password varchar(255) not null,
	role varchar(10) not null,
	gymId int(11) default null,
	primary key (id)
);

-- GymDiary table
create table GymDiary(
	gymId int(11) not null auto_increment,
	exerciseDate varchar(255) not null,
	exerciseName varchar(255) not null,
	exercisePosition varchar(255) not null,
	exerciseWeight DOUBLE(6,2) default null,
	exerciseGroup int(4) default null,
	primary key (gymId)
);

Cool

Thank you for giving me candy

Ali Pay

WeChat Pay