MySQL command, without using Manual input

Question

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

try this: `ALTER TABLE table_name ADD is_published BOOLEAN DEFAULT true;` — cagri, Dec 28 '20 at 10:34
I have no idea what this question is about please try to clarify. — P.Salmon, Dec 28 '20 at 10:40
Despite that this question needs more clarification, but if you are using `phpmyadmin`, you can always `show the SQL` that being used. — Hamza Abdaoui, Dec 28 '20 at 10:57

score 1 · Answer 1 · answered Dec 29 '20 at 19:53

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.

score 0 · Accepted Answer · answered Dec 28 '20 at 10:49

0

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

CREATE TABLE published (
  `is_published` BOOLEAN NOT NULL DEFAULT true
) ENGINE=InnoDB;

answered Dec 28 '20 at 10:49

VishnuPrasad

1,078
5
17
36

MySQL command, without using Manual input

2 Answers2