How to create table in MariaDB?

mysql sql mariadb heidisql
user1564141 picture user1564141 · Dec 16, 2015 · Viewed 14k times · Source

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

enter image description here

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

Answer

Jyoti Sharma picture Jyoti Sharma · Dec 16, 2015

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';

Related questions

ERROR 1452: Cannot add or update a child row: a foreign key constraint fails

I have created tables in MySQL Workbench as shown below : ORDRE table: CREATE TABLE Ordre ( OrdreID INT NOT NULL, OrdreDato DATE DEFAULT NULL, KundeID INT DEFAULT NULL, CONSTRAINT Ordre_pk PRIMARY KEY (OrdreID), CONSTRAINT Ordre_fk FOREIGN KEY (KundeID) REFERENCES …

Read More
Cast int to varchar

I have below query and need to cast id to varchar Schema create table t9 (id int, name varchar (55)); insert into t9( id, name)values(2, 'bob'); What I tried select CAST(id as VARCHAR(50)) as col1 from t9; select CONVERT(…

Read More
MySQL - SELECT * INTO OUTFILE LOCAL ?

MySQL is awesome! I am currently involved in a major server migration and previously, our small database used to be hosted on the same server as the client. So we used to do this : SELECT * INTO OUTFILE .... LOAD DATA INFILE .... …

Read More