SQLite 基础11

sqlite> select * from company;
id          name        age         address     salary    
----------  ----------  ----------  ----------  ----------
1           Paul        32          California  20000.0   
2           Allen       25          Texas       15000.0   
3           Teddy       23          Norway      20000.0   
4           Mark        25          Rich-Mond   65000.0   
5           David       27          Texas       85000.0   
6           Kim         22          South-Hall  45000.0   
7           James       24          Houston     10000.0   
sqlite> 

sqlite> select name,salary,id from company;
name        salary      id        
----------  ----------  ----------
Paul        20000.0     1         
Allen       15000.0     2         
Teddy       20000.0     3         
Mark        65000.0     4         
David       85000.0     5         
Kim         45000.0     6         
James       10000.0     7         
sqlite> 

sqlite> .width 6 , 15, 10
sqlite> select name,salary,id from company;
name    salary      id             
------  ----------  ---------------
Paul    20000.0     1              
Allen   15000.0     2              
Teddy   20000.0     3              
Mark    65000.0     4              
David   85000.0     5              
Kim     45000.0     6              
James   10000.0     7              
sqlite>

sqlite> .schema sqlite_master
CREATE TABLE sqlite_master (
  type text,
  name text,
  tbl_name text,
  rootpage integer,
  sql text
);
sqlite> 

sqlite>  select * from sqlite_master;
type        name        tbl_name    rootpage    sql                                                         
----------  ----------  ----------  ----------  ------------------------------------------------------------
table       test        test        2           CREATE TABLE test ( id int primary key not null, name text )
index       sqlite_aut  test        3                                                                       
table       hello       hello       6           CREATE TABLE hello (
id int primary key not null,
age int,
n
index       sqlite_aut  hello       7                                                                       
table       ui          ui          8           CREATE TABLE ui(
id int,
name text,
age int)                
table       company     company     9           CREATE TABLE company(
id int primary key not null,
name text
index       sqlite_aut  company     10                                                                      
table       department  department  11          CREATE TABLE department(
id int primary key not null,
dept c
index       sqlite_aut  department  12                                                                      
sqlite>