skip to Main Content

How to create a table which is included this by MySQL command without using Manual input, see the pic blow:

enter image description here

2

Answers


  1. You can use this SQL to create a table name as: published

    CREATE TABLE published (
      `is_published` BOOLEAN NOT NULL DEFAULT true
    ) ENGINE=InnoDB;
    
    
    Login or Signup to reply.
  2. Based on the accepted answer, it seems you want the SQL commands that are run by the graphical interface. In the future, you can use phpMyAdmin to show you those queries directly.

    When you’re on that page to create a new table (or edit an existing table), there’s a "Preview SQL" button next to "Save". Clicking that shows the SQL commands that will run, but won’t actually run them.

    Create table dialog

    Preview SQL results

    Login or Signup to reply.
Please signup or login to give your own answer.
Back To Top
Search