I have a quite standard graph represention of a social network : an auto-referential 'users' table (user_id , data...) and a 'relationship' join...

Josselin

01-16-2007 08:03 AM
Josselin

Hi, I am new to mysql, php and apache and I am looking for advise on the best way to install/configure all three and what server types to have. You...

tracy_woodham@hotmail.com

01-16-2007 05:00 AM
tracy_woodham@hotmail.com

Hello, I am looking for some suggestions. I need to come up with an automatic or simple backup software for my MySQL db. I have tried using...

CHaidvogel@gmail.com

01-15-2007 04:17 PM
Axel Schwenke

I'm trying to import a dump of the most interesting Wikipedia tables. Specifically page.sql (560MB), categorylinks.sql (584MB) and pagelinks.sql...

froggy000

01-15-2007 02:46 PM
Axel Schwenke

our max. connection has been set to 1000, for a very busy database, but we leave the black_log as its default value, is it a problem? any...

howa

01-15-2007 10:17 AM
howa

I am trying to store the result of an mysql query output in an array.. for testing purpose i wrote the following code: $conn =...

thecoolone

01-14-2007 02:09 PM
Paul Lautman

Dear all, I get an error #1093 when ever i attempt to execute an UPDATE Statement with the following scenario: CREATE DATABASE `college` DEFAULT...

coosa

01-14-2007 01:18 PM
Axel Schwenke

Hi, I want to implement a hit counter using SQL. I was going to just have one per day in the year. I would like it if there were an atomic...

Flarky

01-13-2007 01:36 PM
Dikkie Dik

What is the Select sintax to select only first record in a table ordering by CREATION_DATE? For example, the table is; ID_PLANT NAME ...

rokko4ever

01-12-2007 10:58 PM
Michael Austin

I have the following scenario. A mysql database running 3 databases. It is version 5.0.27 on Windows XP Prof.. All innodb databases. The one...

daniel@mfaconsulting.com

01-12-2007 10:54 PM
Jerry Stuckle

Hello, I had a pretty decent Google for this, so apologies if this has been answered many times before. I am trying to make a UDF to change...

pandpp

01-12-2007 02:44 PM
pandpp

some questions abt table locking (assume using myisam) 1. If a slow query is running on a table, is update/insert operations blocked? 2. If a slow...

howa

01-12-2007 12:30 PM
howa

Hi I am looking for a good a UK based (ideally southern england) MySQL consultant to review and advise on a data warehousing soultion our company is...

Chris

01-12-2007 05:19 AM
Chris

I'm running a phpbb board using MySQL/InnoDB - running w/ SELINUX on mysql Ver 14.7 Distrib 4.1.20 The board after a few hours will begin to...

starman7

01-11-2007 10:20 PM
starman7

Here is the situation: I have a web server pointing to a database on a different server. When a query is made from the web server to the database...

GregAgee@gmail.com

01-11-2007 08:10 PM
GregAgee@gmail.com

Hello, I had a pretty decent Google for this, so apologies if this has been answered many times before. I am trying to make a UDF to change...

pandpp

01-11-2007 07:13 PM
pandpp

hi, we are seeking a mysql professional with strong knowledge about the design and setup of mysql cluster. Good award and satisfaction. If you can...

Roberto Della Pasqua

01-11-2007 01:04 PM
Roberto Della Pasqua

Peter H. Coffin wrote: You went and told him and he specifically asked you not to! I mean he had gone to all the trouble of not reading it in the...

nino9stars@yahoo.com

01-10-2007 04:56 PM
nino9stars@yahoo.com

The problem I am struggling with is I have a database of batch jobs, very simple. JOBNAME,START TIME, FINISH TIME JOB1STOP;1/1/7 9:00:00;1/1/7...

Idgarad

01-10-2007 01:03 PM
Paul Lautman

Hi folks, I have a db which is similar to the example Name | Country | Type test | USA | Nm test2 | UK | Nb test3 | USA |...

UKuser

01-10-2007 11:55 AM
Bill Karwin

Need your help on starting 5.0.24 on a Solaris 9 system. Installed it from mysql-standard-5.0.24-solaris9-sparc-64bit.pkg, then ran...

Easy User

01-10-2007 11:44 AM
Easy User

This posting follows on from the thread of postings in the newsgroup started...

Jim

01-10-2007 11:28 AM
Jim

I have a column in a table that is configured for full text searching. I can search the DB with this: SELECT * FROM mydb.MyTable where MATCH...

Bruce

01-10-2007 09:13 AM
Bruce

Hello, I could not find out, how to get error code from SHOW ERRORS result set? I use stored procedure with mysql 5.0.27 standard. thank you for...

siara

01-10-2007 03:38 AM
siara

Hallo, ich hab ein Problem mit folgender Abfrage in Form von. SELECT ID, SUM(Anzahl) FROM ... WHERE... GROUP BY ID Folgendes Ergebnis wird...

nerodrom@googlemail.com

01-10-2007 03:14 AM
Paul Lautman

Here's the situation: I am running queries against a set of databases that all reside on different Linux nodes that are within different timezones...

darenbell@gmail.com

01-09-2007 10:03 AM
darenbell@gmail.com

Hello, Hoping to get some help on something that just makes no sense to me... Here's hoping someone can help! I have table setup with a data type...

nino9stars@yahoo.com

01-09-2007 07:58 AM
Jerry Stuckle

I downloaded Red Hat RPMs of MySQL 4.1.22 with the intention of running them on Red Hat 9, kernel 2.6. The downloded RPMs reside in my /home/me...

Fred

01-08-2007 04:42 PM
Fred

Where should the MySQL directory be? I don't see one.

Fred

01-08-2007 04:41 PM
Fred

Hello All... I'm having a problem with Mysql 5.0.18 running on a Sparc / Sun Solaris 8. The server is a Enterprise 4500 with 14 processors and 14GB...

David Waizer

01-08-2007 03:22 PM
David Waizer

I'm sorry for the multi-post, but I originally checked with the folks in alt.php.sql newsgroup before coming here. I'm having a problem with MySQL,...

Mike

01-06-2007 08:30 PM
Gordon Burditt

currently we store user/pass in a plain php file, but we want to have a better method to protect the MySQL login authentication by hiding the real...

howa

01-06-2007 08:15 PM
Gordon Burditt

Hello! I have got a tabale with dates: 2006-12-01 2007-01-12 2006-12-31 2008-01-05 2006-12-08 I want to display ALL dates, but sort this way, that...

krzys

01-06-2007 04:51 PM
Michael Austin

Hi I have a problem with mysql for anyone that can help. I have about 10,000 very simple inserts per day and probably a few thousand queries every...

dalouis

01-06-2007 04:49 AM
Brian Wakem

We have an app that, for certain legacy reasons, does not use AUTO_INCREMENT feature. We have a table with id column that is supposed to be...

Ignoramus12411

01-05-2007 05:15 PM
Ignoramus30651

Hi My actual situation is rather complex, so I'll try to reduce it to its component parts. If I execute a select along the lines of select * from...

LittleRob

01-05-2007 04:19 PM
LittleRob

Hello, I Try to connect in cold fusion an database MySQL. schema : test user : test pswd : test1234 One table : agent

Dede

01-05-2007 12:22 AM
Jonathan Roberts

How may databases are allowed to host in a given MySQL server? e.g. 4 or 5 Will performance suffer If I install too many DB in a single...

howa

01-04-2007 10:43 PM
Gordon Burditt

i want to deleta a row say DELETE FROM myrow WHERE id=234 ; but i want to know the details of the deleted row without using any second statement !!...

piyush

01-04-2007 11:08 AM
piyush

Hey guys! I'm just coding a little forum application and have some trouble with my "thread-overview" page. I want to list a table with the following...

pillepop2003@yahoo.de

01-04-2007 10:59 AM
Captain Paralytic

plz tell which website to download mysql5.0.27 source file for redhat9.0 with free download ..... and php5 for redhat 9.0..... can u help me this...

yogesh

01-04-2007 08:35 AM
Hans Poppe

Hi, I have to select elements that are not older than 2 months (=60 days). The table has a standard DATE column with format (YYYY-MM-DD),...

b.coolsaet@gmail.com

01-04-2007 05:02 AM
Captain Paralytic

I got this file from another web host. It has some syntax that I have not seen before. Importing it gererates an error. ERROR 1064 at line 2: You...

ivan at sustainablemarketing [dot] com

01-04-2007 04:27 AM
Sean

This is greatly simplified, but I have a database that contains the following fields and sample data: First,Last,Address,Gender,Age John,Doe,123...

dandiebolt@gmail.com

01-03-2007 09:38 PM
Michael Austin

Hi, I have a MacBook Pro running OS X 10.4 I have apache 2.2 and am running the most current version of mySQL. I cannot get DBD::mysql to install. ...

akvallejos@gmail.com

01-03-2007 12:29 PM
akvallejos@gmail.com

can u tell me how to include the mysql file ,mysql is installed but the mysql folders and header file is not present in the /var/lib/mysql ...

yogesh

01-03-2007 07:25 AM
yogesh

I have a pretty large table -- about 2 million records -- that so contains latitude and longitude points as separate columns. I'm interested in...

Ryan H

01-03-2007 12:37 AM
Ryan H

Hi All, I was running MySQL 5.0.15-community-nt over WinXP/SP2. My instance of MySQL 5.0.15 got corrupted recently: it no longer accepted my root...

Richard

01-02-2007 11:32 PM
Richard

Hi All, I've been running WinXP-Pro/SP2 with MySQL 5.0.15-nt for at least six months. I'm running under an Administrator account on my own...

Richard

01-02-2007 10:02 PM
Richard

Hello group & happy New Year, I have a two-line script that's failing with error 1064: CREATE USER 'LinqUser'@'%'; SET PASSWORD FOR 'LinqUser'@'%' =...

gmoudry@gmail.com

01-02-2007 04:03 PM
gmoudry@gmail.com