I have been testing an earlier Mysql bug and now I know the reason, but not how to fix it. The following code SELECT * FROM ml_lopp LEFT JOIN...

GarryJones

02-08-2007 09:14 AM
Phil

Because of cost and other reasons I would like to redevelop an application in MySql that I started in Access. I like the form(screen) and report...

Hugh N. Ross

02-08-2007 08:45 AM
Walter Vaughan

I use the subject command quite often to load .cvs files into tables and am very pleased with the speed. The "terminated by ','" is, of course what...

Lee Peedin

02-08-2007 07:43 AM
Lee Peedin

On 8 Feb, 10:15, p... (AT) RQNNE (DOT) invalid (Per Rønne) wrote: Yes certainly you can buy that... Please give me your cell phone number. What! You...

Pankaj

02-08-2007 04:57 AM
Captain Paralytic

I am collecting data from a database. This works fine, I can call the data from these tables and display it as I...

GarryJones

02-07-2007 02:55 PM
GarryJones

I'm a somewhat educated newbie in advanced MySQL queries. I'm attempting to create a variety of "top 10" lists related to a database of meteorology...

PWX

02-06-2007 02:35 PM
PWX

I'm currently using a 4.0.27 installation I inherited from someone else. I'd like to upgrade to 5.1(.15) - bells, whistles, bugfixes, security -...

Robert Huff

02-06-2007 01:33 PM
Robert Huff

I have a table and I have to do a certain mathematical calculation for each row. Than I have to select the row with the minimal result of...

nte@index.hr

02-06-2007 12:40 PM
Bill Karwin

Hi Everyone, I have a solution to creating a report of our company's unit hours of activity (time spent serving a call) based on an accompanying...

stevensjn@gmail.com

02-06-2007 10:44 AM
stevensjn@gmail.com

Has anyone used any reliable back and restore appliance with MySql? --Waikit Lau

waikitlau@gmail.com

02-06-2007 06:37 AM
waikitlau@gmail.com

hi I'm using mysql 5.0.27 on fedora core 6. I have the problem that after the first cold database restore I do, the data never updates. Fore example,...

cmap@another.com

02-06-2007 06:35 AM
cmap@another.com

Hi all, I have the following sentence, when I try to run it from TOAD or batch shell i recieve a strange error: insert into...

gnanni82@gmail.com

02-06-2007 04:51 AM
Captain Paralytic

Hi, So I have several tables in a mysql db, which are keyed by my users' email address. I ran various selects and so on, based on email. Right now...

Sandman

02-05-2007 10:00 PM
Sandman

Hello, I have one MySQL BDD (5.0.22) on my server. I want to backup database and restore them on my local PC with the WAMP solution (MySQL...

Arno

02-05-2007 05:20 PM
Arno

I've set up 2 queries that enable me to nest a list of cities within a list of counties. The queries work, but I thought this might be a good...

salvador

02-05-2007 03:36 PM
salvador

How do I efficiently find all objects in a given volume cell? I have simple building blocks stored with their min/max extent in three dimensions...

r-.schmidt@web.de

02-05-2007 11:02 AM
r-.schmidt@web.de

Hello, I have a database of about 130 million records. I need to be able to retrieve a random subset of those records (say random...

mkarbarz@gmail.com

02-05-2007 10:12 AM
strawberry

Hi, I'm trying to convert the following query into mySQL, this currently working with MS SQL although not with mySQL. SET DATEFORMAT dmy declare @d...

davidjohnlong@googlemail.com

02-05-2007 09:53 AM
Captain Paralytic

I'm getting a syntax complaint with the following query SELECT ...

Dan

02-05-2007 02:49 AM
Martin Harran

Hello folks, I am just getting started using PHP + MySQL, coming from Coldfusion + MSSQL and in need of a little enlightenment here. I'm working on...

Bob Imperial

02-04-2007 07:10 PM
Axel Schwenke

I have a table in which a field (ordine) is used for the orderer output of data. This is not an index, since data are subdivided in...

incuso

02-04-2007 04:49 PM
incuso

Hi all, I have a user table in a mysql db, when a user is inserted, I need the generated keyfield from their entry to enter data into another...

Gef.Mongoose@gmail.com

02-04-2007 01:32 PM
Gef.Mongoose@gmail.com

Let's say I have a simple web application running with just two MySQL tables. The tables structure is as follows: Table: category category_id...

Phil Latio

02-04-2007 09:53 AM
Phil Latio

Gary L. Burnore wrote: Horse hockey. It works fine. There is no difference in downloading the package vs. the individual products except that you...

SpreadTooThin

02-04-2007 09:52 AM
Jerry Stuckle

please help me when i connect mysql (mysql -u root -p) then it gives a error it is:--------- Error 2002: can't connect to local mysql server through...

jagdeepkang2000@gmail.com

02-04-2007 08:57 AM
Jerry Stuckle

I have a table in which a field (ordine) is used for the orderer output of data. This is not an index, since data are subdivided in...

incuso

02-04-2007 07:17 AM
incuso

I'm trying to figure out how to run scripts against MySQL to create tables, insert data into tables, etc. I've created a folder within my 'Documents'...

james.walker72@gmail.com

02-03-2007 02:16 PM
james.walker72@gmail.com

Hi guys, I've a query built in this way $query = "SELECT * FROM foo WHERE bar REGEXP '$item' ORDER BY data DESC LIMIT 0,100"; $result =...

zano®

02-03-2007 12:40 PM
zano®

Che cosa può essere? Le due query che cercano sugli ingredienti(r.IDingrediente) o sui piatti(p.nomepiatto), prese separatamente funzionano..... Come...

Cekko

02-03-2007 09:38 AM
zano®

Hi, I have a problem with a stored procedure: It goes as follows: DELIMITER $$ CREATE PROCEDURE `spValidateUser2`(IN _ClassID INT, IN _Username...

René Vutborg

02-03-2007 08:52 AM
Paul Lautman

Hi, I'm ending my website built with php+mysql. In a first moment I didn't want to use mysql but with the help of some manuals and 'how to' I have...

Mr.Orange

02-03-2007 08:33 AM
Mr.Orange

This is on Linux, mysql-4.1.22. As root, I created a user with grant select, insert, update, delete on WebChess to WCuser identified by...

Cameron Fitzhugh

02-02-2007 08:27 PM
Jerry Stuckle

Hi does anyone have an example command line syntax command for importing a delimited flat file with a delimiter into mysql ?? Also, does anyone...

Jack

02-02-2007 06:41 PM
nino9stars@yahoo.com

On 1 Feb, 18:45, "Peter H. Coffin" <hell... (AT) ninehells (DOT) com> wrote: You need also to esplicitly allow any external host to connect to...

hardemr

02-02-2007 12:08 PM
Rob

Gary L. Burnore wrote: Yep. How many databases of that size do you deal with? From your other statements I suspect you haven't gotten over...

Mikee Freedom

02-02-2007 11:56 AM
Jerry Stuckle

Hi all, I was wondering if anyone knew of a way to fill a table with rows of sequential hours spanning a number of years using a query or set...

stevensjn@gmail.com

02-02-2007 11:55 AM
Felix Geerinckx

Can anyone advise me on which has better performance: - REPLACE or - UPDATE ... ON DUPLICATE KEY UPDATE Many...

Andrew2006

02-02-2007 05:32 AM
Andrew2006

I am trying to create a reservation interface for my website. I would like for people to be able to check for availability then make a reservation. I...

deercreek

02-01-2007 12:15 PM
deercreek

I have a master DB using InnoDB, and three slaves currently also running InnoDB for a read intensive apps. We don't use full text search, so there...

howa

02-01-2007 11:32 AM
howa

The default for mysqldump is to enable --opt, which in turn enables --extended-insert. This results in a smaller dump file that is faster to reload....

Jorey Bump

02-01-2007 08:14 AM
Jorey Bump

The table (table1) stores the time and the currency values on each day. It looks like something like that: time USD JPY BGN ...

bmichel@gmail.com

02-01-2007 07:51 AM
strawberry

I have an application running on windows 2000, and using mySQL version 4.1.7, and myODBC version 3.51.10. Everytime there is a power outage, my...

cjaouhar@hotmail.com

02-01-2007 06:28 AM
cjaouhar@hotmail.com

Dizzledorf wrote: I just tried entering NULL into an INT field a DECIMAL field and a FLOAT field and the contents were always NULL. You will most...

Paul Lautman

02-01-2007 03:17 AM
Martijn Tonies

Hello, I have a Database in UTF8. There is no utf8_greek_ci collation in my SQL installation. None of the existing collations seem to provide an...

Stuart Gall

01-31-2007 01:39 PM
Stuart Gall

How can you link two recordsets together so that the primary key used in one is from the other recordset. I need to have two repeat regions (one...

chris_huh

01-31-2007 01:38 PM
blaine@worldweb.com

Hello All, I need some advice on how to proceed. First off some background. I work as a Sales Engineer for a Software Company that has developed...

joseph.madi@gmail.com

01-31-2007 12:49 PM
Joe

Hi everybody, here is my problem. I have an entire column containing numeric data like "299.00". I have to suppress the ".00" at the end. As I have...

Mayoutze

01-31-2007 09:31 AM
Mayoutze

Hi, I was just wondering if anyone could recommend a tool which allows the user to create a new mysql database visually i.e. with an ERD -...

lukemack

01-31-2007 08:08 AM
lukemack

Hello, Are there any overhead in using MEDIUMTEXT over TEXT? seems can't find related info from the manual...

howa

01-31-2007 07:54 AM
howa

Hi gurus, here is a snippet of the procedure, don't know if mysql support labels as SQL Server and Oracle and i can't find more doc about...

lala4life

01-31-2007 07:45 AM
lala4life