Menu

Showing posts with label Creating table in SQLite3. Show all posts
Showing posts with label Creating table in SQLite3. Show all posts

Creating table in SQLite3



How to create table in SQLite3


  • Syntax: create table if not exixts table_name (column-def [, column-def]*[,constraint]* note: constraint means give primary key autoinc  etc…
    OR
  • Syntax: create table table_name(columnField, columnDataType)
  • Query: create table if not exists dummyData(dummyId integer, dummyName text);
For More Information Please Visit



Related Posts Plugin for WordPress, Blogger...