0

Why the SQL tutorial doesn't teach to create database and table?

The tutorial stars with select statement without for us knowing to create one

13th Jan 2017, 5:25 PM
finalPlankton
finalPlankton - avatar
3 ответов
+ 5
What is the use of creating one when you don't know how to manage one... But still, if I recall, they don't teach about creating tables. But if I remember correctly, you can do this to create a new table : create table <tablename> (<column1> <datatype>, <column2> <datatype>,);
13th Jan 2017, 5:29 PM
Wen Qin
Wen Qin - avatar
+ 2
I answered before reading your subtext, you have to wait, I know it is hard but somehow I managed. It's in module 3, JOIN, Table operations. The CREATE TABLE statement is used to create a new table. "Creating a basic table involves naming the table and defining its columns and each column's data type." then... "CREATE TABLE table_name ( column_name1 data_type(size), column_name2 data_type(size), column_name3 data_type(size), .... columnN data_type(size) );"
13th Jan 2017, 5:32 PM
Leon
Leon - avatar
- 1
Because it is very easy
13th Jan 2017, 5:31 PM
Bohdan Kryvyi
Bohdan  Kryvyi - avatar