Zhi Chi :Linux | MacOS | Windows(Mian Qiang Ke Yong )

• Yi Ge Jian Dan De sqlMing Ling Xing Gong Ju ,Zhi Chi Zeng , Shan , Gai , Cha ,Pi Liang Zhi Xing ,Shi Wu ,Dao Chu Jie Guo ;
• Zhi Chi mysql, oracle, postgreSQL, sqlServer,sqliteDeng Shu Ju Ku ,Ke Zi Xing Tian Jia jdbcQu Dong Wen Jian Dao driversMu Lu Xia ;
• Zhi Chi Dao Chu Wen Jian Lei Xing :xlsx,json,tsv,csv, sql;
• Zhi Chi Shu Ju Ku Guan Jian Zi Ti Shi ,Gen Ju Zhi Ding Shu Ju Ku Jia Zai completionWen Jian Xia De Pei Zhi Wen Jian **(Yi Lai CKu :readline,rlwrap)**;
• Zhi Chi Lu Jing Zi Dong Wan Cheng Ti Shi **(Yi Lai CKu :readline,rlwrap)**;
• Zhi Chi Ming Ling Xing Li Shi Ji Lu **(Yi Lai CKu :readline,rlwrap)**;
• Zhi Chi Ming Ling Mo Shi He Jiao Hu Mo Shi ;

2.xBan Bu Zai Yi Lai readlineHe rlwrap

Jin Zhi Chi Zhi Xing Dan Tiao Yu Bian Yi sql

Yu Bian Yi sqlShi Yong De Can Shu Zhan Wei Fu Wei Chuan Ming Can Shu ,Chu Ji Ben Shu Ju Lei Xing He Wen Jian Wai ,Qi Yu Xu Yao Shi Yong Lei Xing Zhuan Huan

• Zhi Chi De Ji Ben Shu Ju Lei Xing :string("some string"), boolean(true, false), double, int, null

• Zhi Chi De Shu Ju Lei Xing :int[], float[], double[], string[], long[],Xu Yao Shi Yong Lei Xing Sheng Ming ,Ru Xia :

  [1,2,3,4]::int[] #Mo Ren Shi Yong ,Hao
  [a,b,c]::string[]
  [a;b;c]::string[;] #Shi Yong ;Hao Fen Ge Shu Zu

• Zhi Chi Wen Jian :/usr/local/a.txt

• Zhi Chi Ri Qi Ge Shi :yyyy-MM-dd, yyyy/MM/dd, yyyy-MM-dd HH:mm:ss, HH:mm:ss,Xu Yao Shi Yong Lei Xing Sheng Ming Ru Xia :

  2021-12-23::date


Mo Ren De Duo Xing sqlKuai Yi Dan Fen Hao (;)Fen Ge ,Can Shu -dHe :dKe Zi Ding Yi

Ru Guo Wen Jian Lu Jing Yi @Kai Tou ,Ze Wen Jian Shi Yong An Xing Liu Shi Du Qu ,Nei Bu Ze Diao Yong jdbcDe executeBatch Fang Fa Jin Xing Pi Liang Zhi Xing ddlHe dmlYu Ju ,Yi Ban Yong Yu Dao Ru Shu Ju Deng Da Xing Wen Ben Wen Jian Zhi Xing Da Liang sql;

• -e@/usr/local/a.sql
• :load @/usr/local/a.sql

Yi Ban Qing Kuang Ze Zhi Xing Yu Bian Yi Cao Zuo Pi Liang Zhi Xing (Jian Yi Xiao Shu Ju Liang )

• -e"select * from mytable;;select now();;create or replace function..." -d";;"
• -e/usr/local/a.sql
• :load /usr/local/a.sql

Shi Yong Zhong Ding Xiang Fu > Dao Chu Cha Xun Jie Guo ,Ru Guo Yi .sqlJie Wei ,Ze Dao Chu insertYu Ju ,Biao Ming Wei Wen Jian Ming ,Fou Ze Gen Ju -fHuo :[tsv|csv|json|excel]Dao Chu Xiang Ying Lei Xing Wen Jian .

• Dao Chu Huan Cun ::get res0 > /usr/local/res.sql
• :load /usr/local/query.sql > /usr/local/res.sql
• -e"select * from table > /usr/local/res" -fjson
• -e"/usr/local/query.sql > /usr/local/res.sql"

• ./sqlc.sh -ujdbc:postgresql://127.0.0.1:5432/postgres -nchengyuxing -p
• ./sqlc.sh -ujdbc:postgresql://127.0.0.1:5432/postgres -nchengyuxing -p -e"select * from test.region where id < 10" -fjson
• ./sqlc.sh -ujdbc:postgresql://127.0.0.1:5432/postgres -nchengyuxing -p -e/Users/chengyuxing/Downloads/a.sql

• Ming Ling Mo Shi sqlc.sh -h Huo sqlc.sh --help
• Jiao Hu Mo Shi :help

Jiao Hu Mo Shi Ji Ben Cha Xun ,Qie Huan Shu Ju Zhan Shi Shi Tu Ming Ling Mo Shi Zhi Xing Shu Chu Yi Tiao sqlCha Xun Ming Ling Mo Shi Pi Liang Zhi Xing sqlWen Jian Zhong De Yi Xie sql Yu Bian sqlZhi Xing Xiao Guo Tu