How to convert the MySql Database to SqLite DB
HTML-код
- Опубликовано: 21 апр 2017
- How to convert the MySql Database to SqLite DB
Hi Friends today i will show you the quickest and
easiest method to convert the mysql db into sqlite db
SqLite Browser : sqlitebrowser.org/
You can download from above link
Thanks for watching
If you have any doubts comment on the below, If you like share and subscribe.
For more Techincal videos Please Subscribe Our Channel
Keep Watching :-) !
Thank you so much for making this vid. It took me almost 2 hrs trying to use different online converters but in vain. Your vid saved me. Btw, you need a semicolon at the end of your "Create Table" to execute everything at once.
thank you for your video. but please keep the music down or no music is even better.
Thanq u sir
Thanks for creating such a useful video. Kudos! I want to convert .sql format to .db format but by following the above method, I am able to save SQL file as .sqdbpro format. Please suggest how to convert the .sql file to .db format.
Yeah, the new sqlite database is created from the MySQL dump but you erased the indexes so performance suffers in a big way. Also, watching you type is like getting teeth pulled at the dentist. Or maybe it was the music - I don't know. Ideally you would want to name each tables' primary index at the end of the create table statement ..PRIMARY KEY(`whatever`) like:
CREATE TABLE IF NOT EXISTS `sometable` (
...
`id` integer NOT NULL,
PRIMARY KEY(`id`)
);
thanks sr
04:43 start
great
After installation of db browser sqlite from the above link, its giving a error "error when connecting to raw.githubusercontent.com/sqlitebrowser/sqlitebrowser/master/currentrelease.
host.raw.githubusercontent.com not found . Please suggest how to rectify it.
what is the error when using insert
I guess this is a solution if you don't have any amount of data or tables.
Thank u' so much!
whats the music?
Holy crap! Ninety seconds in and you typed THREE SENTENCES!!!! Had to stop watching no matter how much I want to convert my DB. Try editing your video to speed up the typing portion. We are all smart people and could have read those three sentences in 10-15 seconds.
There's an option to speed up the playback speed. Do try that
@@AzeemIqbal-zv8qy I know right?!!
How to move this SQLite database to android?
Milan chhatralia, just place in the assets directory. And initiate the connection with the file location
it is wasting time .
is there any other method by on click or run script to export or import both of DBs.
Don't follow this if you don't have backup or with large database! There is data destructive hand-by method.
Better to use scripts or services.
can you please tell me any such scripts or services?
why waist your time if your not gonna talk this music and you typing combine is annoying af
dire
Please remove this annoying background music and speed up your typing by fast forwarding the typing part