insert

I will immediately make a reservation that I understand that it would not be worth using a snake for such purposes, but I som ... There is no code, because the very beginning of this algorithm (apparently) is the problem. I hope you will have suggestions.

Hello everyone, I'm trying to insert a new record into the table, with a duplicate check. After executing the request, I have ... e does not have a row with a field that corresponds to such and such an IDshnik (the ext_id field, it is unique for all rows)

The table contains two columns: id | description How do I make it so that when a new line is added, the user ID will grow itself? That is, INSERT INTO users DEFAULT VALUES; Will give (1,), (2, ) , and so on.

Partitioned table created with automatic partitioning (range, interval-1, key-number) partition by range (gr_id) interval (1 ... Can I in this case do you want to use automatic partitioning, or do you have to hard-code all partitioning for single values?

Some parts of the package use insert into select from, and some parts use insert into select from.- bulk collect + forall ins ... view, does one of these methods have an advantage in speed or other aspects of execution, or are they completely equivalent?

Hello Basics, help a novice programmer to make a function with saving the date in MYSQL. The thing is, the user has a form in ... It stores the record in the reverse format yyyy-mm-dd how do I correctly save the entry entered by the user to the database?

Good day to all! I create a trigger for updating the table, during which you need to write all the changed fields to the tabl ... hank you in advance! The table is valid: create table #A ( Name nvarchar(max), Sex nvarchar(max) )

Hello! Today, for the first time, I encountered ON DUPLICATE KEY UPDATE and did not fully understand how it works. Making a ... if topic_id and user_id already exist (unique), and date_comleted is different, otherwise a new row with new data is created.