Hi I've just upgraded my installation for 3.29 to mysql Ver 14.3 Distrib 5.0.0-alpha, for portbld-freebsd4.5 (i386) ( via the mysql --version...

LeTubs

06-29-2004 08:13 AM
Gnurp Gnarp

Hey ppl, I'm experiancing a very weird problem with my current Win32(win2k/XP) application. I'm using: * Delphi 7 * ADO * mySQL ODBC 3.51 drivers

JB

06-29-2004 02:03 AM
JB

Does a column which is declared as PRIMARY KEY is also a default INDEX?

Sandra

06-29-2004 12:16 AM
steve

I thought I'd share this since it popped up today. gcc...

Mike

06-28-2004 05:20 PM
Mike

Hi, I'm new to MySQL and I have qustion regarding to CAST and Date_Format functions. I'm trying to convert a column 'Time' varchar(50) to datetime...

Jimmy

06-28-2004 04:16 PM
Jimmy

I installed the MySQL package for mac 10.3 It seem that everything went fine until I try to run mysqld_safe to start the database I end up with a...

Carlos

06-28-2004 12:29 PM
Carlos

Hello, I am running MySQL 4.0.16. I get the error 'The used command is not allowed with this MySQL version' when using the 'load data local infile'...

Rajesh Kapur

06-28-2004 12:08 PM
Rajesh Kapur

Hi there, Maybe this is a strange quesiton but maybe someone can advise. I have created a database and it is getting larger and larger, I wonder...

Ian

06-28-2004 11:31 AM
Vaclav Frolik

I'm delving into the MySQL C API these days. I have Paul DuBois book "MySQL" book by my side. He very quickly introduces functions that I'm unable to...

David List

06-28-2004 07:17 AM
David List

LIMIT works against the result set of the query, not any intermediate result set or table. If you could use MySQL 4.1, I would suggest: SELECT...

Bill Karwin

06-27-2004 04:24 PM
Bill Karwin

Hello, I have the following problem with mysql linking: 1) 'mysql_config --libs' return (correctly) the following: -L/usr/local/mysql/lib...

Bruno

06-27-2004 10:18 AM
Bruno

Did this: revoke all on D_name_01.* from trial_user_01; and got this response: ERROR 1141 at line 4: There is no such grant defined for user...

luther

06-27-2004 03:28 AM
luther

I am running mysql 4.0.16. Optimize table does not work with LOCAL or NO_WRITE_TO_BINLOG options, and gives me mysql error. Any...

steve

06-26-2004 02:09 PM
steve

Optimize table in mysql is nice!! but seems to require table names. Any way I can run it for my entire db? I like to do this in a batch process from...

steve

06-26-2004 01:40 PM
steve

Hi. I have a query that looks like this: SELECT user_id, user_given_names, user_surname, user_cast FROM users WHERE user_id NOT IN (SELECT user_id...

Mattias Nordstrom

06-25-2004 07:28 PM
Isaac Blank

hello, every night i'm running a simple cronjob which created sql-dumps from serevral web applications using a syntax like this: mysqldump...

Dino

06-25-2004 02:43 PM
Bill Karwin

I am having problems with phymyadmin on Windows. When exporting using gzip compression option, and the db is large, I seem to be getting trashed...

steve

06-25-2004 01:59 PM
Jay Donnell

mysql vs sqlite vs hsql First of all i'm on a win32 platform using java. I also have mysql installed. My question isabout benchmarks and multiple...

stan k.

06-25-2004 11:37 AM
stan k.

HI all, For the past several months we have been using LOAD DATA LOCAL INFILE to bulk load tables within Perl modules. Recently, someone thought it...

Jami Bradley

06-25-2004 10:08 AM
Jami Bradley

hi, is there a way to set up an user, how only have restricted admin rights on mysql server. this user only should be able to create DBs (and drop...

Markus

06-25-2004 09:26 AM
Markus

I'm running 4.0.18, and the queries in cache variable grew from about 2K to 30K in a matter of hours when we hardly used the database at all. Has...

David L

06-25-2004 08:57 AM
David L

Hello, I have written a few UDF functions to run on mysql server (linux), they seem to work pretty well although I notice one problem. Say for...

Paul

06-25-2004 08:51 AM
Paul

Hello, How do I convert my existing database, which I'm using MySQL ver 4 for Windows and MyISAM table type to store the data, to the new format...

Sandra

06-25-2004 08:44 AM
David L

Hi folks. I have two Front End Web Servers, two backend MySQL Database Servers (all yet to be built, all Linux RH ES, Apache MyQL etc...) The front...

Martyn

06-25-2004 07:12 AM
Martyn

Hi, I am looking for a software that install php+apache+mysql on my computer and it has builtin php editor .That editor should be connected with...

why

06-24-2004 11:31 PM
why

Hi! I use codepage 1251 to store data in MySQL tables. To support ORDER BY and LIKE on this data I must run MySQL server...

Dmitry Davletbaev

06-24-2004 10:17 PM
Dmitry Davletbaev

I am working on my first database and I think I want to build a table with a foreign key in it. The O'Reilly book on MySQL says that MySQL does...

Jeff Silverman

06-24-2004 06:39 PM
Bill Karwin

My user wood@localhost can't create an index on the databse woodwork... I get the error ERROR 1044: Access denied for user: 'wood@localhost' to...

Root

06-24-2004 05:16 PM
Root

I work with Oracle in a Windows envirmoment and I caan do querys like this: SELECT * FROM SomeTable WHERE Something IN (SELECT...) ; At home I have...

Juan Gabito

06-24-2004 03:21 PM
Aggro

Hello, I am having this problem that is just driving me crazy.. When using Bugzilla with Mysql (all Mysql, Perl, and modules all supplied by RedHat...

Arthur Perry

06-24-2004 11:53 AM
Arthur Perry

Hi, I have a group of records that I need to sort by time field. The time field is a text string (should've been a date/time - I know -doh!) I was...

00steve

06-24-2004 02:56 AM
Felix Geerinckx

First of all i'm on a win32 platform using java. I also have mysql installed. My question isabout benchmarks and multiple inserts & selects SQLITE:...

stan k.

06-24-2004 12:14 AM
stan k.

Dear group I am a newbie to C++, so probably this question has a very obvious answer: I try to compile the example from the MySQL docu...

Baui

06-23-2004 11:34 PM
shawnews

Hi, I'm an sql noob and I would like to know if there is an easy way to query data from this table I have a table with ID,RANK, WORD as columns, id...

Jay

06-23-2004 11:01 AM
Jay

Hello all, I know my questions have been asked several times, but I could not find a clear answer in maxdb documentation nor in the mailing...

ggo

06-23-2004 10:50 AM
ggo

Hello all, I am a beginner with mysql, however installation was fine no problems and I have been trying the Consol Center trying to create new...

Olafur

06-23-2004 03:38 AM
Olafur

Hi Can anybody help me with the following, hopefully simple, question? I have two tables. I wish to add a new column to the beginning of each...

Geoff Jones

06-23-2004 03:19 AM
Aggro

I am writing an application with MySQL as the DB. All connected clients need to know when an add or update has taken place so that the client...

shawnews

06-22-2004 11:33 PM
shawnews

In MYSQL is it possible to shift and splice colums? say I have a table w/fields: name | tele_num | age and I get all the addresses later - address...

leegold2

06-22-2004 10:48 PM
Bill Karwin

I have five tables in my database, there are actually NO common fields between them, not even a KEY or ID or anything like that, except for the...

Beyonder

06-22-2004 09:43 PM
Beyonder

hi, installing mysql on windows 2000 server, getting signal 11 abort after a bunch of zeros fly by on first startup of C:\mysql\bin\mysqld...

Brad Waddell

06-22-2004 08:42 PM
Brad Waddell

when i start winmysqladmin.exe , i get a message that it could not find the DLL libmysql.dll - but it is in the path, i have even tried copying it...

Brad Waddell

06-22-2004 08:40 PM
Brad Waddell

I am trying to get the following: "pull the last, oh, 1000 topics, and rank that population by board posted-to and comments" Here is the query as...

Gary Hampson

06-22-2004 06:41 PM
Bill Karwin

Hello all. I'm trying to get mysql installed on OpenBSD 3.4. Unfortunately, it appeares that the port only installes the mysql-client, and one needs...

niku

06-22-2004 05:46 PM
niku

On Sun, 20 Jun 2004 17:59:44 GMT, Aggro <spammerdream (AT) yahoo (DOT) com> wrote: these don't work I get an error 1045 access denied. Yes the...

John

06-22-2004 05:16 PM
Aggro

Is there a way to watch what queries come into the MYSQL server? What application should I use to do this? Thanks!

Jon Glazer

06-22-2004 03:44 PM
Mike Chirico

I'd like to write a program to verify the consistency between various database replicas in our environment. The rules are as follows: - I'm given...

Michael

06-22-2004 02:41 PM
steve

I'm writing software against the MySQL ODBC driver, managing connections to Mysql 4.0/Linux. server. How does MySQL manage connections/sessions that...

Thomas Bartkus

06-22-2004 09:31 AM
Thomas Bartkus

Folks, I'm working on an ecommerce website that deals with credit card expiry dates. The table has two columns for year and month. I currently...

Randell D.

06-22-2004 09:09 AM
David L

I have a Product table, a Categories table and a join table that contains product to category mappings (each product can be in many...

sks

06-22-2004 02:14 AM
Bill Karwin