How do I show columns in a MySQL table?

Answer Using DESCRIBEThe simplest way to retrieve a list of the columns in a MySQL table is to use the DESCRIBE command in the MySQL command line client. Simply type:DESCRIBE table-name;For example, to vi... Read More »

Top Q&A For: How do I show columns in a MySQL table

How to Get a List of Columns on MySQL PHP?

A MySQL database consists of tables containing rows of data separated into columns. The MySQL "SHOW COLUMNS" query is used to list the columns of a particular table. You can use the PHP "mysql_qu... Read More »

How do i create a table in mysql?

To create a table in MySQL, use the following syntax:CREATE TABLE tablename (aNumber INT UNSIGNED NOT NULL,aDate DATE NULL,someOtherData BLOB);This creates a simple table. First, it holds a number ... Read More »

How to Create a Table in Mysql?

MySQL is a relational database management system that runs as a server providing multi-user access to a number of databases. The secret of storing information on websites in such an orderly fashion... Read More »

How do I create a table in Mysql Tutorial?

Enter the command prompt. In Windows, this is done by clicking "Start" then "Run" and typing "cmd." Then type the following: mysql -h hostname -u username -p. Replace the host name with the URL of ... Read More »