INU Login Sign up
Login Or Sign up

Answers for "create table AS 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
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

Create Table

CREATE TABLE users (
    id SERIAL PRIMARY KEY,
    email VARCHAR(255) NOT NULL,
    password VARCHAR(255) NOT NULL,
    created TIMESTAMP,
    modified TIMESTAMP
);

CREATE TABLE articles (
    id SERIAL PRIMARY KEY,
    user_id INT NOT NULL,
    title VARCHAR(255) NOT NULL,
    slug VARCHAR(191) NOT NULL,
    body TEXT,
    published BOOLEAN DEFAULT FALSE,
    created TIMESTAMP,
    modified TIMESTAMP,
    UNIQUE (slug),
    FOREIGN KEY (user_id) REFERENCES users(id)
);

CREATE TABLE tags (
    id SERIAL PRIMARY KEY,
    title VARCHAR(191),
    created TIMESTAMP,
    modified TIMESTAMP,
    UNIQUE (title)
);

CREATE TABLE articles_tags (
    article_id INT NOT NULL,
    tag_id INT NOT NULL,
    PRIMARY KEY (article_id, tag_id),
    FOREIGN KEY (tag_id) REFERENCES tags(id),
    FOREIGN KEY (article_id) REFERENCES articles(id)
);

INSERT INTO users (email, password, created, modified)
VALUES
('cakephp@example.com', 'secret', NOW(), NOW());

INSERT INTO articles (user_id, title, slug, body, published, created, modified)
VALUES
(1, 'First Post', 'first-post', 'This is the first post.', TRUE, NOW(), NOW());
Posted by: Guest on May-02-2021
0

sql create table

CREATE TABLE li_wedding (
   guest_id INT,
   last_name VARCHAR(255),
   first_name VARCHAR(255),
   attending BOOL,
   diet VARCHAR(255)
);
Posted by: Guest on July-03-2021

Code answers related to "create table AS sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python
Javascript
Whatever
Shell/Bash
CSS
Html
PHP
SQL
Java
C#

Popular Programming Languages

Abap ActionScript Assembly BASIC C C# C++ Clojure Cobol CSS Dart Delphi Elixir Erlang F# Fortran Go Groovy Haskell Html Java Javascript Julia Kotlin Lisp Lua Matlab Objective-C Pascal Perl PHP Prolog Python R Ruby Rust Scala Scheme Shell/Bash SQL Swift TypeScript VBA Whatever

Advertisements

290x500

Company

Compilers

Help

Connect with us

footer logo

Copyright © 2021 Codeinu