MySQL CREATE database, create data table

Source: Internet
Author: User
Tags mysql create mysql create database

MySQL CREATE database, create data table written in front

MySQL database was used in the project, and MySQL was not used before, and today we learned the common syntax of MySQL, which is very similar to SQL Server syntax. It's pretty simple to use.

An example

1. Create a database named school.

1. Create a Student information table: Student ID (self-increment, primary key), name, age, gender, telephone, place of origin, enrollment time, class ID (foreign key).

2. Create a Student score table: Score ID (self-increment, primary key), account, score, student ID (foreign key), creation time.

3. Create a Student Class table: Class ID (primary key, self-increment), class name.

Creating Tables and databases
#如果存在数据库School, it is deleted. Otherwise, create the databaseDropDatabaseIfExists' School '; #创建数据库CreateDatabase' School ';Use' School '; #如果存在数据表, delete, otherwise createDropTableIfExists' Tb_class '; #创建一个学生班级表: Class ID (primary key, self-increment), class name.CreateTable' Tb_class ' (' ID ')int11)NotNull auto_incrementPrimaryKey, ' Name 'varchar32)NotNull);DropTableIfExiststb_student; #创建一个学生信息表: Student ID (self-increment, primary key), name, age, gender, enrollment time, class ID (foreign key).CreateTable' Tb_student ' (' ID ')int11)NotNull auto_incrementPrimaryKey, ' Name 'varchar32)NotNull, ' age 'IntDefault0,Check (' Age '>0and ' age '<=100), ' Gender ' BooleanDefault0,Check (' Gender '=0or ' gender '=1), ' Date 'DatetimeDefaultNow ()); #创建一个学生成绩表: Score id (self-increment, primary key), account, score, student ID (foreign key), creation time.DropTableIfExists' Tb_score ';CreateTable' Tb_score ' (' ID ')int11)NotNull auto_incrementPRIMARYKey, ' Course 'varcharnot nullforeign key (' Stuid ') references "Tb_student" (' id '));         

Querying the database created

show databases;

View table Structure

Use School;  Desc tb_student; 

Results

The field that modifies the Student information table is date createdate.

Use School;  datetime; 

Add the Student phone field after the student information sheet name.

Use School;  varchar (all) after ' name ';  

Summarize

MySQL CREATE database, create data table

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.