postgresql操作手册"help" for help. postgres=# #提示符#前的postgres表示当前数据库名 postgres=# select datname from pg_database; #列出所有数据库(标准的sql 语句) datname ----------- postgres template1 + | | | | | postgres=CTc/postgres postgres=# select version(); #查看版本号 version 13 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-18)... postgres=# select usename from pg_user; #查看系统用户 usename ---------- postgres postgres=# exit;0 码力 | 17 页 | 445.84 KB | 1 年前3
python3学习手册sqlite_cursor = sqlite_conn.cursor() # 创建一个游标,用于执 行sql语句 # 查询是否有名为'tb_test'的表 sqlite_cursor.execute( 'SELECT * FROM sqlite_master WHERE "type"="table" and "tbl_name"="tb_test";') result = sqlite_cursor.fetchall() sqlite_cursor2.execute("select * from tb_test limit 1000") result = sqlite_cursor2.fetchall() # fetchall()从结果中获 取所有记录,返回一个list,元素为(即查询到的结果) print(result) sqlite_cursor2.execute("select * from tb_test limit fetchone() # fetchone()从结果中获 取一条记录,返回一个 (即查询到的结果) print(result2) sqlite_cursor2.execute("select * from tb_test limit 1000") result3 = sqlite_cursor2.fetchmany(3) # fetchone()从结果 中获取多条记录(3条)返回 0 码力 | 213 页 | 3.53 MB | 1 年前3
A Seat at the Table: IT Leadership in the Age of Agility - Part 2benefits, risks, and resource requirements and (2) submitting the proposal to decision makers who select preferred investments from the proposals ... the first question to be answered in assessing a proposed0 码力 | 7 页 | 387.61 KB | 6 月前3
A Seat at the Table - IT Leadership in the Age of Agilitymore good information available. “Failing” in this sense is simply an efficient process we use to select among alternatives. Shadow IT Agile ways of working support a community approach to IT, where IT0 码力 | 7 页 | 387.48 KB | 6 月前3
共 4 条
- 1













