Run the command from terminal to create the page.
We have written a detailed tutorial on Configure Routing & Navigation in Angular. Secondly, we will make the small change for the song route in the app routing file. On this page, we show the song data, and a user can perform the update operation as well. The artist_name and song_name values belong to the string data type. Song_name TEXT ) INSERT or IGNORE INTO songtable (id, artist_name, song_name ) VALUES ( 1, 'Justin Bieber', 'Yummy' ) INSERT or IGNORE INTO songtable (id, artist_name, song_name ) VALUES ( 2, 'Jonas Brothers', 'What A Man Gotta Do' ) INSERT or IGNORE INTO songtable (id, artist_name, song_name ) VALUES ( 3, 'Life Is Good', 'Future' ) INSERT or IGNORE INTO songtable (id, artist_name, song_name ) VALUES ( 4, 'Lauv', 'Tattoos Together' ) INSERT or IGNORE INTO songtable (id, artist_name, song_name ) VALUES ( 5, 'Heavy Steppers', 'Whateva' ) INSERT or IGNORE INTO songtable (id, artist_name, song_name ) VALUES ( 6, 'DigDat 2020', 'Ei8ht Mile' ) INSERT or IGNORE INTO songtable (id, artist_name, song_name ) VALUES ( 7, 'Blackbear', 'me & ur ghost' ) INSERT or IGNORE INTO songtable (id, artist_name, song_name ) VALUES ( 8, 'Hailee Steinfeld', 'Wrong Direction' ) Īs you can see, we defined the SQL table, in which there is an ID which is set to auto-increment.
#Sqlite database tutorial how to#
Let’s add some dummy data, and we can add even data in JSON format however, in this article, i will teach how to add SQL data.Ĭreate a SQL file inside assets/dump.sql folder and insert the following data in it.
0 kommentar(er)
