Новый курс! Каждый программист должен знать генеративный ИИ!
Попробуйте бесплатный урок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 ответов
+ 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