Shulou(Shulou.com)06/01 Report--

How do SQL databases create tables? I believe that many novice white sql database how to create tables helpless, through the summary of this article, I hope you can harvest more. The following information is about sql database creation tables.

SQL stands for Structured Query Language. SQL is a set of operational commands built specifically for databases and is a fully functional database language. When using it, you just need to issue the command "what to do,""how to do" is not considered by the user. SQL powerful, easy to learn, easy to use, has become the basis of database operations, and now almost all databases support SQL.

How do SQL databases create tables?

SQL database syntax for creating a table:

CREATE TABLE table name (column name 1 data type, column name 2 data type,...)

examples

This example demonstrates how to create a table named Person with four columns. Column names are: "LastName,""FirstName,""Address," and "Age":

CREATE TABLE Person (LastName varchar,FirstName varchar,Address varchar,Age int)

The above is the sql database to create the table details, after reading whether there is any harvest? If you want to know more about it, welcome to pay attention to industry information!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.