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: 3689567 Threads: 79 Questions: 1561439410 Slow queries: 300 Opens: 4790797 Open tables: 10565 Queries per second avg: 423.203