0

How to create table

idk say pls

26th Nov 2016, 3:02 PM
mustafa arkin
mustafa arkin - avatar
5 odpowiedzi
+ 8
Using CREATE TABLE For example CREATE TABLE IF NOT EXISTS person (person_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL UNIQUE , person_name TEXT, person_family TEXT, person_age INTEGER)
26th Nov 2016, 3:50 PM
Hadi Akbarzadeh
Hadi Akbarzadeh - avatar
+ 1
CREATE TABLE TABLE_NAME( COLUMN1 DATATYPE, COLUMN2 DATATYPE);
5th Dec 2016, 8:07 PM
Pruthvi Bhatt
Pruthvi Bhatt - avatar
+ 1
CREATE TABLE table_name; or CREATE TABLE table_name(column1 data type, column2, data type...);
18th Dec 2016, 1:37 AM
Moussi Lyès
Moussi Lyès - avatar
0
create database first then use database then create table
26th Nov 2016, 3:24 PM
Udo Ortmann
Udo Ortmann - avatar
0
create table tablename (column1 data type, column2, data type.....) ; tablename :any name of ur table like clientmaster cloumn1 :name of your column like Fname, Lname, Rollno. depends on the datatype if its a 'char' or a 'number'. Terminated by a semicolon.
7th Dec 2016, 6:51 PM
Afroj Ahmed
Afroj Ahmed - avatar