Answers for "how to add a table to a database in sql"

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
0

insert table command

// FOR INSERTING IN AN UNORDERED OR A SPECIFIC MANNER:
INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);

// FOR INSERTING IN ORDERED MANNER AS PER THE CREATE TABLE:
INSERT INTO table_name
VALUES (value1, value2, value3, ...);
Posted by: Guest on July-13-2021

Code answers related to "how to add a table to a database in sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language