RE: help with insert +php

2006-09-02 Thread Dinçer Akay
Hi, Protect your database http://www.php.net/manual/en/function.htmlspecialchars.php PHP Security Consortium http://phpsec.org/ Protect SQL Injection Attack See more http://www.php.net/manual/en/function.mysql-real-escape-string.php ?php // Query

Re: Which AMD Dual Core Processor?

2006-09-02 Thread Larry Lowry
I use the 4400+. The 1meg cache makes a difference. Larry - Original Message - From: mos [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, September 01, 2006 11:29 AM Subject: Which AMD Dual Core Processor? I'm thinking of upgrading my AMD3500 to a dual core AMD

Is there a way to load non-native Date type with LOAD DATA

2006-09-02 Thread David Perron
I have a pretty large file with a Date column in the format M/D/. Is there a way to either change the Date data type in the table or a method to indicate the date format in the LOAD DATA statement in order to handle this? Thanks in advance for any help! David -- MySQL General Mailing

IN ANY subqueries

2006-09-02 Thread Ben Lachman
I have a string comparison that I would like to do against a short list of constant strings. at the moment I am using the syntax SELECT id FROM t1 WHERE name IN('s1', 's2', 's3', ...); However, this limits me to exact matches and I'd like to move to a caparison expersion that lets me match