Answers for "mysql show table values"

SQL
1

mysql show data from table

mysql> SELECT * FROM [table name];
Posted by: Guest on September-29-2020
1

print all records of table in mysql

SELECT * FROM TABLE_NAME;
OR
SELECT column_name_1, column_name_2 FROM TABLE_NAME;
Posted by: Guest on May-12-2020
4

mysql show table structure

DESCRIBE table_name; # To show table structure...
Posted by: Guest on May-04-2020
2

mysql show table fields

DESCRIBE my_table;
Posted by: Guest on October-25-2020
0

mysql show table info

-- Select all:

SELECT * FROM Customers;
Posted by: Guest on July-30-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language