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.articles3
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
articles3
CREATE TABLE `articles3` (
`id` int(11) NOT NULL DEFAULT 0,
`title` varchar(18) DEFAULT NULL,
`body` varchar(234) DEFAULT NULL,
PRIMARY KEY (`id`),
FULLTEXT KEY `title` (`title`,`body`),
FULLTEXT KEY `body` (`body`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci
Delete
1 row affected.
Uptime: 337459 Threads: 75 Questions: 144533951 Slow queries: 38 Opens: 432710 Open tables: 7730 Queries per second avg: 428.300