I would like to share a beautiful tool which can help you if you work with or learn Sqlite. This tool is a database browser (or database client). Official web-page is http://sqlitebrowser.org. In this post I only want to demonstrate you a couple of features which I used and found extremely helpful. Those are data export
Let's firstly take a look at how application looks like:
Now we will create a new database and a table. To create a database, just click "New Database" button and enter any name. Then click "Create a table", a new dialog window will be displayed. Then you can enter table name and specify columns. For example:
When the table is created, you can populate it with some data. Go to "Execute SQL" tab, write and run INSERT query, mine is below
And actual feature which might be helpful for you is to export table creation SQL. If you navigate to File > Export > Database to SQL file menu and save exported file, you will find a result as SQL generated for you. In my case:
I hope, this tool will be helpful for you. For more information refer to http://sqlitebrowser.org.
Let's firstly take a look at how application looks like:
Now we will create a new database and a table. To create a database, just click "New Database" button and enter any name. Then click "Create a table", a new dialog window will be displayed. Then you can enter table name and specify columns. For example:
When the table is created, you can populate it with some data. Go to "Execute SQL" tab, write and run INSERT query, mine is below
And actual feature which might be helpful for you is to export table creation SQL. If you navigate to File > Export > Database to SQL file menu and save exported file, you will find a result as SQL generated for you. In my case:
BEGIN TRANSACTION; CREATE TABLE `Adjective` ( `word` TEXT NOT NULL, `translation` TEXT NOT NULL ); INSERT INTO `Adjective` VALUES ('blau','blue'); COMMIT;
I hope, this tool will be helpful for you. For more information refer to http://sqlitebrowser.org.
Comments
Post a Comment