Answers for "CREATE QUERY"

SQL
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
3

sql table

CREATE TABLE utilisateur
(
    id INT PRIMARY KEY NOT NULL,
    nom VARCHAR(100),
    prenom VARCHAR(100),
    email VARCHAR(255),
    date_naissance DATE,
    pays VARCHAR(255),
    ville VARCHAR(255),
    code_postal VARCHAR(5),
    nombre_achat INT
)
Posted by: Guest on May-20-2020
0

sql create table with columns as another table

SELECT * INTO newtable FROM oldtable WHERE 1 = 0;
Posted by: Guest on December-07-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language