I am looking at moving some old database systems to MySQL and I am currently working on data loading using mysqlinport. I have an issue with dates...

Donald Campbell

08-18-2008 04:52 PM
Tim Streater

Is it possible to pick up information from a MySQL database using a macro in Excel? Don

Donald Campbell

08-16-2008 11:49 AM
Donald Campbell

I have a query where I'm attempting to pull data from 3 different tables using php and mysql. I had hoped to have a unique identifier to help ensure...

cov

11-16-2007 08:30 AM
cov

I have two select statements below, that I wish to combine into one SELECT cgttransactions.linkid, cgttransactions.userid, cgttransactions.myvarid,...

mantrid

11-12-2007 02:13 PM
Michael Austin

Here is a post that I put into comp.lang.php before finding this newsgroup. Sorry for the double posting. I came across this code: SELECT AnnoID,...

Shelly

11-11-2007 08:00 AM
Jerry Stuckle

I have a form with 8 fields, 4 of which are required and 4 are not. Usually if a field isn't required I would create a separate table for it rather...

Pasquale

09-06-2007 05:01 PM
Pasquale

Hi guys, Just wondering if anybody of you has used SQLYog? Can you please share your views on the tool? How good it the tool compared with...

tmahale@gmail.com

08-09-2007 03:01 AM
tmahale@gmail.com

Hi, I would much appreciate some help with a work project that is due very soon. I have used a cursor to return the required result from a db...

Simon Barnett

07-25-2007 07:40 PM
Simon Barnett

Hi, I've done this before so I don't see what I could doing wrong here. I'm running mysql 5x on freebsd. I'm using the default data directory of...

amygrant1701@gmail.com

07-25-2007 08:21 AM
lark

Hi, Can anyone show me how to do the following: From a table I would like to retrieve the following: company and websites. When I do a select on...

Patrick

07-23-2007 07:48 AM
Captain Paralytic

I am trying to populate a mysql table from the contents of a <SELECT> list using PHP. The list is populated from another list and from there all the...

jamie@greengoanna.com

07-14-2007 06:23 AM
jamie@greengoanna.com

I have a single table which I would like to search on a unique column varchar(15) that may have some nulls. Employee social club member no, some...

McMurphy

07-05-2007 08:50 AM
lark

Splitz General Marketing - Employee Search Seeking employed/unemployed persons for a part-time positon. Must be hard working and willing to learn....

Splitz GM

06-29-2007 09:03 PM
reenz spitalsky

I am trying to do a dump for a 2 gig table... I would like to dump the tables in portions so that it's a little easier to work with... Can somebody...

Monty Loree

06-28-2007 10:32 PM
lark

Hi, I have a large db app for handling orders etc. I would like to offer our customers the ability to track their orders via email. i.e. they...

David

06-25-2007 02:14 PM
lark

I need to insert a unique value into a (not auto-increment) column. I try insert into idtest (val) values ((select max(val) from idtest)+1); but I...

Rune Zedeler

06-22-2007 11:24 AM
Rune Zedeler

I'm working from <http://www.oracle.com/technology/pub/articles/haefel- oracle-ruby.html>, would like to adapt the SQL for MySQL, please. Yes,...

Thufir

06-20-2007 11:30 PM
Thufir

dear everyone, we installed a mysql vr standard-4.11.22a-pc on a machine with ubuntu breezy badger as os..after the installation we are trying to...

grace

06-13-2007 10:22 PM
grace

Hi, I'm using MySQL v5.0 and we currently have a database containing several tables with Full Text indexes. Some of these tables contain ~800,000...

Roger Felstree

06-09-2007 05:22 PM
Roger Felstree

Hey all, This is my first post to a newsgroup so forgive me if it's in the wrong place... I've setup a local backup server for my...

Jason Maur

05-21-2007 08:39 AM
lark

This may be a particularly dumb question, but I'm wrestling with it anyways. Is there a way, to discern a duplicate field among records in a table....

Ike

05-19-2007 11:08 AM
VeloMaster

Hi, I am facing problem while excuting a mysql query. My problem is as follows- I have two tables object_1 and object_2. The structure of object_1...

prathamesh.deshpande@gmail.com

05-14-2007 12:03 PM
strawberry

I imported 600,000 records from SQL Server 2005 to mySQL. I know they are in there -- I just can't see them! When I do a SELECT, it processes for a...

John Bailo

05-13-2007 11:44 AM
John Bailo

hi everyone! i am having a problem with mysqldump.i am running this script from the shell root@linuxserver:/usr/local/mysql#bin/mysqldump u...

grace

05-11-2007 08:23 PM
grace

I'm trying to create a query to find missing values in a table. Example table: <PRE> COL1 COL2 ---- ---- A 1 A 2 A 3 A 4 B ...

jimnl69@hotmail.com

05-07-2007 10:53 AM
jimnl69@hotmail.com

Hello, I've got a Nested Set structure in MySQL 4 here with - id - lft - rgt - parent_id - root_id I wrote some test scripts and i discovered that...

nanoman

04-30-2007 06:32 AM
strawberry

Hi, Tested on MySQL 4.1.20 and 5.0.33 with similar results. I don't understand why I cannot grant LOCK TABLES on a single table, while granting...

Serman D.

04-27-2007 01:27 AM
Serman D.

I have a table (tableA), with a data field (saved as a VARCHAR in YYYY-MM-DD). I have a second table, tableB, which has a field with an int field...

R. Vince

04-25-2007 05:57 AM
strawberry

Hello, I've been given the job of recovering a database. It's mysql, version unknown but i'd suspect probably 3 maybe 4 certainly not 5. Apparently...

Dave

04-23-2007 07:18 PM
Gordon Burditt

I have a table of score which are 1's and 0's. How would I go about writing a query to get the percentage of 1's against the toal number of...

Dave

04-20-2007 11:01 AM
Dave

To alter 1 column to a unique key, ALTER TABLE user MODIFY COLUMN id INT NOT NULL UNIQUE; But how to set combination of 2 columns as a unique...

James

04-19-2007 06:48 PM
Gordon Burditt

Is there a way to run a mysql dump from within another application? I would like to place a button in my application that runs the backup. Any...

Dave

04-19-2007 04:48 AM
Dave

Hi Folk How can I rewrite the following: SELECT `USR`.`ID` FROM `USR` LEFT JOIN `USR_STORE` ON `USR_STORE`.`ID` = `USR`.`ID` WHERE...

windandwaves

04-15-2007 04:22 PM
windandwaves

Can I get the master (or slaves) to automatically remove the binary logs once they are processed by all slaves? It says in the mysql manual : If you...

tech101@gmail.com

04-12-2007 08:07 PM
tech101@gmail.com

Hi, everyone. I am not sure if i am writing in the correct group. But somehow it relates to MySQL, i hope someone can help me. I am working on a...

wongwaichi@gmail.com

04-07-2007 07:11 AM
Priscilla

Hi all, I need to think of a complex way of searching data in a table and also create a scoring system and display results considering their...

mareeus@gmail.com

04-03-2007 08:40 AM
strawberry

I noticed that in phpMyAdmin there is a way to cleanup and compact tables that have had lots of deletes done to them. Can anyone tell me how to do...

clb

04-01-2007 05:49 PM
Gordon Burditt

Hello, I have a table with more than 1,000,000 rows. mysql> describe...

Antoni

03-30-2007 08:39 PM
Michael Austin

I tried using mysqlhotcopy to do backup copies of my databases, but it fails with error: "DBD::mysql::db do failed: Not unique table/alias:...

Antoni

03-29-2007 02:34 AM
Antoni

Hi there MYSQL is loading a non printable character at the end of each row, clearly its a newline or ENTER character.. I have tried dos2unix.exe, a...

Jack

03-28-2007 04:04 PM
Jonathan

I have a database with 3 tables, one for nominees, one for voters and one for votes. I used the following...

Dave

03-28-2007 08:26 AM
strawberry

Hello, I'm trying to make a daily database backup. When executing "mysqldump - uxxx -pxxx database > /home/backup/ddbb.sql -q &" the httpd...

Antoni

03-26-2007 03:01 AM
Antoni

Hi Folk I have a databse with a bunch of double entries in some fields. For example: field A: "that is the way to go that is the way to go "

windandwaves

03-25-2007 04:11 AM
strawberry

I'm trying to setup a way to find possible duplicate or near-duplicate records of contact people. I have a table of 50k records doing an inner join...

rgurganus@citidc.com

03-19-2007 02:29 AM
strawberry

Hi, The following prg keeps cpu usage as 79% always .When i kill/stop the prg,then cpu comes down. main() { //code for mysql...

kanna

03-12-2007 05:05 PM
Aggro

I have a *damaged* MyISAM stock_take_mst.frm in /var/lib/mysql/abc. And I would like to move it to /var/lib/mysql/test and experiment with it. Is...

Man-wai Chang

03-08-2007 08:09 PM
Gordon Burditt

Hi, One of my tables has over 1 million records. It is set up as... ID int(11) unsigned NOT NULL auto_increment, Company varchar(50) default...

Dave

03-07-2007 01:39 PM
Dave

I have two identical databases on two different servers and I need to add the data in tables from one server to the tables in the other server. Is...

Ralph Smith

02-27-2007 12:34 PM
Aggro

I set OPTION=3 in my connection string as recommended by...

Young

02-27-2007 01:02 AM
Young

Hello; I am running the Apache web server, MySQL v4, and PHP on an NT4 server. Apache runs great, but the auction software I am using (Web2035...

Charles Crume

02-25-2007 09:03 PM
Michael Austin