Hello, I am in the process of creating a website which uses PHP/mySQL. I have root access to this server. What I need to do is to put a script in...

Tom Jermy

09-24-2004 02:35 PM
Aggro

Hi, I'm trying to do a MySQL Query using Mysql 3.23.58 something like that below SELECT name FROM customers WHERE name LIKE "Fred" ORDER...

John Harman

09-24-2004 12:57 PM
Edd Benson

I am *NOT* using local at all, just so you know. My webhosting server's stats: MySQL: 4.0.20-standard phpMyAdmin: 2.5.6 Apache: 1.3.31...

Del

09-24-2004 12:52 AM
Del

I am trying to using mysql as back-end for an application(web) running on the window 2X, one thing I am not sure is that once I establish...

Leon

09-23-2004 09:39 AM
Jeff North

When I run the query (please see below) between 08:30:00 and 17:29:59, I get the data from row 1; if I run the same query between 17:30:00...

Kevin

09-23-2004 08:27 AM
Leif

Hopefully someone can help me here. I have a personnel database with numerous tables, although only a few are required for this particular query. I...

Mark Hargreaves

09-22-2004 04:16 PM
Bill Karwin

Dear friend, I am Mrs.kate koroma wife to the late john koroma from Sierra Leon. I am writing you in absolute confidence prmarily to seek your...

mrskatekoroma@netscape.net

09-22-2004 03:59 PM
Bill Karwin

When I setup MySQL database (running scripts/mysql_setup_db) inititally the program create 3 big files: + ibdata1 (data file) 10...

Khue Pham

09-22-2004 03:26 PM
Khue Pham

Ok, I took a whack at this, but it's still not returning anything. Granted I used Dreamweaver to create the queries, but I must be messed up...

Don Seckler

09-22-2004 12:30 PM
Bill Karwin

I was getting started with Jumpline, and everything looked great, but then I started having problems with my web application. Turns out it was...

Todd_Calhoun

09-21-2004 07:18 PM
Todd_Calhoun

I'm on a hosted Linux server and I have an Outer Join query that's returning on one less row than I expect. There are two rows very similar and...

Ira

09-21-2004 05:27 PM
Ira

Hello, I have two tables "contact_tbl" and "address_tbl". I have a query that compares the email addresses between the two. If a match is found...

Frank Maestas

09-21-2004 04:23 PM
Chris Hope

I'm working on a project where we need to load several 10s of thousands of rows per second (roughly 50 bytes/row) into MySQL tables. We're using LOAD...

Dave

09-21-2004 04:02 PM
Dave

I would be interested to pay someone for their time to help me set up some simple Fields in a Table, fields such as name, address etc. I would...

ChrisJ

09-21-2004 02:33 PM
ChrisJ

Hello, I just installed version 4.0.21 on a Mandrake 8.2 system. I cannot get the MySql daemon to run. I am using the following commands,...

Jeremy Kohansimeh

09-21-2004 02:30 PM
Bill Karwin

Nick Truscott wrote: Echo your queries to screen and copy-paste them to mysql client. Then copy-paste the queries, error messages from MySQL and...

Aggro

09-21-2004 02:01 PM
Aggro

Please help with the following issue. I am trying to dump a table. My mysqldump command is: mysqldump.exe -u xx -P xx --add-drop-table --quick...

daniel kern

09-21-2004 01:15 PM
Heikki Tuuri

I think I have experienced this with 3 different computers. I'm not sure, but I think all of them were using Windows 98 and MySQL version 3.x. The...

Aggro

09-21-2004 10:09 AM
Aggro

Hi all, I want to store unique data about my page visit. This is done using cookie value. In my database, the page name and cookie value(ip address)...

Ben

09-21-2004 03:07 AM
Lucas

Direkt-Infos und Buchungen: Per Mail: info@anaforturizm=2Ecom www=2Eanaforturizm=2Ecom Anafor Turizm bietet Ihnen Preisg=FCnstige Kulturreisen,...

09-20-2004 08:22 PM

I get the following error screen when I try to install mysql on redhat: ----------------------------------------------------------------------- #...

Mark88

09-20-2004 08:05 PM
Mark88

FROM: THE DIRECTOR EUROPEAN PRIZE AWARD DEPT. REF:EL3/9318/04 BATCH:8/163/EL. Attn:Dear Sir/Madam We are pleased to inform you of the result of...

maculay clary

09-20-2004 09:35 AM
maculay clary

Not very good at this... A friend has asked me to do his restaurant menu. This has several sections - Starters, Main Courses, Vegetarian, etc, each...

Fat Bloke

09-20-2004 08:05 AM
Fat Bloke

I upgread mysql 3.23.56 to 4.0.21, succesfully upgraded. But, I observed abnormal behaviour of mysql (or may be i dont know). Thing is, in mysql...

Azhar H.

09-20-2004 07:54 AM
Azhar H.

Trying to get the following SQL to execute in MySQL 4.0... SELECT DISTINCT CategoryID, tblCategory.Category FROM tblCategory AS A INNER JOIN (SELECT...

Noozer

09-19-2004 02:09 PM
Bill Karwin

Hi there, I have developed several applications in Delphi. I used Paradox for my data storage. Now, I want to convert these databases to MySql. So...

Stefan van Roosmalen

09-18-2004 04:03 PM
Bill Karwin

ERROR: /tmp/edearl/mysql-4.0.21/mysql-test/var/run/master.pid was not created in 30 seconds; Aborting This error occurred just after MySQL was...

Ed Earl Ross

09-18-2004 10:49 AM
Ed Earl Ross

I have a database table that contains a set of numbers (set X). I need to be able to generate/export a random set of survey numbers (set C) from set...

Tony Stephens

09-18-2004 09:28 AM
Tony Stephens

Is it possible, and what are the ramifications, of having a single slave replicate from three masters? I have six machines, three real servers with...

Tam

09-18-2004 08:06 AM
Tam

running mysqld_safe --help to check the options for mysqld_safe, and instead of a warning or an error or hell no, "help". it deletes the mysql.sock...

Craig A. Falls

09-17-2004 05:00 PM
art

I want to use constraints, so I will have to use innodb tables (according to the website mysql.com). But, what is the difference between myisam and...

Stefan van Roosmalen

09-17-2004 09:35 AM
Stefan van Roosmalen

Just starting out with mySql / php ... hope this is a simple question and my description is understandable: I want to present table data from one...

braedsjaa

09-17-2004 07:42 AM
braedsjaa

Hi All, I'm building an embedded system and in need of bringing mySQL into my embedded controller. Here is what I need: + A minimal mySQL database...

Khue Pham

09-17-2004 07:42 AM
Khue Pham

I upgrade MySql from 2.23.56 to 4.0.21 (running on RedHat 9). MySQL server working fine but following warning appears whenever...

Azhar H.

09-17-2004 06:57 AM
Azhar H.

I'm using Mysql Max-4.1.4-gamma for Linux. I have a question related to a problem with my database server. If on my db server I have 2 different...

Andy

09-17-2004 04:26 AM
Heikki Tuuri

I am just starting out using mySQL. I created some databases and tables and installed mySQLcc to ease my usage. After about 4 months, I've needed...

Terry

09-16-2004 08:04 PM
Terry

Dear friends! I have decided to do my final Project in PHP and MySQL.Can Anybody plz tell me wether these Tools Will Support Distributed...

zia

09-16-2004 12:59 PM
Bill Karwin

I have two db's. One on a local server, one on a remote server. Both are running MySQL 4.0. The remote is a production server that I run mysqldump on...

Tony Fibannaci

09-16-2004 12:58 PM
Tony Fibannaci

Hi, I will be thankful if any of you can guide me to a software that I can use to make visual database design, something where I can make pictures of...

Jaunty Edward

09-16-2004 11:42 AM
Reply-to-group Thx

Hi, I am rolling back a transaction that (up to the rollback command) has inserted into two tables, both of which are type InnoDB. I am getting...

Andy Hall

09-16-2004 02:49 AM
Heikki Tuuri

Hey, Suppose you have a table_ex like: id nuber1 chr ( = a or b) 1 1000 a 2 1001 a 3 1002 b 4 ...

Quarco

09-15-2004 03:48 AM
Bill Karwin

ok here is the deal I am trying to get info using a couple of tables. This is an image database that has another table for comments. My goal is to...

Smeg Head

09-14-2004 10:11 PM
Smeg Head

Hi I have MyISAM tables When I'm deleting parent I want to delete children in the same time. How can I do It? What are possibilities? Thanks

saracen44

09-14-2004 04:14 PM
Bill Karwin

I'm inserting a record into MySQL 4.0 using Visual Basic ADO. When using the AddNew and Update method I am unable to retrieve the value of a Auto...

Ryan Hubbard

09-14-2004 12:16 PM
Aggro

Select d.* from ( select agent_addr, max(date_time) from eventlog where priority = 1 group by agent_addr) d, (select agent_addr, max(date_time) from...

Joshua Goodstein

09-14-2004 10:35 AM
Joshua Goodstein

Hi List, wouldn't it be possible to do a fast backup of the MySQL data in this way: 1.) rsync the MySQL data (with running mysqld) 2.) Stop...

Kurt Tragant

09-14-2004 06:36 AM
Kurt Tragant

Direkt-Infos und Buchungen: Per Mail: info@anaforturizm=2Ecom www=2Eanaforturizm=2Ecom Anafor Turizm bietet Ihnen Preisg=FCnstige Kulturreisen,...

09-13-2004 03:37 PM

Hi! Have a Blessed Day! Do you find you often tell yourself, “I need to make a change in my life” Is climbing the corporate ladder robbing you of...

Arnold Y.

09-13-2004 01:39 PM
Arnold Y.

Using mysql 4.1.3-beta-Max-log version. Table_type set as INNODB. Have a master to slave simple replication of a database. There is only one user...

Debbie

09-13-2004 09:02 AM
Debbie

Hello, I'm trying to create my first php app, and i want it to get it's data via a mysql database. In the app i've got a connection file that defines...

dave

09-13-2004 09:00 AM
Aggro