Home
Sample work
Sample code
Database visualizer
Definitions
Resume
Contact
create new table
db tools
manually enter SQL
gus_demo
:
db tools
:
Enter Raw SQL
show create table gus_demo.tf_relation
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
tf_relation
CREATE TABLE `tf_relation` (
`relation_id` int(11) NOT NULL AUTO_INCREMENT,
`table_name` varchar(23) DEFAULT NULL,
`display_column_name` char(1) DEFAULT NULL,
`column_name` varchar(27) DEFAULT NULL,
`f_table_name` varchar(27) DEFAULT NULL,
`f_column_name` varchar(27) DEFAULT NULL,
`relation_type_id` int(11) DEFAULT NULL,
PRIMARY KEY (`relation_id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci CHECKSUM=1
Delete
1 row affected.
Uptime: 1367525 Threads: 85 Questions: 575235787 Slow queries: 107 Opens: 1744289 Open tables: 15000 Queries per second avg: 420.640