mercredi 2 septembre 2015

SQLite Studio - Export database with adding quote to string number

I cannot export my database to a sql file with adding quote to string number. I store code postal number as CHAR[5] but it exports without 'quote'.

eg: What I want:

CREATE TABLE codepostal ( code CHAR( 5 ) PRIMARY KEY NOT NULL UNIQUE, name VARCHAR( 70 ) NOT NULL );
INSERT INTO [codepostal] ([code], [name]) VALUES ('12345', 'My_city');

But not:

CREATE TABLE codepostal ( code CHAR( 5 ) PRIMARY KEY NOT NULL UNIQUE, name VARCHAR( 70 ) NOT NULL );
INSERT INTO [codepostal] ([code], [name]) VALUES (12345, 'My_city');

Any suggestion can help, thanks. ^_^

Aucun commentaire:

Enregistrer un commentaire