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
3 Réponses
+ 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>,);
+ 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)
);"
- 1
Because it is very easy