![]() If there are other fields besides the number list for a specific id, make another table like the one above, where id is a foreign key in the main table. Each trigger must specify that it will fire for one of the following operations: DELETE, INSERT, UPDATE. Triggers are database operations that are automatically performed when a specified database event occurs. Much easier way is to store the two-dimensional data by separate ids for row and position: id | pos | value Description The CREATE TRIGGER statement is used to add triggers to the database schema. Also even if you come up with a working solution, the risk that your program works only on one database is considerable. 1 As another user noted, relational databases work best with single values stored in columns. If you must do that, you should declare the column as TEXT or VARCHAR the list like you showed above cannot be stored in to a numeric column.Ī full answer is question of some heavy SQL programming. See string functions and stored routines. You would need to create a custom procedure for that. ![]() You are also able to modify data either one by one or in bulk. UPDATE functions similar to INSERT (in that you specify columns and their desired values) and DELETE (in that you provide the criteria needed to target specific records). That said, you can parse the value (split by delimiter), increment the numbers, join them to a string and update the row. SQLite allows you to change the values in records using the UPDATE SQL command. As another user noted, relational databases work best with single values stored in columns. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |