Unknow column 'USER' in 'where clause'.
--- Rodney Broom <[EMAIL PROTECTED]> wrote:
> From: Anthony E. <[EMAIL PROTECTED]>
>
>
> > This comes up with more records than are in
> USER_TMP.
>
> Is the 'email' column unique i
I've tried to do a NOT IN statement, but still am
getting SQL syntax error.
SELECT COUNT(*) FROM USER_TMP WHERE USER_TMP.email NOT
IN (SELECT USER.email FROM USER);
I'm trying to produce a list of records from USER_TMP
table where the USER_TMP.email is NOT IN USER.email.
(in other words, i wan
i have two tables with similar structure...
i want to find the intersection of data between two
tables that have the same email address.
I tried the following with an error (Unknown table
'USER' in where clause) the USER table is definitely
there though:
select count(email) from USER_TMP wher
I have a tabdelimited file with 10 cols, and want to
only import 5 of them with LOAD DATA INFILE.
I know how to define which cols go where in the mysql
table, but this assumes i want to import every column
from the tabdelimited file.
How do I ignore certain cols from the import file?
ie - tab.t
I have a tab delimited file from a spreadsheet that
has a field "Name" (includes first and last name).
I am importing the file into a table that has
"firstName" and "lastName" as seperate fields.
Is there a way to split the field from the text file
"Name" into two different fields in the databas
okay, I'm having problems here, probably something
very simple I'm overlooking:
./configure --prefix=/usr/local/mysql
--prefix=/usr/local \
--localstatedir=/usr/local/mysql/data
make
make install
mkdir /usr/local/mysql/data
mkdir /usr/local/mysql/tmp
cd /usr/local/mysql/bin/
mysql_install_db
/u
I need to read the fields of a table dynamically using
DBI.pm
The resulting cgi script should be a form that has a
checkbox for each field...the user will then create a
temporary table based on which fields are checked in
the form.
=
--
Anthony Ettinger
[EMAIL PROTECTED]
415-504-8048
http:
