Where to store comments?

Other databases allow one to store comments describing each field in a table definition. These are stored in the database. In addition, one can store comments about the table. Examples include MS SQL Server and MS Access. Does MySQL have such a feature? Is there a GUI to support it? What perl

Prepare v. Do functions: how to benefit from prepare

I'm using activestate perl on WinXP but I'm sure this applies to all languages on all platforms. I cannot remember the JDBC terms presently. There have been lots of discussion on the performance virtues of using the prepare function instead of the do function. Is it necessary to save the

How to migrate from V4.0.23 to V5?

My questions are probably addressed in the MySQL documentation somewhere. I've been reading the documentation on backup but I'm not sure if that is the right tool for this situation. Perhaps there is a better place to be reading? Apparently my 4.0.23 database on my notebook is corrupted as one

how to design junction table?

I have 100K job posting records and 40K job title records. There is a M:M relationship here. I expect these tables to grow rapidly. What is the best way to design a junction or link table? Do I need to create a primary key? My thought was no primary key, just two indices on each foreign key

MySQL Control Center works with v4.0.23 -- how about V5?

[Siegfried Heintze] I love MySQL Control center. I can make it work for MySQL v4.0 but not the latest (v5). It simply does not connect to the V5 Mysql server I just installed. It seems to hang on the connection. Am I doing something wrong or does MySQL Control center not support 5? Assuming

RE: MySQL Control Center works with v4.0.23 -- how about V5?

, August 30, 2005 1:12 PM To: Siegfried Heintze Cc: mysql@lists.mysql.com Subject: Re: MySQL Control Center works with v4.0.23 -- how about V5? Siegfried Heintze [EMAIL PROTECTED] wrote on 08/30/2005 03:11:26 PM: [Siegfried Heintze] I love MySQL Control center. I can make it work for MySQL

RE: Where did my disk space go?

- Adelaide) [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 03, 2005 8:10 PM To: Siegfried Heintze; mysql@lists.mysql.com Subject: RE: Where did my disk space go? Hi Siegfried, I would check your transaction logs. Are you doing this as one giant transaction? The system may be filling up the logs just

RE: Where did my disk space go?

I did the following from the Cygwin bash prompt on WinXP Pro. cd /c/mysql find . -size -10M | xargs ls -l I only found one file greater than 10 megabytes. I'm looking for several hundred megabytes. Thanks, Siegfried -- MySQL General Mailing List For list archives:

How to delete log files? Was: RE: Where did my disk space go?

] Sent: Thursday, August 04, 2005 3:33 PM To: Siegfried Heintze Cc: mysql@lists.mysql.com Subject: RE: Where did my disk space go? Hi Siegfried, In the mysql data directory, -rw-rw1 mysqlmysql 358975 Mar 10 14:28 aaudbasa01.log -rw-rw1 mysqlmysql 25088 Feb 15 08

Where did my disk space go?

I've been using Perl 8.4+ (ActiveState) on WinXP. My program runs for many ( 20) hours issuing SQL UPDATE and DELETE commands. The update commands should not be increasing the storage requirements, I'm just updating integer values. I've noticed several times now that I run out of disk space. I

RE: Alternatives to performing join on normalized joins?

) my time. I believe this is the classical approach, however. Which would you choose? Thanks, Siegfried _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 25, 2005 9:31 AM To: Siegfried Heintze Cc: mysql@lists.mysql.com Subject: Re: Alternatives

How to select first 1000 records like MySQL Control Center 0.9?

Some dialects of SQL have SELECT [FIRST|TOP 1000] clause for their SELECT syntax. I looked at the syntax for mysql and it does not appear to have this feature. Apparently, however, this is possible because the MySQL Control Center does this. How does it do it? Thanks, Siegfried -- MySQL

Alternatives to performing join on normalized joins?

I have a large number of job titles (40K). Each job title has multiple keywords making a one-to-many parent-child relationship. If I join job title with company name, address, company url, company city, job name, job location, job url (etc...) I have a mighty wide result set that will be repeated

Documentation on Like clause

Could someone kindly point me to the documentation on the like clause. I found the documentation on the SELECT statement but could not find the discussion on the like clause. I search too -- but there were too many like's used outside of the SQL syntax. Thanks, Siegfried -- MySQL General

How to use Like Clause in Perl? Works fine in MySQL control center!

I'm having trouble getting the like clause to work. It seems to work fine in the MySQL Control Center 9.4.beta. I'm using MySQL 4.0.23-debug. use DBH; my $sth = DBH-prepare(SELECT 'David!' LIKE '%D%v%'); $sth-execute(); my $row; print join(@$row,,).\n while ($row = $sth-fetch); This does not

Tuning MySQL

Are there any tools for finding hot spots in one's database? My screen scraper is maxing out my CPU. I'm thinking I might need some secondary indexes in some of my tables. I have a lot of two column tables consisting of integer primary key and varchar in the second column. I repeatedly search the

Compatibility with ActiveState Perl 5.8.4+?

Approximately a half year ago I started to install bugzilla on windows which uses mysql and perl. After much grief, I discovered that there was a problem with windows perl and the latest version of mysql at the time. I finally solved the problem by rolling back to 4.0.23. It looks like there are

SQL Syntax Errors

671 Did not find any old versions with SELECT cJobTitle FROM jobtitlecount WHERE fkJobPosting = 209689 AND dtSnapShot = '2005-06-26', attempt to insert one: INSERT INTO jobtitlecount (fkJobPosting, dtSnapShot, cJobTitle) VALUES (209689,'2005-06-26',1) 671 Did not find any old versions with SELECT

(oops, corrections to that last email message) RE: SQL Syntax Errors

Sorry, I accidentally pasted some garbage at the beginning of that last email message. Here is what I intended: I first check to see if the record exists: SELECT cJobTitle FROM jobtitlecount WHERE fkJobPosting = 209689 AND dtSnapShot = '2005-06-26' When I don't find an entry, I try an insert:

Wanted: Help with 'ON DUPLICATE KEY' syntax

Thanks for deciphering that terrible message, Shawn. I accidentally must have hit the paste key too many times. Anyway, here is my new insert statement: INSERT INTO jobtitlecount (fkJobPosting, dtSnapShot, cJobTitle) VALUES (211584,'2005-06-26',2) ON DUPLICATE KEY UPDATE cJobTitle=2

How to call mysql_insert_id

A long time ago, I posted this query: If I use the auto-increment feature for a couple of normallized relations, how do I insert into them? Specifically, when I insert into a relation with the autoincrement feature on the primary key, how do I get the value of the index on the newly created

RE: How to call mysql_insert_id

, Siegfried Heintze [EMAIL PROTECTED] wrote: * In MySQL - mysql_insert_id() How do I call this function? I was hoping I could use SQL such as SELECT mysql_insert_id() FROM XYZ but I discovered that does not work. I'm using a mixture of java and perl. I see in my old documentation that PHP

Access deined for user 'root@sales'

I'm running v 4.0.22 on Win XP 2003 Server with a client running XP Pro. I have mysql running on 192.168.0.8 and I want to administer it from 192.168.0.202 (aka SALES). While on 192.168.0.8 running mysql, I issued the following commands: mysql GRANT ALL ON *.* TO 'root'@'192.168.0.22';