Create table

How to create table in sql

//to create a table
CREATE TABLE students
( student_id number(4) primary key,
  last_name varchar2(30) NOT NULL,
  course_id number(4) NULL );

//to insert value
INSERT INTO students VALUES (200, 'Jones', 101);
INSERT INTO students VALUES (201, 'Smith', 101);
INSERT INTO students VALUE (202, 'Lee' , 102);

Create table

CREATE TABLE fact (
id SERIAL PRIMARY KEY NOT NULL,
type VARCHAR(255),
text TEXT
);

Similar codes

7 votes162 views4 answers
Mysql delete older duplicates
SQL
0 vote128 views2 answers
Cambiar nombre tabla mysql
SQL
6 votes159 views2 answers
Clear a table in mysql
SQL
0 vote138 views1 answer
Where name ends in SQL
SQL
0 vote146 views1 answer
Mysql dump for selected row
SQL
2 votes133 views1 answer
Get hour from date sql
SQL
1 vote140 views1 answer
Error code 1292 mysql workbench
SQL
0 vote132 views1 answer
MySql Modify Increment
SQL
-1 vote156 views5 answers
Operator in sql
SQL
1 vote159 views1 answer
Oracle apex version view
SQL