Showing posts with label db. Show all posts
Showing posts with label db. Show all posts

Wednesday, 3 February 2016

How to Convert SQLite to TextIn Feburary 2016 03,

In Feburary 2016 03,
Load a SQLite database and enter the sqlite3 environment by typing the following text at the command prompt:$ sqlite3 mydb.dbReplace 'mydb.db' with the name of your database. A database with the specified name will be created if none already exists.
Convert a value to the TEXT data type with the 'CAST' expression by typing the following command at the command prompt:$ sqlite3 my_db.db INSERT INTO my_table VALUES(CAST(97 AS TEXT))Replace 'my_table' with the name of your table. In the code, the number 97 is inserted into the table as a TEXT value.
Exit the sqlite3 environment by typing '.quit', '.q' or '.exit.' and pressing the 'Enter' key.
In Feburary 2016 03,