如何在sqlite3中创建多个表？ [英] How do I create multiple tables in sqlite3?

问题描述

这是否允许在sqlite3中;

 sql =  创建表，如果不是EXISTS学生（ \ 
   ID INT PRIMARY KEY NOT NULL， \  //  主键 
   OBJECT_NAME TEXT NOT NULL， \  //  学生对象的名称 
   OBJECT_TYPE TEXT NOT NULL，  \  //  学生 
   OBJECT_VALUE TEXT NOT NULL）; \ 
 
   如果没有，则创建表T EXISTS GRADE（ \  //   GRADE表 
   ID INT PRIMARY KEY NOT NULL， \ 
    OBJECT_TYPE TEXT NOT NULL， \  //  年级 
   OBJECT_VALUE TEXT NOT NULL）;;  //  成绩价值 

或者我必须单独进行吗？

 sql =  创建表如果不是学生（  \ 
   ID INT PRIMARY KEY NOT NULL， \  //  主键 
   OBJECT_NAME TEXT NOT NULL， \  //  学生对象的名称 
   OBJECT_TYPE TEXT NOT NULL， \  //  学生 
  < span class =code-string> OBJECT_VALUE TEXT NOT NULL）;; 
 
 sql =   CREATE TABLE IF NOT EXISTS TABLE（ \ < span class =code-comment> //   GRADE表 
   ID INT PRIMARY KEY NOT NULL， \ 
   OBJECT_TYPE TEXT NOT NULL， \  //   grade  
   OBJECT_VALUE TEXT NOT NULL）;;  //  成绩价值 

提前谢谢。

解决方案

单独执行此操作，每次都可以检查错误，并且知道出了什么问题以及在哪里。

嗨朋友



这里我告诉你它是如何工作的sql



喜欢这种方式你也可以在sqlite3中使用

 声明  @ Str   nvarchar （Max）
  set  @Str = ' 创建表TempSample（Sno int，Data Nvarchar（50））; 
 drop TABLE TempSample; 
创建表TempSample1（Sno int，Data Nvarchar（50））; 
 drop TABLE TempSample1;' 
 
  EXEC （ @ Str < /跨度>）

Is this permissible in sqlite3;

sql = "CREATE TABLE IF NOT EXISTS STUDENTS(" \
"ID INT PRIMARY KEY NOT NULL," \    //primary key
"OBJECT_NAME TEXT NOT NULL," \      //The student object's name
"OBJECT_TYPE TEXT NOT NULL," \      //A student                             
"OBJECT_VALUE TEXT NOT NULL);"\

"CREATE TABLE IF NOT EXISTS GRADE("\//GRADE table
"ID INT PRIMARY KEY NOT NULL,"\           
"OBJECT_TYPE TEXT NOT NULL,"  \     //grade
"OBJECT_VALUE TEXT NOT NULL);";     //grade value

or do I have to do it separately?

sql = "CREATE TABLE IF NOT EXISTS STUDENT(" \
"ID INT PRIMARY KEY NOT NULL," \    //primary key
"OBJECT_NAME TEXT NOT NULL," \      //The student object's name
"OBJECT_TYPE TEXT NOT NULL," \      //A student                             
"OBJECT_VALUE TEXT NOT NULL);";

sql = "CREATE TABLE IF NOT EXISTS TABLE("\//GRADE table
"ID INT PRIMARY KEY NOT NULL,"\           
"OBJECT_TYPE TEXT NOT NULL,"  \     //grade
"OBJECT_VALUE TEXT NOT NULL);";     //grade value

Thanks in advance.

解决方案

Do it separately that way you can check for errors each time and you know what went wrong and where.

Hi Friend

here i am showing you how its works in sql

Like that way u can use in sqlite3 also

Declare @Str nvarchar(Max)
set @Str='Create table TempSample (Sno int,Data Nvarchar(50));
drop TABLE TempSample;
Create table TempSample1 (Sno int,Data Nvarchar(50));
drop TABLE TempSample1;'

EXEC(@Str)

这篇关于如何在sqlite3中创建多个表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！