Search
 
SCRIPT & CODE EXAMPLE
 

SQL

how to use a database to see tables mysql

use database_name;
show tables;
describe table_name;
Comment

mysql show tables

mysql -e 'show tables;' database_name
Comment

PREVIOUS NEXT
Code Example
Sql :: sql timestamp to date 
Sql :: create database hive 
Sql :: grant read only privileges postgres user 
Sql :: mysql procedures 
Sql :: print all records of table in mysql 
Sql :: postgresql update between 2 tables 
Sql :: sql create a new table 
Sql :: sql count having 
Sql :: sql missing values 
Sql :: pl sql ptint 
Sql :: where date in datetime mysql 
Sql :: postgres select max value 
Sql :: alter table add column forigen key mysql 
Sql :: input in mysql 
Sql :: how to add where command in update comand with joins 
Sql :: tsql insert 
Sql :: mysql regex replace 
Sql :: mysql extract month from date 
Sql :: postgres datetime now 
Sql :: SHOW COLUMNS Statement 
Sql :: oracle sql create table from select 
Sql :: add column if not exists mysql 
Sql :: find lowest number in sql 
Sql :: How do I add a user to a postgres database? cli 
Sql :: how to extract year from date in sql 
Sql :: run postgres docker 
Sql :: download mysql 64 bit 
Sql :: mysql dump specific tables 
Sql :: mysql between 
Sql :: SQL DEFAULT Constraint With Alter Table 
ADD CONTENT
Topic
Content
Source link
Name
5+6 =