re: foreign key not able to be made

S cardtypes(`id`); ALTER TABLE `facedefs` ADD constraint `fk_facedefs_cardtype` FOREIGN KEY(`cardtype_id`) REFERENCES cardtypes(`id`); - -- "Don't worry about people stealing an idea. If it's original, you will have to ram it down their throats." Howard Aiken James Black[EMAIL

re: would like more info on INSERT ... VALUES

I am looking for, as I want to see if sending 100 inserts at one time is faster than doing 100 inserts, one at a time. I expect it is, but I would like to get some numbers for my query. Thank you for any help. - -- "Love is mutual self-giving that ends in self-recovery." Fulton Sheen J

re: no MINUS operator in mysql 5?

elect nb.name from stats_names sn - -- "Love is mutual self-giving that ends in self-recovery." Fulton Sheen James Black[EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDg4QcikQgp

re: how am I missing this key

mutual self-giving that ends in self-recovery." Fulton Sheen James Black[EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDgdwkikQgpVn8xrARAky9AJ4lcBoVIsqkU2nBpca6fAZZsl5dvgCfR3H5 7ed5

re: impossible WHERE noticed question

--+--+-+ 1 row in set (0.01 sec) - -- "Love is mutual self-giving that ends in self-recovery." Fulton Sheen James Black[EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (MingW32) Comment: Using GnuPG with Thund

Re: possible bug in mysql 5.0.13

r the suggestion, but it led to an error of: Unknown column r.rid in on clause. Guess I will start working on creating a test db where I can demonstrate this bug, to make it easy to reproduce. - -- "Love is mutual self-giving that ends in self-recovery." Fulton Sheen James Black[

Re: possible bug in mysql 5.0.13

nue to break for me until it is fixed in the next version, hopefully. - -- "Love is mutual self-giving that ends in self-recovery." Fulton Sheen James Black[EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmai

Re: possible bug in mysql 5.0.13

INNER JOIN c ON A.x=c.y I will try it. Thank you. Would this be a bug, or just something that should be documented? - -- "Love is mutual self-giving that ends in self-recovery." Fulton Sheen James Black[EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (Min

re: possible bug in mysql 5.0.13

UL | 0 | | | card_type | char(2) | NO | | | | | dept | char(3) | NO | | | | | college | char(2) | NO | | | | | campus | char(1) | NO | || | | fullname | varchar(24) | NO | | | | | ip | varchar(40) | NO | PRI | || | alive | int(11) | NO | | 0 | | +---+-----+------+-+-+-

re: determing how loaded my mysql server is

d number in the processlist seems to increment by perhaps 5-10/second. Is there a way to monitor the server, without putting too much of a load on the mysql server, to see what is going on? Thanx. - -- "Love is mutual self-giving that ends in self-recovery." Fulton Sheen James Black[EM

re: could insert...select have problem with corrupt table

ny clarification. - -- "Love is mutual self-giving that ends in self-recovery." Fulton Sheen James Black[EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDF1JEikQgpVn8xrARAmaBAJ4jD

re: query hasn't worked properly since Mysql 5.0.6

sne.badge), p.fullname) AS fullname FROM nams.netids AS sne LEFT OUTER JOIN nams.prefs AS p ON(sne.badge=p.badge) WHERE sne.badge=c.badge) AS UserFullname, - -- "Love is mutual self-giving that ends in self-recovery." Fulton Sheen James Black[EMAIL PROTECTED] -BEGIN PGP SIGNAT

re: mysql 5.07 results incorrect, mysql 5.0.6 results correct

, i.label; - -- "Love is mutual self-giving that ends in self-recovery." Fulton Sheen James Black[EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFC1R8dikQgpVn8xrARAjsfAJ4hsAKn81s

re: how to add comments to an existing table

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 How would I add a comment to rows in an existing table, if I am not changing the row definition? This is for mysql 4.1 and 5.0. Thanx. - -- "Love is mutual self-giving that ends in self-recovery." Fulton Sheen James Black[EMAIL

re: is keys a restricted keyword

is mutual self-giving that ends in self-recovery." Fulton Sheen James Black[EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCqKXvikQgpVn8xrARAgLjAJ0aD8nDJu49TbD2xFAQPtoEgyXF3wCfXcRQ krN

Re: error 1418 when creating stored procedure using mysql 5.0.6

ND; - -- "Love is mutual self-giving that ends in self-recovery." Fulton Sheen James Black[EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCpJYGikQgpVn8xrARAlslAKCMf8ChA6s+png

re: error 1418 when creating stored procedure using mysql 5.0.6

it to work now. Thanx. - -- "Love is mutual self-giving that ends in self-recovery." Fulton Sheen James Black[EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.

re: solution found for my.cnf problem in mysql 5.0.6

ot; Fulton Sheen James Black[EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCpFlmikQgpVn8xrARAh9qAJ0ekN/cqiuFPRs2urLkU5e2ulbFlQCfQ5+r TJknK26B3tkDnFGa6hrlcXM= =oLsU -END PGP SIGNATURE-

re: file my.cnf is missing for Solaris 8, for mysql 5.0.6

. - -- "Love is mutual self-giving that ends in self-recovery." Fulton Sheen James Black[EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCpFVBikQgpVn8xrARAhJaAJ0YINBpRLhq3VZ+YFkCSHMr1arxUA

re: using OR seems faster than using IN

idx=? ... SELECT name, id FROM table WHERE idx IN(?,?,?) I am also using prepared statements, obviously, and looping through my function 100 times, to get a better idea as to speed, and using junit for the testing. - -- "Love is mutual self-giving that ends in self-recovery." Fulton S

re: using if in select statement

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 My boss and I were playing with using select statements, and we can actually execute subqueries as an option if the result is true or false. Is this expected behavior, or is it something that may be fixed in a revision, before I begin to depend on it

re: determing number of Tuesdays within a date range

4pm. Thanx for any help. - -- "Love is mutual self-giving that ends in self-recovery." Fulton Sheen James Black[EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.

re: getting hours from two datetime columns

hope this makes sense. I am thinking I am going to be doing this in my application. Thanx for any suggestions. - -- "Love is mutual self-giving that ends in self-recovery." Fulton Sheen James Black[EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (MingW32) Comm

re: Mysql 5.0.4 still broken for my stored procedures

: com.mysql.jdbc.DatabaseMetaData.getCallStmtParameterTypes, line 6963 I am curious if anyone else is having a failure like this. Thanx. - -- "Love is mutual self-giving that ends in self-recovery." Fulton Sheen James Black[EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (MingW32) Comment: Using

re: group by day of week and group by hour in day

self-recovery." Fulton Sheen James Black[EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCb6NkikQgpVn8xrARAhEpAJwK1Yp9gBn0bnfUJ07dbf2bVHpSiACfd8Wi HycjEYTbpk0NAPEtEgV5BpY= =3+gk --

re: mysql 5.0.4 for Solaris, as a tarball

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Is there somewhere where I can d/l the latest beta as a tarball? Thanx. - -- "Love is mutual self-giving that ends in self-recovery." Fulton Sheen James Black[EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (MingW3

re: Error 1130 when on local machine, but can connect remotely

nx for any suggestions. We are using Solaris 9, and mysql 4.1.xx - -- "Love is mutual self-giving that ends in self-recovery." Fulton Sheen James Black[EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (MingW32) Comment: Using GnuPG with Thunderbird - http:/

re: just dumping table definitions, not data

. - -- "Love is mutual self-giving that ends in self-recovery." Fulton Sheen James Black[EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCX9PWikQgpVn8xrARAvynAJ9B4ffkvm8HZ087LPgahWeBdv

re: calling a stored procedure from another stored procedure

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have a stored procedure called assignItem. I would like to call this from another stored procedure. Thanx. - -- "Love is mutual self-giving that ends in self-recovery." Fulton Sheen James Black[EMAIL PROTECTED] -BEGIN PGP

re: stored procedure error is misleading

---+ - -- "Love is mutual self-giving that ends in self-recovery." Fulton Sheen James Black[EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCVX3qikQgpVn8xrARAjUHAJ4xvgPiGge4

re: more on slow stored procedure performance

lt '', `dept` char(3) NOT NULL default '', `college` char(2) NOT NULL default '', `campus` char(1) NOT NULL default '', PRIMARY KEY (`xid`), KEY `start_ndx` (`start`), KEY `rank_ndx` (`card_type`), KEY `dept_ndx` (`dept`), KEY `college_ndx` (`co

re: stored procedure has very poor performance

is improved. - -- "Love is mutual self-giving that ends in self-recovery." Fulton Sheen James Black[EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.

re: any performance increase from using prepared statements

dynamically generated statement? Thanx. - -- "Love is mutual self-giving that ends in self-recovery." Fulton Sheen James Black[EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

re: stored procedure slower than not using stored procedure?

5.0.3 on Solaris 8. Thanx. - -- "Love is mutual self-giving that ends in self-recovery." Fulton Sheen James Black[EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org i

re: stored procedure calling another database

decisions. I am using mysql 5.0.3 if it matters. Thanx. - -- "Love is mutual self-giving that ends in self-recovery." Fulton Sheen James Black[EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.

re: copying a db for mysql 5.0.3

into the new database. When I tried to just copy I had complaints of not being able to find the tables .frm files, even though I see them in the data directory. Is there any way to get this to work, now? Thanx. - -- "Love is mutual self-giving that ends in self-recovery." Fulton Sh

re: problem with mysql-max-5.0.3 for Solaris 8 32 bit

from http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-max-5.0.3-beta-sun-solaris2.8-sparc.pkg.gz/from/http://mysql.mirrors.pair.com/ - -- "Love is mutual self-giving that ends in self-recovery." Fulton Sheen James Black[EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: Gn

re: using one query to save data in 4 tables

x27;s id in the insert statements. Thanx. - -- "Love is mutual self-giving that ends in self-recovery." Fulton Sheen James Black[EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.5 (MingW32) Comment: Using GnuPG with Thunderbird - http://enig

re: can 5.0.2 be built for Solaris 8

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have tried to compile mysql, and got some linking errors. Any chance a binary for Solaris 8 can be made available? Thanx. - -- "Love is mutual self-giving that ends in self-recovery." Fulton Sheen James Black[EMAIL PROTECTED]

Re: can a subquery be used in an insert

7;,(SELECT max(idx) FROM comments WHERE sourceid=1)) ~ The error is still: You can't specify target table 'comments' for update in FROM clause - -- "Love is mutual self-giving that ends in self-recovery." Fulton Sheen James Black[EMAIL PROTECTED] -BEGIN PGP SIGNATURE

Re: can a subquery be used in an insert

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Philippe Poelvoorde wrote: | James Black wrote: | |> -BEGIN PGP SIGNED MESSAGE- |> Hash: SHA1 |> |> I would like to set one column to point to the auto-incrementing index |> of the last comment in the database for my applic

re: can a subquery be used in an insert

You can't specify target table 'comments' for update in FROM clause. But, if I don't have 'From comments', then I get an error also. Thank you for any help. - -- "Love is mutual self-giving that ends in self-recovery." Fulton Sheen James Black[EMA

re: getting mysql5.0.2 for solaris 8

ve is mutual self-giving that ends in self-recovery." Fulton Sheen James Black[EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.5 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFB78CMikQgpVn8xrARAkFeAJ4vwqNqnzH1gQd2Iz/1bLnUUJ/1LACg