MySQL Database Forum

I'm trying to process a series of records sequentially using a routine something like this using Delphi 7/Zeos Components # retrieve result set: Query.SQL.Clear; Query.SQL.Add(' SELECT * FROM items WHERE invoice = :invoicenumber '); Query.Open; # process each record of result set WHILE (invoicenumber = item.invoice) DO

Here is the situation: I have one table that lists a number of courses available (including CourseID, CourseName and MaxPositions), with CourseID being auto_increment and unique I have another table which has CourseRegistration (Containing CourseID and CustomerID), with no unique fields. Customer information is stored elswhere.

This is the currernt table strucure PHP:-------------------------------------------------------------------------------- CREATE TABLE games_developers ( developers_id int(5) NOT NULL auto_increment, developers_name varchar(255) NOT NULL default ' ', language_id int(5) NOT NULL default '0', PRIMARY KEY (developers_id,language_id)

Hi! I'm currently trying to move from MS SQLServer to MySQL, running on windows XP. When trying to connect to mysql on localhost with mysql control center I get the 2013-error "Lost connection to MySQL server during query". I can connect from command line. If I do so, and change passwords by using OLD_PASSWORD('<password>'), control...

Greetings all I am not able to GRANT file permission to users. All permissions end up being issued with FILE being left out. What could I be missing? I running 3.23.53 on Mac OS 10.2. Thank you. ------------- David Scott

Good afternoon, I'm looking for information on good benchmarking implementations with which to test MySQL using multiple clients. The benchmark utilities included with MySQL are, as far as I understand, an implementation of the old Wisconsin Benchmark, and as such are designed to test only a single client sending queries to the database. ...

Hello... I'm using mysql(4.0.13) on linux. I want to create logs only for one database or for one user. Is this posible :S ?! Thaks.

I'm attempting to create a database which will take information from one (perhaps two) tables and utilize that information to return queries to a report designed in Excel. The general idea I have is this: The "primary" or "source" table is easy. This is a trial balance (account number as a primary key, description, amount). I'll need...

I'm trying to run this query: SELECT * FROM features WHERE food_group_ID = 'Company™' I've tried Company%99, Company™ Company&trade; and nothing returns. What do I need to pass from a jsp page to represent the trademark in MySql? Thanks

MySQL v 3.23.56 for pc-linux-gnu on i686 How do I know what database I am 'using' ? I launch mysql from the command line. Type 'show databases', then pick a database to use by typing 'use databasename'. I am now using that database but have no visual cue. How do I include the username, database name, etc in the 'mysql>' prompt?

Hi list, Does any know how to do differential backups or does exist a tool that do this kind of backups. I have mysql 4.0.12 and use innodb tables, mysql is running on redhat 7.3 Greetings and thnx in advanced

Is there a way for a user to get knowledge about his own privileges? For example can a user know if he/she has rights to INSERT INTO some = table? I'm using PHP4 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dmysql@freebsd.csie.nctu.edu.tw

does MYSQL have a quota built into it! I need it limit the size of each database AndiC

------=_NextPartTM-000-9d33d8eb-e0d3-4d76-a380-5fa9aa2655ce Content-Type: multipart/alternative; boundary="----=_NextPart_000_0006_01C35895.7A7400E0" ------=_NextPart_000_0006_01C35895.7A7400E0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable hi all,

I'm looking for some assistance in using Embedded SQL in C using VC++ 6.0 to connect to MYSQL in Windows XP. This is new to me, but it is my understanding that I need to use a precompiler. I'm confused about where to get the precompiler. Can someone explain in simple straight forward terms what I need in order to do this? I've been...

Hi, Does anyone know if it's possible to have a field automatically update itself with the contents of another field in MySQL? I have 2 fields DueDate and DaysOverdue. DueDate is a date field and DaysOverdue is todays date minus DueDate. I can do this is using a sql statement. However, can I make it automatic so that as soon as DueDate...

Hello Tim, Do've an example on using Rebol to connect to mySQL via TCP/IP? How do you do it? How do you execute SQL quieries? Return results etc ? Do you use some kind of "middleware" that your communicating to from Rebol via TCP/IP which gets the data for you? I'm actually a Delphi, Java, VB, Perl & Ruby developer (done alittle Rebol...

Hello... I'm using mysql(4.0.13) on linux. I want to create logs only for one database or for one user. Is this posible :S ?! Thaks.

have multiple domains on winodws 2003 (IIS) what best way to setup mysql i would like a limit on each domain on the number of databases if possible (see other post), if not i gues i will have to create them i also wish each domain the have phpmyadmin access. any ideas.. one the best way AndiC

I get the following error: "Unknown table 'tabel_b' in where clause", when I try to run the following SQL in phpMyAdmin: UPDATE table_a SET table_a.value = 'text' WHERE table_a.number = table_b.number AND table_b.id = 1234

I have a form which ads a technician service ticket into mysql. The fields are tech name time spent service client name etc... I assumed that mysql was storing the date of each record added to the

Hi. With MySQL 4.1.0 alpha when I try to set default character set to tis620 MySQL start OK but have crash every time when perform to tun query (with default_character_set=latin1 it never got error) and with MySQL 4.0.14 it can do with out any error. With MySQL 4.1.0 alpha what GUI to use for connect to MySQL server with out error (due...

I am using mysql 4.1.2 on a Win2K (SP3) host. I cannot seem to create a useable MyODBC DSN unless I set user=ODBC with no password. When I try to test a non-null password in the DSN configuration dialog for ODBC 3.51 I get the error message: " Client does not support authentication protocol requested by server; consider upgrading MySQL...

In one of my logfiles I have quite repeatedly the following message: InnoDB: Warning: using a partial-field key prefix in search What does this warning mean ? Regards, Marc Mechain Atos Origin

I am trying to create a CSV using mysqldump that will be viewed in MS Excel, and have a formatting question. From the command line I type: > mysqldump "--where=ent_date > \"2003-07-01\"" databasename tablename --user=username --password=password > newfilename.csv A dumpfile is created in the expected location with the appropriate data. ...