Skip to content
IT Nursery
  • Home
  • Programming
    • Mac / IOS
    • Android
    • Web Applications
    • PHP
    • Java
    • C
    • C++
  • DataBase
    • MySQL
  • CMS
    • WordPress
  • System and Network
    • Serverfault

insert

Mysql load from infile stuck waiting on hard drive

by IT Nursery

I’ve got a windows 7 64 bit machine that I’m using for some load testing of a mysql db. My program uses sqlalchemy … Read more

Tags bulk, innodb, insert, MySQL, mysql-5.5

Select one name per person where spelling variations exist

by IT Nursery

I have a source table that contains Employee IDs and names. The employee names may be listed multiple times with variations on the … Read more

Tags duplication, insert, select, sql-server-2008-r2

Subquery in the VALUES clause

by IT Nursery

Here’s a real-world schema: CREATE TABLE [dbo].[Setting] ( [ID] [BIGINT] NOT NULL, [Module] [NVARCHAR](400) NOT NULL, [Property] [NVARCHAR](400) NOT NULL, [Value] [NVARCHAR](4000) NULL, … Read more

Tags insert, sql-server, sql-server-2008-r2, t-sql

SQL 2012 insert data into a table from another table and custom columns

by IT Nursery

I’m trying to insert data from one table into another table and I also have 4 columns that are not in the source … Read more

Tags identity, insert, sql-server, sql-server-2012

INSERT into three tables with many-to-many from one table

by IT Nursery

With Postgres 9.5 using a trivial example. Given I have this data: Table everything: | fruit | country | |——–|———| | Banana | … Read more

Tags cte, database-design, insert, postgresql, postgresql-9.5

Pass Parameters to trigger function to execute dynamic SQL

by IT Nursery

I have this code which was solved by Erwin: Execute dynamic INSERT ON CONFLICT DO UPDATE in plpgsql function Now I want the … Read more

Tags dynamic-sql, functions, insert, plpgsql, trigger

Negative number of rows inserted

by IT Nursery

I just ran a rather simple INSERT statement (that I think processed a lot of rows), and I got the message: -1,311,750,183 rows … Read more

Tags insert, oracle, oracle-11g

Speeding up insert in SQL Server

by IT Nursery

I have a stored procedure which inserts some records in a few tables. In couple of tables at least , the inserted records … Read more

Tags insert, performance, performance-tuning, sql-server

INSERT performance degradation in SQL Server after a certain number of columns

by IT Nursery

I’m working on an application which has a feature of export of tabular data into a specified database table. The app uses INSERT … Read more

Tags insert, performance, sql-server, sql-server-2014

Want to know whether an ‘UPSERT’ operation performed INSERT or UPDATE

by IT Nursery

I have a query where I try to insert a record and ready to update in case the record exists. The question is … Read more

Tags insert, MySQL, update
Post navigation
Older posts
Page1 Page2 … Page17 Next →

Recent Posts

  • Advice for improving internal dashboard [closed]
  • grep : ‘+’ special character
  • File location for Syslogs in Centos machine
  • How to collect users’ task completion times?
  • “service {FOO} start” vs. “/etc/init.d/{FOO} start”? [closed]
IT Nursery
Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

Important Link

  • About
  • Privacy Policy
  • Contact

IT Nursery

The Goal of ITNursery Engaging the world to foster innovation through aggregate information. Our Question Answer post, blog information, products and tools help developers and technologists in life and at work.

copyright © 2023 All Right Reserved | IT NurSery