mysql怎么查询表名
使用select命令,可以查询所有表名
写法如下:
select table_name from information_schema.tables where table_schema='当前数据库'
扩展资料
其它用法
1、使用SHOW语句找出在服务器上当前存在什么数据库:
mysql> SHOW DATABASES;
2、创建一个数据库MYSQLDATA
mysql> CREATE DATABASE MYSQLDATA;
3、选择你所创建的数据库
mysql> USE MYSQLDATA; (按回车键出现Database changed 时说明操作成功!)
4、查看现在的数据库中存在什么表
mysql> SHOW TABLES;
5、创建一个数据库表
mysql> CREATE TABLE MYTABLE (name VARCHAR(20), sex CHAR(1));
6、显示表的结构:
mysql> DESCRIBE MYTABLE;
7、往表中加入记录
mysql> insert into MYTABLE values (”hyq”,”M”);
8、用文本方式将数据装入数据库表中(例如D:/mysql.txt)
mysql> LOAD DATA LOCAL INFILE “D:/mysql.txt” INTO TABLE MYTABLE;
9、导入.sql文件命令(例如D:/mysql.sql)
mysql>use database;
mysql>source d:/mysql.sql;
参考资料:百度百科:MySQL数据库
绛旓細浣跨敤select鍛戒护锛屽彲浠ユ煡璇㈡墍鏈夎〃鍚 鍐欐硶濡備笅锛歴elect table_name from information_schema.tables where table_schema='褰撳墠鏁版嵁搴'
绛旓細鏌ヨ鏁版嵁搴撲腑鎵鏈夎〃鍚嶆湁涓ょ鏂规硶锛1銆乻elect table_name from information_schema.tables where table_schema='褰撳墠鏁版嵁搴';2銆乻how tables锛涘叾涓紝information_schema杩欏紶鏁版嵁琛ㄤ繚瀛樹簡MySQL鏈嶅姟鍣ㄦ墍鏈夋暟鎹簱鐨勪俊鎭傚鏁版嵁搴撳悕锛屾暟鎹簱鐨勮〃锛岃〃鏍忕殑鏁版嵁绫诲瀷涓庤闂潈闄愮瓑銆傚啀绠鍗曠偣锛岃繖鍙癕ySQL鏈嶅姟鍣ㄤ笂锛屽埌...
绛旓細1銆佺敤select database()璇彞;2銆佺敤status璇彞锛屾煡璇㈠嚭鏉ョ殑缁撴灉涓湁涓琛屾槸currrent database:***銆傝繖閲***灏 鏄綋鍓嶆墍鍦ㄧ殑鏁版嵁搴撳悕绉般1銆佹墦寮mysql鎺у埗鍙帮紝骞惰緭鍏ュ瘑鐮侊紱2銆佽杩涘叆鏁版嵁搴 棣栧厛寰楄緭鍏 show databases;3銆佽浣跨敤鍝釜鏁版嵁搴擄紝蹇呴』鍏堣緭鍏 use + 琛ㄥ悕 濡 use nowasp;4銆佽鐭ラ亾杩欎釜鏁...
绛旓細涓銆佷娇鐢ㄥ懡浠わ細mysqlshow [db_name [tbl_name [col_name]]]浜屻佷娇鐢⊿QL锛歴how tables
绛旓細鏌ョ湅鏈夊摢浜涙暟鎹簱 show databases;閫夋嫨鏁版嵁搴 use database_name;鏌ョ湅璇ユ暟鎹簱涓嬬殑琛 show tables;
绛旓細TABLE 璇彞 鍏蜂綋璇硶锛歍ABLE table_name [ORDER BY column_name] [LIMIT number [OFFSET number]]鍏跺疄浠庤娉曚笂鐪嬶紝鍙互鎺掑簭锛屼篃鍙互杩囨护璁板綍闆嗭紝涓嶈繃姣旇緝绠鍗曪紝娌℃湁 SELECT 閭d箞寮哄ぇ銆傜ず渚 1 绠鍗曠殑寤轰竴寮犲緢灏忕殑琛 y1锛岃褰曟暟涓 10 鏉°傝〃 t1锛屾彃鍏 10 鏉¤褰 mysql-(ytt/3305)->create table ...
绛旓細鏌ヨ鎸囧畾鏁版嵁搴撲腑鎸囧畾琛ㄧ殑鎵鏈夊瓧娈靛悕column_name select column_name from information_schema.columns where table_schema='csdb' and table_name='users'娓呴櫎mysql琛涓暟鎹 delete from 琛ㄥ悕;truncate table 琛ㄥ悕;涓嶅甫where鍙傛暟鐨刣elete璇彞鍙互鍒犻櫎mysql琛ㄤ腑鎵鏈夊唴瀹癸紝浣跨敤truncate table涔熷彲浠ユ竻绌簃ysql琛...
绛旓細TABLE 璇彞 鍏蜂綋璇硶锛歍ABLE table_name [ORDER BY column_name] [LIMIT number [OFFSET number]]鍏跺疄浠庤娉曚笂鐪嬶紝鍙互鎺掑簭锛屼篃鍙互杩囨护璁板綍闆嗭紝涓嶈繃姣旇緝绠鍗曪紝娌℃湁 SELECT 閭d箞寮哄ぇ銆傜ず渚 1 绠鍗曠殑寤轰竴寮犲緢灏忕殑琛 y1锛岃褰曟暟涓 10 鏉°傝〃 t1锛屾彃鍏 10 鏉¤褰 mysql-(ytt/3305)->create table ...
绛旓細鏂规硶鍜岃缁嗙殑鎿嶄綔姝ラ濡備笅锛1銆佺涓姝ワ紝 MySQL鏁版嵁搴撲娇鐢ㄧ壒瀹氬瓧娈鏌ヨ鎵鏈琛ㄥ悕锛屼唬鐮佽涓嬪浘锛岃浆鍒颁笅闈㈢殑姝ラ銆2銆佺浜屾锛屾墽琛屽畬涓婇潰鐨勬搷浣滀箣鍚庯紝Oracle鏁版嵁搴撲娇鐢ㄧ壒瀹氬瓧娈垫煡璇㈡墍鏈夎〃鍚嶏紝浠g爜瑙佷笅鍥撅紝杞埌涓嬮潰鐨勬楠ゃ3銆佺涓夋锛屾墽琛屽畬涓婇潰鐨勬搷浣滀箣鍚庯紝SQLServer鏁版嵁搴撲娇鐢ㄧ壒瀹氬瓧娈垫煡璇㈡墍鏈夎〃鍚嶏紝浠g爜瑙...
绛旓細SELECT COUNT(*) TABLES,table_schema FROM information_schema.TABLES WHERE table_schema = 鈥榯ableName鈥 GROUP BY table_schema;娉細tableName 杩欎釜鏄綘鐨勬暟鎹簱琛ㄥ悕銆