Search
 
SCRIPT & CODE EXAMPLE
 

SQL

show table columns mysql command line

SHOW COLUMNS from tablename;
Comment

mysql show table column full description

/**table's full description*/
SHOW FULL COLUMNS FROM tablename;
Comment

mysql show table structure

DESCRIBE table_name; # To show table structure...
Comment

mysql show table fields

DESCRIBE my_table;
Comment

PREVIOUS NEXT
Code Example
Sql :: wordpress sql change site url 
Sql :: change default maximum runtime mariadb from phpmyadmin 
Sql :: postgresql define pk sequence next number 
Sql :: insert all or first in oracle sql 
Sql :: mysql on terminal mac 
Sql :: mysql get domain from url 
Sql :: wordpress change user password sql 
Sql :: load mysql dumb 
Sql :: mysql events not work 
Sql :: how to create a variable in mysql 
Sql :: sql set no lmit 
Sql :: display users in mysql 
Sql :: create policy in sql 
Sql :: mysql current user 
Sql :: sqlfiddle example tables 
Sql :: mysql show all tables 
Sql :: oracle user quota unlimited 
Sql :: sql update from select 
Sql :: check mysql port 
Sql :: mysql select utc time in eastern time 
Sql :: Columns Present in a table 
Sql :: get first 3 letter of department name in sql 
Sql :: alter table add column 
Sql :: compare date in sql 
Sql :: mysql concatenate columns 
Sql :: script to add datafile to tablespace 
Sql :: mysql select last 10 rows 
Sql :: mysql create timestamp column 
Sql :: search db for table name 
Sql :: delete role postgres 
ADD CONTENT
Topic
Content
Source link
Name
7+8 =