[sqlite] export tables

Hello, I need to export some tables with dot command, How I do it? --regards Mohsen ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] difference between *.db *.db3 *.sqlie2 *.slite3

What differ between *.db *.db3 *.sqlie2 *.slite3 files? ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] mysql to sqlite

Hello, I have some tables in mysql with the following data types: smallint text varchar date I don't know sqlite, What are corresponding above data types in sqlite? --Regards Mohsen ___ sqlite-users mailing list

[sqlite] migration from mysql to sqlite

Dear all, I'm newbie in sqlite, and i migrated to sqlite from mysql. I have the folloiwng questions: 1. how can define a unicode field and tables? 2. how to define date type? I created my table such as: CREATE TABLE `buyers` ( `id` bigint(20) NOT NULL , `name` varchar(200) DEFAULT