Re: WHERE IN performance

, even when the matching field is indexed. In my experience, large IN clauses are considered inadviseable in any RDBMS. In all my uses we have designed databases and queries to avoid this sort of situation, Oracle or MySQL. -bluejack -- MySQL General Mailing List For list archives: http

Re: Foreigner keys in MySQL?

functions found in some other database's interface, you may want to check the relevant parts of MySQL's documentation. MySQL is not the same as Oracle -- it is its own full-featured, powerful relational database system. -bluejack -- MySQL General Mailing List For list archives: http://lists.mysql.com

Is MySQL Relational? (was: Foreigner keys in MySQL?)

as opposed to some other fundamental type of database. So, what's your laundry list of things MySQL should do? --bluejack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problem with Mail::Sendmail

. In fact, your question has absolutely nothing to do with MySQL, and this is the wrong place to get an answer to your question. For problems with sendmail, I recommend: news://comp.mail.sendmail (http://groups.google.com/groups?hl=enlr=ie=UTF-8group=comp.mail.sendmail) -bluejack -- MySQL General

Re: Is MySQL Relational? (was: Foreigner keys in MySQL?)

the distinction between 'relational database' in common parlance and in theory is both important and interesting, MySQL is a relational database engine. But thanks for all the links. Great to have these resources. -bluejack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: How to define a required field in a table?

( null ); ERROR 1048: Column 'X' cannot be null test One other case: If there is a default value on the column, the default will be inserted instead of NULL. -bluejack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Auto increment sequence

sequence. -bluejack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Unusual date storage requirement

, but it seems to me the only other solution would be to actually roll your own date format using separate columns for year, month, and day-of-month. Then you could leave day of month NULL, where appropriate. -bluejack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Unusual date storage requirement

by clauses in the way one would expect? (ie., 00 precedes 01). The docs make it seem as though use of invalid dates results in undefined behavior. -bluejack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Unusual date storage requirement

under relaxed interpretation situations would make me very leary about using anything that is not clearly a valid date, and somewhat uncertain as to what mysql will do with the data under the hood. (all that and much more available at: http://www.mysql.com/doc/en/DATETIME.html) -bluejack -- MySQL

Re: How to use the C API? (_not_ C++)

at the very end of your link line (although note that it does, usually, depend on -lz, which should follow it). If this is unhelpful, please feel free to email me details pertinent to your full development environment, and perhaps we can delve further. -bluejack -- MySQL General Mailing List

Re: How to use the C API? (_not_ C++)

- it didn't work. If you're using PHP you want the Perl DBI stuff. The C API is for C apps. If you are compiling a C application and are having trouble linking, post your specific issues and I'll be glad to help. -bluejack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: mysql well suited for bibliographic data...

fields and subfields. Alternatively -- and perhaps someone has done this already -- you could devise a relational schema that expresses the data as expressed in your proprietary format such that your queries could *generate* legacy formats, but would not be based on them. --bluejack -- MySQL

Re: Mysql Performance Question

haven't already, I'd also recommend taking a quick survey of your most common queries, making sure there is no low-hanging fruit available in terms of tuning your queries/indices/etc. --bluejack, who knows very little about tuning the parameters. -- MySQL General Mailing List For list archives: http

Re: Strange results

. Unless you are actually doing numeric things with this token, you might want to store it as a string. -Bluejack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Security Question: dynamic urls.

escaping all single quotes that go into the database, do I need to care about special url sequences? -Bluejack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

clarifications on mysql_insert_id

There was a question last week about the behavior of this function, which is inconsistently (and inaccurately) documented in the manual. A little black box testing shows the following: 1) mysql_insert_id successfully retrieves the last auto_inserted id used by a connection. 2) multiple

Leaking Memory from mysql_real_query()

in mysql. Any idea what I might be doing wrong? --bluejack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: web interface...

on this on the internet -- and so much sample code -- it will make your head swim. Start with google. Proceed intelligently. -bluejack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]