MYSQL Table Create
Creating tables
SQL is not just used for table data manipulation. Rather sql can be used to perform all database and table operations, including the creation and manipulation of tables themselves.
There are two ways to create database tables
Most DBMSs come with an administration tool that can be used to create and manage database tables interactively
Tables may also be manipulated directly with SQL statements
To create tables, CREATE TABLE sql statement is used.
Basic table creation
To create the new table you must specify the following information
The name of the new table specified after keywords CREATE TABLEM’S
The name and definition of the table columns separated by commas
Some DBMSs require that you also specify the table location
The following SQL statement creates the students table
Create table students
(
student_name char(50) not null,
student_age char(10) not null,
student_marks car(10) not null
);
What is SQL?
SQL is an abbreviation for Structured Query Language. SQL is a language designed mainly for communicating with databases. SQL is easy to learn. The statements are all made up of descriptive English word. SQL is designed to do only one work that is communicating with database in a simple and efficient way.
|