Answers for "CREATE TABLE IN SQ;"

SQL
62

create table sql

# Simple table describing a vehicle

CREATE TABLE vehicle(
  	# vehicleId: Unique ID for Primary Key.
  	# This is how we will reference a record
	vehicleId INT NOT NULL,  
  	make VARCHAR(64), # String 64 chars max
  	model VARCHAR(128),
  	derivative VARCHAR(255),
  	PRIMARY KEY(vehicleId)
);

# Add a record
INSERT INTO vehicle VALUES(1000,'Volkswagen','Golf','1.5 TSI EVO Match Edition 5dr');
Posted by: Guest on February-21-2020
9

create table sql

CREATE TABLE table_name(
  	id INT AUTO_INCREMENT PRIMARY KEY,  
  	name VARCHAR(255), # String 255 chars max
  	date DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  	longtext BLOB
);
Posted by: Guest on July-14-2020
0

creating a 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);
Posted by: Guest on January-28-2021
0

sql create table

Creates a new table .
Example: Creates a new table called ‘users’ in the ‘websitesetup’ database.
CREATE TABLE users (
id int,
first_name varchar(255),
surname varchar(255),
address varchar(255),
contact_number int
);
Posted by: Guest on January-07-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language