Home
Sample work
Sample code
Database visualizer
Definitions
Resume
Contact
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.
{eliminate squiggly brackets from Drupal SQL}
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		Delete

1 row affected.
Uptime: 3816853 Threads: 79 Questions: 1612498037 Slow queries: 316 Opens: 4967800 Open tables: 14998 Queries per second avg: 422.467