How to Create Multiple Tables in SQLite Database in Android Studio | MultiTables

How to Create Multiple Tables in SQLite Database in Android Studio | MultiTables | Android Coding

Рет қаралды 48,044

4 жыл бұрын

SQLite Database Tutorial : In This Video, You Will Learn How to Create Multiple Tables in SQLite Database in Android Studio.
All File :
1) activity_main.xml 2) MainActivity.java
3) DatabaseHelper.java
Table Of Content :
0:23 - Project Creation
0:42 - XML Code
3:46 - Java Code
22:55 - Output
Presented By : Android Coding
Background Music By : NoCopyrightSounds
Download Apk Link :
drive.google.com/open?id=195K...
All My App Links :
1) QR Scanner App : bit.ly/ScannerAndGenerator
2) Colors Code App : bit.ly/ColorsCode
3) Age Calculator App : bit.ly/AndroidAgeCalculator
Enjoy & Stay Connected With Us!
► Subscribe To Android Coding : bit.ly/KZfaq-AndroidCoding
► Like Us On Facebook : bit.ly/Facebook-AndroidCoding
► Follow Us On Instagram : bit.ly/Instagram-AndroidCoding
► Follow Us On Twitter : bit.ly/Twitter-AndroidCoding
#MultiTables #AndroidTutorial #12H1r

Пікірлер: 31

@gulabpatel7477 4 жыл бұрын

Hello sir I have one question. Can we operate crude function of database (room , sqlite ) from mobile app to pc localhost like if for example noteapp can run on pc and we can add notes from pc and this added in our mobile too. With help of WiFi or usb cable?

@joaopauloalvesdasilva9888 3 жыл бұрын

What do I do after I created a SQLite table and I remembered I have to add on more column?

@shinyvlogs9148 4 жыл бұрын

hello i have Recompile with -Xlint:unchecked for details error

@roeital5504 4 жыл бұрын

Can u please do a button that if i click it will put a string with a certin id value into a textview please?

@sabrinafeliz4822 3 жыл бұрын

thank you sir so match i tried it and it work correctly, i want to know if there is way when i write price in the first column and qty in second column automatically in the third column appear the price*qty (table or any thing listener )

@gulzara982 4 жыл бұрын

Can you please give me the githublink of scaner and age calculator apps you have created ?

@poyasanjari6209 4 жыл бұрын

hi would you please tell me how can i let users create their own tables??? i really need that. tnx

@Asma-od1vf 2 жыл бұрын

Hello, I am trying to create a database that contains 5 tables and I want to enter data from different activities, for example, event number one. You enter data into the first table and so on, but I need some help and I hope you can help me ...

@binodbhandari7543 3 жыл бұрын

What if there are many column in a single table and what if need to perform different CURD operation in different table when required. Anyway nice video. can you give example of how foreign key operation is done.

@edoardovigogna8034 4 жыл бұрын

this video is awesome!! anyway i have a problem, when i run i don't have error but when i launch the app from the smartphone or the emulator it crash, some ideas? :(

@AndroidCoding 4 жыл бұрын

Thanks. If you have any queries contact me on Facebook or Instagram.

@JunaidiMukhlis 4 жыл бұрын

I have followed the tutorial to completion, but the application cannot be started because the application cannot open and the application stops. Why ?

@c-tecedu9564 4 жыл бұрын

Please upload a single database with multiple tables and also saving image into sqlite

@sanskarrawat1047 4 жыл бұрын

yes sir, please help us in making app as mentioned above.

@rutikrasal7040 3 жыл бұрын

i want to store arraylist in sqlite database can you please help me

@fathimashafana4881 3 жыл бұрын

When i type create table command red line appears below table. Why is it so?? What to do? And hover curser over it, it says expected TABLE but i have written the same.. i m not understanding plzz help

@viralgohil6616 3 жыл бұрын

Sir how to create Separate table class for every table

@smailmerazga8625 2 жыл бұрын

Hello sir 💖 . How I can make sum items in column SQLite and display it at text View

@AndroidCoding 2 жыл бұрын

Will upload soon

@masaratnazir1484 4 жыл бұрын

Can you please share sourcecode?

@faizalalif17 4 жыл бұрын

i try the code not errors but i have a little bit problem my view in spinner only working for product

@naomih3198 4 жыл бұрын

Hi I had the same problem. If you go to Main Activty then done to the method onItemSelected, you should have three if statements below. The first if statement should be position ==0, the next position==1 and the next postition ==2. Hope that helps.

@aslief9808 3 жыл бұрын

@@naomih3198 its still not working.. how to fix?

@anaaguilar3304 4 жыл бұрын

I am not getting any errors and my app is running, however, after I input data and click add , the data does not display . Spinner is working fine, button and toast message are working too. What might be the problem?

@hajaryoona8200 4 жыл бұрын

i have the same problem

@roeital5504 4 жыл бұрын

Maybe u have input that doesnt fit what u wrote

@himanshusingh3380 3 жыл бұрын

There was no need of music !!

@wolfgangkernchen7515 Жыл бұрын

Sorry i got a error o: 'getColumnIndexOrThrow(java.lang.String)' in 'android.database.Cursor' cannot be applied to '(java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String)' after the code while (!cursor.isAfterLast()) { arraylist.add(cursor.getString(cursor.getColumnIndexOrThrow("_id","bereichs_id","aufgabentyp_id","notiz","termin"))); cursor.moveToNext(); } can anybody help ? thanks