Laraadmin和sqlite"SHOW":语法错误(SQL:SHOW TABLES) [英] Laraadmin and sqlite "SHOW": syntax error (SQL: SHOW TABLES)
问题描述
我已经安装了laraadmin,以便使用sqlite进行快速管理.但是问题是当我要创建获取SQLSTATE [HY000]的东西时:常规错误:"SHOW"附近为1:语法错误(SQL:SHOW TABLES)谢谢
I have installed laraadmin as for quick admin with using sqlite. But problem is when i am going to create something getting SQLSTATE[HY000]: General error: 1 near "SHOW": syntax error (SQL: SHOW TABLES) Thanks
推荐答案
不幸的是,SQLite不知道 SHOW TABLES
,但是它具有:
Unfortunately SQLite doesn't know SHOW TABLES
, but instead it has:
特殊命令行命令,例如 .schema
或 .tables
(带有可选的 Like
模式)
special command line commands, like .schema
or .tables
(with optional LIKE
patterns)
主元数据表,称为 sqlite_master
因此,假设您有以下表格:
So let's say you have the following tables:
sqlite> CREATE TABLE A(a INT, b, INT, c TEXT);
sqlite> CREATE TABLE B(a INT);
sqlite> CREATE TABLE AB(a TEXT, b TEXT);
您可以查询架构:
sqlite> .schema
CREATE TABLE A(a INT, b, INT, c TEXT);
CREATE TABLE B(a INT);
CREATE TABLE AB(a TEXT, b TEXT);
查询表名称:
sqlite> .tables
A AB B
查询所有元数据:
sqlite> SELECT * FROM sqlite_master WHERE type = 'table';
table|A|A|2|CREATE TABLE A(a INT, b, INT, c TEXT)
table|B|B|3|CREATE TABLE B(a INT)
table|AB|AB|4|CREATE TABLE AB(a TEXT, b TEXT)
查询与特定 LIKE
模式匹配的表名的模式:
Query the schema of table names matching a specific LIKE
pattern:
sqlite> .schema A%
CREATE TABLE A(a INT, b, INT, c TEXT);
CREATE TABLE AB(a TEXT, b TEXT);
查询与特定 LIKE
模式匹配的表名:
Query the table names matching a specific LIKE
pattern:
sqlite> .tables A%
A AB
这篇关于Laraadmin和sqlite"SHOW":语法错误(SQL:SHOW TABLES)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!