Re: WHERE IN performance

in an IN clause, 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 lis

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

o testnull values ( 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:

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

RDBMS is only hitting two or three more points, I think we all need to loosen our ties and agree that while 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 a

Re: Problem with Mail::Sendmail

mail module. 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=en&lr=&ie=UTF-8&group=comp.mail.sendmail)

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

and in that context, yes, MySQL is designed to a implement a relational database model 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: Foreigner keys in MySQL?

sql.com/doc/en/index.html). If you need particular relational 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. -blueja

Re: Unusual date storage requirement

warnings against using values that could be interpreted as times rather than dates or visa versa 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.

Re: Unusual date storage requirement

7;. For future reference, does this effect order 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

k you are looking for here, 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:

Re: Auto increment sequence

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

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

s a third party library, depending on nothing of your own manufacture, it should probably come 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

Re: mysql well suited for bibliographic data...

rsing routines for taking apart your 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

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

ried to include >it many times - 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 Mailin

Re: Strange results

defined behavior. 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]

Re: Mysql Performance Question

arameters, but if you 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 Maili

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 processe

Security Question: dynamic urls.

rds, if I am already 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]

Re: web interface...

ion 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]

Leaking Memory from mysql_real_query()

ry leak 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]