FW: Slow Access When Inserting Records

2006-10-13 Thread Neil Tompkins
ect: 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 linu

RE: Slow Access When Inserting Records

2006-10-12 Thread Neil Tompkins
; 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

RE: Slow Access When Inserting Records

2006-10-08 Thread Neil Tompkins
mysql@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 databas

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 t

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 t

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

2004-07-29 Thread Dathan Vance Pattishall
D] > 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) f

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

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 lim

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 t

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 notic

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 how

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 longe