browse tables create new table db tools manually enter SQL version
gus_demo : db tools : Enter Raw SQL

SQL script. Use the names of fields prepended with '$' to refer to the data of those fields to be processed by subqueries enclosed in {}, which can nest inside other subqueries.
PHP script to run on displayed columns. Use the names of fields prepended with '$' to refer to the data of those fields to be processed by the script.
URL of this page's state allow direct editing of results      truncate fields
Results of Query #1
Table Create Table
lifeform CREATE TABLE `lifeform` (
`lifeform_id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(11) DEFAULT NULL,
`genus` varchar(10) DEFAULT NULL,
`species` varchar(14) DEFAULT NULL,
`population` int(11) DEFAULT NULL,
`wikipedia_url` varchar(49) DEFAULT NULL,
`description` varchar(63) DEFAULT NULL,
`image_filename` varchar(29) DEFAULT NULL,
PRIMARY KEY (`lifeform_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci CHECKSUM=1

1 row affected.
Uptime: 86441 Threads: 58 Questions: 39522811 Slow queries: 5 Opens: 91968 Open tables: 8003 Queries per second avg: 457.222