数据库
Tim·Z
Java程序员
展开
-
Linux下MySql安装记录
1,centos自带mariadb,需要提前卸载# 检查是否安装了mariadbroot[/root]#rpm -qa |grep -i mariadbmariadb-5.5.52-1.el7.x86_64mariadb-server-5.5.52-1.el7.x86_64# 卸载root[/root]#rpm -e --nodeps mariadb-5.5.52-1.el7.x86_64root[/root]#rpm -e --nodeps mariadb-server-5.5.52-1.e原创 2021-01-17 21:10:26 · 195 阅读 · 2 评论 -
mysql sql faq
字段和数据库关键字冲突 用反撇号(`)包住,比如databaseSELECT id, org_id, version, type, name, access, url, password, user, `database`,basic_auth, basic_auth_user, basic_auth_password, is_default, created, updated, with_credentials, read_only, uid ,json_data, secure_.原创 2020-09-23 23:10:13 · 82 阅读 · 0 评论 -
Oracle Sql Faq
查询表中有哪些字段select *from user_tab_columnswhere table_Name='表名'order by column_nameall_tab_columns ,dba_tab_columns查询表的注释select table_name,table_type,comments from user_tab_commentswhere table_Name='表名'dba_tab_comments,all_tab_comments查询字段注释.原创 2020-09-23 23:09:13 · 170 阅读 · 0 评论 -
sqlite faq
SQL创建表CREATE TABLE IF NOT EXISTS t_user(uid integer primary key,uname varchar(20),mobile varchar(20))CREATE TABLE `data_source` (`id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `org_id` INTEGER NOT NULL, `version` INTEGER NOT NULL, `type` TEXT NO.原创 2020-09-23 08:55:09 · 166 阅读 · 0 评论