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  
building CREATE TABLE `building` (
`building_id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(13) DEFAULT NULL,
`latitude` float(9,4) DEFAULT NULL,
`longitude` float(10,4) DEFAULT NULL,
`longest_axis_length` float(9,4) DEFAULT NULL,
`shortest_axis_length` float(9,4) DEFAULT NULL,
`image_filename` varchar(19) DEFAULT NULL,
`description` varchar(54) DEFAULT NULL,
PRIMARY KEY (`building_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci CHECKSUM=1
Delete

1 row affected.
Uptime: 160403 Threads: 62 Questions: 84125553 Slow queries: 8443 Opens: 191910 Open tables: 1492 Queries per second avg: 524.463