create table

lucycodes42

This code creates a table named "&[USER_INPUT:1]:table_name" in the database "&[DB_NAME]". The table has an ID column with an auto-increment, a name column with a VARCHAR(55) column, and a primary key column that references the ID column.

Shortcut: table.create

DROP TABLE IF EXISTS `table_name`;
CREATE TABLE `table_name` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255),
  PRIMARY KEY `pk_id`(`id`)
);