FW: Slow Access When Inserting Records

2006-10-13 Thread Neil Tompkins
Inserting Records At 01:56 PM 10/8/2006, Neil Tompkins wrote: Hi, We have a mySQL database running version 3.23.58 on a linux machine. This database is accessed from both a Windows IIS web server and a linuz zeus web server. On the linux server I'm not sure of what driver etc

RE: Slow Access When Inserting Records

2006-10-12 Thread Neil Tompkins
PROTECTED] Subject: Re: Slow Access When Inserting Records At 01:56 PM 10/8/2006, Neil Tompkins wrote: Hi, We have a mySQL database running version 3.23.58 on a linux machine. This database is accessed from both a Windows IIS web server and a linuz zeus web server. On the linux server

RE: Slow Access When Inserting Records

2006-10-09 Thread Neil Tompkins
@lists.mysql.com From: [EMAIL PROTECTED] Subject: Re: Slow Access When Inserting Records At 01:56 PM 10/8/2006, Neil Tompkins wrote: Hi, We have a mySQL database running version 3.23.58 on a linux machine. This database is accessed from both a Windows IIS web server and a linuz zeus web server

Slow Access When Inserting Records

2006-10-08 Thread Neil Tompkins
Hi, We have a mySQL database running version 3.23.58 on a linux machine. This database is accessed from both a Windows IIS web server and a linuz zeus web server. On the linux server I'm not sure of what driver etc is installed, however the access time to save a record is far quicker than

Re: Slow Access When Inserting Records

2006-10-08 Thread mos
At 01:56 PM 10/8/2006, Neil Tompkins wrote: Hi, We have a mySQL database running version 3.23.58 on a linux machine. This database is accessed from both a Windows IIS web server and a linuz zeus web server. On the linux server I'm not sure of what driver etc is installed, however the access

Inserting records from one table to another respecting a condition

2004-07-29 Thread C.F. Scheidecker Antunes
Hello all, I have two mysql tables. They have a slightly different structure but share comom columns. I need to get the top 100 sold parts ( partnumbers and quantities) from table Sales and insert into table Suggestion if I issue a query : SELECT partnumber,qty from Sales order by qty desc

RE: Inserting records from one table to another respecting a condition

2004-07-29 Thread Laercio Xisto Braga Cavalcanti
julho de 2004 19:01 To: [EMAIL PROTECTED] Subject: Inserting records from one table to another respecting a condition Hello all, I have two mysql tables. They have a slightly different structure but share comom columns. I need to get the top 100 sold parts ( partnumbers and quantities) from table

RE: Inserting records from one table to another respecting a condition

2004-07-29 Thread Dathan Vance Pattishall
: Inserting records from one table to another respecting a condition Hello all, I have two mysql tables. They have a slightly different structure but share comom columns. I need to get the top 100 sold parts ( partnumbers and quantities) from table Sales and insert into table Suggestion

inserting records into database with utf8 char-set

2003-01-03 Thread Dana Sharvit
Hello, I am attempting to insert a string in utf-8 to a text field using DBI but mysql does preserve the original char_et but rather changes it, does any one have any idea why? I am working with Mysql 3.23.36 DBI-1.30 Thanks Dana

RE: inserting records

2002-10-16 Thread Greg Knaddison
Ok, so I've broken down your problem into small, manageable steps. First, users are provided with a box to enter a value (e.g. pumpkin) and the 1)ability to select a ranking for pumpkin, or 2)the ability to select which old value (apefruit) the new value-pumpkin-belongs above/below (scenarios 1

inserting records

2002-10-15 Thread kayamboo
Hello folks ** sql,query * Can anyone give me a clue, how to solve this problem I have a table with only one column and values are inserted by getting user request from my application. I want to display the column values in the order they are inserted. So only option is

Re: Inserting records with null foreign keys?

2002-03-21 Thread Heikki Tuuri
on InnoDB -Original Message- From: Rick Flower [EMAIL PROTECTED] To: MySQL Mailing List [EMAIL PROTECTED] Cc: Heikki Tuuri [EMAIL PROTECTED] Date: Wednesday, March 20, 2002 10:56 PM Subject: Inserting records with null foreign keys? Hi all.. I noticed that the current version of InnoDB

Inserting records with null foreign keys?

2002-03-20 Thread Rick Flower
Hi all.. I noticed that the current version of InnoDB that is part of MySQL 3.23.47 does not allow using null foreign keys when doing inserts.. Is this intentional or a bug? This is allowed by SQL Server as a minimum (a test is being done by a co-worker currently against Oracle 8i to see

Inserting records from Access creates Automation Error

2002-02-28 Thread Alexander Shaw
Hi all, I have an application that is running under Access 2000 connected to a MySQL backend (3.23.46) via ODBC 3.51. Currently I'm trying to run a query and then scroll through the results inserting into a table via the ODBC link. All is well with the fields which contain numbers, but the