How to create table in MariaDB?

Question

When I try to create simple table via HeidiSQL I'm getting an error like this

CREATE TABLE `prg_config` (
    `id` INT NULL AUTO_INCREMENT,
    `name` VARCHAR(50) NULL DEFAULT '',
    `value` VARCHAR NULL DEFAULT ''
) COLLATE='utf8_bin';

Solution

Please Check Following query :

CREATE TABLE prg_config (
     `id` INT NOT NULL AUTO_INCREMENT,
     `name` VARCHAR(50) NULL DEFAULT '',
     `value` VARCHAR(50) NULL DEFAULT '',
     PRIMARY KEY (id)
)COLLATE='utf8_bin';

Comments

[Anse]

I fixed that in r5032 of HeidiSQL, so that you get an error message saying Column data type %s requires a length/set when you try to leave an empty length/set value for a VARCHAR column.