I have written a little hack to include Maatkit Visual Explain Output in phpMyAdmin whenever an EXPLAIN command is run. It then shows the default...

beberlei

12-30-2007 07:14 AM
beberlei

We are using a spring wireless connection card on one of our laptops, and we have a dynamic ip assignment service (ODS.org, DynDNS.org) to update a...

Adam Grant

12-29-2007 08:33 PM
Gordon Burditt

Greetings! I'm looking to add a stored procedure that will ALTER an existing view. Strangely, it isn't working.. and I could swear it was before, as...

Michael Martinek

12-29-2007 08:08 PM
Kees Nuyt

Hello All, Below is a snippet of code I use to add new users. Essentially after I add the new record I get back the userid which is an auto...

Daniel Kaplan

12-29-2007 05:14 PM
Gordon Burditt

Could you help me with a SQL example to remove all text enclosed in brackets in a field. E.g.: Before : "blahblah (blah) blah" After : "blahblah...

eguttridge@gmail.com

12-29-2007 04:34 PM
Paul Lautman

I keep gettng a syntax error. Can anyone tell me why...? tanks! DB mysql -hp41mysql87.secureserver.net -uthe0727704132865 -p the0727704132865...

dave

12-29-2007 04:32 PM
Paul Lautman

Hello, I am trying to run the following command: Source C:/Documents and Settings/Mike and Anna Marie/My Documents/ Mysql...

AMP

12-29-2007 02:42 PM
Jerry Stuckle

Hello, I am going crazy. I cant find the problem with this statement, But I keep getting the error: You have an error in your SQL syntax; check the...

AMP

12-28-2007 07:44 PM
AMP

Hello, I've a table in wich I've a few columns containing dates: create table dates( Iddates integer unsigned not null auto_increment, IdGroup...

Bob Bedford

12-28-2007 12:37 PM
Paul Lautman

Hello everybody I'm facing a problem of performance: i'm managing packages of thousands of products, that will be loaded in almost 10...

korovev76@gmail.com

12-28-2007 12:33 PM
Peter H. Coffin

I have been having a hard time trying to figure out this problem. It might be a simple suggestion but I am new to scripting and MySQL and any help...

jtrainaldi

12-28-2007 11:11 AM
jtrainaldi

does mysql support array datatype now?

jo3c

12-28-2007 05:29 AM
Norman Peelman

Hi all. I have a table which looks like this: CREATE TABLE table_1 ( column_1 INTEGER AUTO_INCREMENT PRIMARY KEY, column_2 TEXT NOT NULL ); INSERT...

Mikhail Kovalev

12-28-2007 03:48 AM
Willem Bogaerts

helo. i'm having some difficulties with characters sets and collation that probably spans across three distinct areas: a mysql table, showing the...

and.hocevar@gmail.com

12-27-2007 06:29 AM
and.hocevar@gmail.com

Hello. I start to write a simple Database management tool and i want to display the number of rows in a table. Unfortunately MySQL is extremely slow...

llothar

12-25-2007 10:54 PM
John Nagle

Hi, My company developed an Intranet Application with MySql and PHP. It works rather fine, but multi users are not really supported. User 1 reads...

Marc Mendez

12-25-2007 11:14 AM
Marc Mendez

Hi Some sql queries are refused in our production server, for example : update institution SET Gal_Nom = REPLACE(Gal_Nom ,'É','É') Server...

slambert

12-24-2007 01:06 PM
slambert

I have a stored proc like the following. It works on a table called ProductType with only one field, called ProductTypeName. DROP PROCEDURE IF...

Bruno Panetta

12-23-2007 02:31 PM
Ana C. Dent

Hello, I have set up mysql with the default settings and I have 3 root users, localhost, 127.0.0.0. and "production". What is production as a...

AMP

12-23-2007 01:02 PM
Kees Nuyt

Hello, I have a small windows worgroup and I am trying to connect to a mysql DB on one of the machines but I dont know how to specify the host. Any...

AMP

12-23-2007 10:20 AM
Peter H. Coffin

On 22 déc, 12:14, "J.O. Aho" <u... (AT) example (DOT) net> wrote: Seems like i can't use GROUP BY after ORDER BY

Axelar

12-22-2007 05:17 PM
Paul Lautman

On Dec 21, 10:35 pm, "J.O. Aho" <u... (AT) example (DOT) net> wrote: Or just drop the table and then recreate it (minus the data).

Vernon Wenberg III

12-22-2007 01:15 PM
Kees Nuyt

Hi all, I have create a table A with a foreign key for a relation to table B. The relation must be benot null so the corresponding attribute is...

Pierre Gilquin

12-22-2007 12:52 PM
Ana C. Dent

I'm very confused. What prevents anyone from running this without needing to know the original password: C:\> C:\mysql\bin\mysqld-nt...

AMP

12-22-2007 02:40 AM
Kees Nuyt

Hi, So I downloaded the source, found ft_static.c, edited it and saved it as /etc/stop_words.txt. What I really want to do is to stop ".php", while...

Sandman

12-22-2007 12:42 AM
Sandman

Hello All, I am using 'phpMyAdmin - 2.8.1' with 'MySQL - 5.0.21'. In my list of database 'overhead' this word is comming. What is mean by...

pradeep

12-21-2007 06:03 PM
Kees Nuyt

Hey guys, I'm really pissed off atm because mysql has locked me out of the MYSQL command line. I had a password and now it doesn't work how do i...

chrisdude911

12-21-2007 06:00 PM
Kees Nuyt

Hi all, thanks for taking the time... Here's a sample query: SELECT a.*, p.* FROM author_information a LEFT JOIN products p on (a.authors_id IN (...

kevin

12-21-2007 11:47 AM
kevin

Hello All, My Server crashed due to power outage, when mysql restarted the my databases appeared to be there, but all the tables seemed to...

Peter.McCreath@googlemail.com

12-21-2007 09:42 AM
Peter.McCreath@googlemail.com

I have a table that imports data from text files, and the dates come in as YYYYMMDD into a varchar column. I need to compare those dates to a column...

Steve

12-21-2007 08:44 AM
Captain Paralytic

I want to conncet mysql with mssql.. how to do?

zhuxingsheng@gmail.com

12-21-2007 05:55 AM
Captain Paralytic

On 21 Dec, 10:36, g... (AT) amethystmailing (DOT) co.uk wrote: You can use table aliases or table qualiiers to do what you want. For example,...

Captain Paralytic

12-21-2007 04:43 AM
Captain Paralytic

I have installed mysql-devel 6.0.3-0.glibc23.i386 on my Fedora 6 box. gptr seems to be a problem when I compile my C client code with mysql- devel...

crybaby

12-21-2007 04:07 AM
crybaby

Thanks much for the prompt reply. Could you recommend a book i might buy? I have several but they never touch the subject of arrays. Thanks...

Joe

12-20-2007 07:37 PM
Peter H. Coffin

Hi, I am using PHP to query two tables in the same database, but am getting a "mysql_query(): supplied resource is not a valid MySQL-Link resource"...

Rich Bradshaw

12-20-2007 04:54 PM
Paul Lautman

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I'm using the gui tools mysql-query-browser, inserting into an innodb table. Autocommit is turned off...

Chuck

12-20-2007 02:06 PM
Chuck

Hi guys, Been trying to use ON DUPLICATE KEY UPDATE on a MyISAM table with a multi-column primary key, and I keep getting a syntax error...

jezaustin@gmail.com

12-20-2007 10:05 AM
Paul Lautman

In article <5sv87iF1bhg1dU1 (AT) mid (DOT) individual.net>, user (AT) example (DOT) net says... Not really understood the reason why, but I'vs...

YoLed

12-20-2007 07:24 AM
YoLed

Yes, except that the OP did NOT insert a 0, but MySQL "assumed" a default of 0 because the column is defined as "not null". -- Martijn...

Pierre Gilquin

12-20-2007 05:09 AM
Pierre Gilquin

Here's the basic statement: SELECT * FROM `log` LEFT JOIN (`ticket`, `responder`) ON `log`.`ticket_id` = `ticket`.`id` AND `log`.`responder_id`...

ashore

12-19-2007 03:53 PM
ashore

I'm running a web app with MySQL 5.041-community-nt on my web server and on my development machine. Both environments run Apache 2.2., Windows XP,...

weheh

12-19-2007 10:41 AM
weheh

Hi, we are running a few databases (about 10) on a RedHat ES. I just saw that in some of the folders, theres only a FRM file and no MYI or MYD. The...

TT

12-19-2007 07:43 AM
Kees Nuyt

hi all, i need the data from the database to be fetched into an existing pdf document ,that too to appropriate textinput boxes.Plz pour in...

Lawrence

12-19-2007 12:05 AM
Lawrence

Hello, I am a newbie using mySQL. I have exported a database with an administrative user. The owner of this database was user1. But I would like...

Ricardo Pan

12-18-2007 07:06 PM
Gordon Burditt

Hello, I am beginning to using MySQL stored procedures in a production environment. Being as open ended as possible, I was hoping people here could...

michikono@gmail.com

12-18-2007 06:44 PM
michikono@gmail.com

Are transactions supported for ENGINE=MEMORY tables? John Nagle

John Nagle

12-18-2007 06:17 PM
John Nagle

Hi, I have two tables, event and photo. Event holds all the information for an event whilst photo holds all photos uploaded for that event. Now I...

Iain Adams

12-18-2007 05:38 PM
strawberry

Steve wrote: Why are you not just joining?

Paul Lautman

12-18-2007 03:31 PM
Paul Lautman

i saw this error is sometimes caused by a bug ... what should i do to fix this problem? i obtain an error : Can't find record in...

12-18-2007 12:49 PM
Peter H. Coffin

Hi ng, I ve been search quite a while on the following problem but havent found a satisfactory solution yet. I have a fulltext search which works...

IrrE

12-18-2007 08:45 AM
Captain Paralytic