sql-insert

相关标签：javascript jquery android 多少钱 iPhone

Need a sql statement to do upate and insert at the same time

I need a sql statement, to insert a new row in one database table and update an exist开发者_如何学运维ing row in another database table based on some conditions.[详细]

2023-04-11 22:42 分类：问答
Efficiently duplicate some rows in PostgreSQL table

I have PostgreSQL 9 database that uses auto-incrementing integers as primary keys. I want to duplicate some of the rows in a table (based on some filter criteria), while changing one or two values, i.[详细]

2023-03-28 23:02 分类：问答
Firebird sql to insert a typical record from another table with only one different field

开发者_如何学CI work on Firebird 2.5 and I have two tables, all their columns are similar except one has a primary key with auto increment and a not null foreign key field (A) for master table[详细]

2023-03-22 01:39 分类：问答
inserting and deleting not happening in local database (.sdf)

When I try to select values from a local database it executes without any issue. But when I try to insert and delete it\'s executing the query but it\'s not affecting any rows.[详细]

2023-03-21 21:40 分类：问答
Insert Record or Update Record If Exists in Table In One Query in MySQL

My Table member_id - profil_id - A - B - C 12100 13010 I want to update record for (member_id=1 and profil_id=2 and A=1)[详细]

2023-03-14 03:24 分类：问答
DBD::SQLite: Insert or Update - Question

While writing my question (howto: insert a new entry and if it exists already, update it) I found some answers in the Related Questions:[详细]

2023-03-05 12:46 分类：问答
Deleting in database?

I 开发者_运维技巧have a question about the databases in Android. I had created in my app a database. If I delete a record from database, for example the last one, and after that I insert a new record[详细]

2023-03-02 19:19 分类：问答
Saving timestamp in mysql table using php

I have a field in a MySQL table which has a timestamp data type. I am saving data into that table. But when I pass the timestamp (1299762201428) to the record, it automatically saves the value 0000-00[详细]

2023-02-24 17:13 分类：问答
C# database update

I\'m stuck on a little problem concerning database. Once a month I get a XML file with customer information (Name, address, city,etc.). My primary key is a customer number which is provided in the X[详细]

2023-02-24 04:57 分类：问答
Update two SQL table columns based on view (SQL Server 2000)

I\'m struggling with a SQL question.. We use enterprise manager to communicate with SQL Server 2000. Background:[详细]

2023-02-17 13:48 分类：问答