When you aren\u2019t logged into the MySQL command line, here\u2019s a handy piece of code that you can use to verify that a table has been correctly created from inside a browser. It simply issues the query DESCRIBE devices and then outputs an HTML table with four headings\u2014Column, Type, Null, and Key\u2014underneath which all columns. Within the table are shown. To use it with other tables, simply replace the name devices in the query with that of the new table.<\/p>\n\n\n\n
Describing the devices table<\/a><\/p>\n\n\n\n The output from the program should look like this: When you aren\u2019t logged into the MySQL command line, here\u2019s a handy piece of code that you can use to verify that a table has been correctly created from inside a browser. It simply issues the query DESCRIBE devices and then outputs an HTML table with four headings\u2014Column, Type, Null, and Key\u2014underneath which all columns. … Continue reading Describing a Table<\/span>
Column Type Null Key
id smallint(6) NO PRI
family varchar(32) NO
name varchar(32) NO
age tinyint(4) NO<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"