162 Android SQLite Insert Tutorial Part 1 |

"Learn How To Design + Code A Complete App From Scratch To Playstore"
-~-~~-~~~-~~-~-

This Android SQLite Database Tutorial video talks about how to use the SQLiteDatabase object returned by getWriteableDatabase() to perform insert statements either using the execSQL() method of the database object or the ContentValues object that lets you add key-value pairs of data. It also explains the meaning of a null column hack in SQLite

RELATED VIDEOS
Create an SQLite Schema Part 1

SQLite Schema Part 2

Android Database Tutorials

OUR WEBSITE

OUR SOCIAL LINKS
Follow us on

[SrMartins]

Congratulations for SlideNerd

you make the best tutorials I have ever seen in my life... Now you have one more subscribed

[hitchunited]

slidenerd, Thank you for making these videos. I can't even begin to tell you how many tutorials I have watched on this stuff and none of them seemed clear enough. I cannot believe this video only has 2, 278 watches so far... (at the time I wrote this comment of course). Keep up the good work!

[PadillaJosh]

Definitely the best Android tutorials i've seen.

[mertserimer]

You are so good when it comes to tutorials so i started to believe  you are not real... I listened fragments and sqlite tutorials from you and they were really helpful!!. I will start listening ios tutorials when i buy a mac. I will support you when i can(i hope you are not an illusion) 

[dyjia]

Best tutorial ever!
hope you can have some tutorial integrating with web!

[faisalansari]

At the end of the video you have said that used type #2 technique . what are they #1 and #2 technique?

[chavacooper]

vivz you are indeed the open helper. thanks

[zubairyasin]

I was much confused about database programming in android i have seen lot of videos in the youtube for understanding the sqlite programming. I fed up with sqlite but after watching your lectures about database i really fell happy. Thanks alot.

please remove my another confusion about sqlite that how can i store my database in mobile's memory card?
and please suggest me some android programmer group which can help me about problems of android programming.

I will really thank full to you.

[oussamaelbaz]

Best tutorial of Android SQLit thank you bro!!

[kinanalamdar]

Hey Vivek Thankx for quality content, i actually have a question what Database i should use for E commerce app.

[yousefalmutairi]

Indians are the best lecturers in the world!

[SONU]

Absolutely awesome ....loved your tutorials... :) :)

[sainadh]

k if i want to specify 2 null values so how I can do this and 1 doubt sir in content values you are specifying only Name key but why address also accepting null.Pls can you explain this.

[adityaagarwal]

How can someone dislike this video. Thanks vivz.

[zakariasahmy]

i have a question about the null column hack for examlpe if you have several columns it is enough to specify only one and the others automatically support null values !

[fredchan]

Waitting for the next sqlite totorial...

[csunny]

u r awesome as usual i have the source code for all these sql slides???

[Hasmenification]

Hello dude i like ur tutorials very much :) but now in this tutorial i dont know where to pot this code.. :) in last few tutorials u showed where to put and now i cant get where to put it :D please tell me where :}

[MuhammadWaqas-uxzu]

Sir.. kindly learn Ormlite database for android

[mertserimer]

About your database tutorials, they are very nice! but i would like to add some important feedback. Although your code about that  sqlite insertion is really well-performed and it is very slow when it comes to performance . So i dig up some information how to fasten it in stack overflow and they suggested me to insert like this!! Use transactions and SQLiTEStatements!!

String sql = "INSERT INTO "+StudentHelper.TABLE_NAME+"" +
                "("+StudentHelper.FIRSTNAME+", "+StudentHelper.LASTNAME+", " +
                " "+StudentHelper.GPA+") values(?, ?, ?)";
        SQLiteDatabase db = sh.getWritableDatabase();
        db.beginTransaction();
        SQLiteStatement stmt = db.compileStatement(sql);

        stmt.bindString(1, s.getFirstName());
        stmt.bindString(2, s.getLastName());
        stmt.bindDouble(3, s.getGpa());

       
        stmt.clearBindings();

       
        db.endTransaction();

        return s.getId();

Please make new video for this insert case!!