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
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
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 in both tables?
Heh, sorry about that. Try this:
select count(USER_TMP.email
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
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 database,
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 -
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