space1000

how to delete duplicate record in a table by using SQL query

Hi there. i would like this procedure to delete all rows in 'sale' where date_modified < (getdate() +0.02) and all the related rows from 'sale_detail' and 'sale_address' i have written the code below, but ti think this might only delete one row from sale and its related rows in the …

I am relatively new to mysql. I am updating a site for a customer, and I'm using mysql 5 w/ phpMyAdmin. I was supplied an .sql (echeck.sql) script to build the database for this site. I create a database named "echeck" in phpMyAdmin, and once created go to the import …

Hello all. This is my first post. I'm a software engineer with a general knowledge of SQL, but am no where close to an expert, let alone an intermediate. My current issue is I'm working on a query which combines 2 tables: TableA UniqueID Auto Increment ProjectName String <Extra Data> …

I'm dealing with queries that manages a lot of data consolidation and I'm having to repeat large blocks of code to get the desired result. I'm wondering if that is any way to make it simple. My queries looks like this: [CODE] SELECT (A + B) AS C, (D + …

Hello, I have a problem with a varchar(15) field. We export this record with a bcp command and I get an new line in the export file from the specific field. When I look at this field then I just see 12 numbers in it. When I do a len …

Hi everyone, I was trying to setup MySql with Cygwin so that i can create and work on databases using my Windows OS. After gruesome hours of googling, I am still confused as to how to do that. I first downloaded the installer for MySql on windows. I also downloaded …