.
trying to figure out what I'm doing wrong:
chris.
Rahul S. Johari
Supervisor, Internet Administration
Informed Marketing Services Inc.
500 Federal Street, Suite 201
Troy NY 12180
Tel: (518) 687-6700 x154
Fax: (518) 687-6799
Email: [EMAIL PROTECTED]
http://www.informed-sources.com
--
MySQL
Ave,
You can use the attached SQL file to create a table with all Country names,
ISO codes, and easily write up a code to fill in the values from the table.
If you have any problems filing up the combo box with the values from the
table, let me know.
Dominor,
Rahul S. Johari
Coordinator
Hi,
I used the following SQL Query to determine Duplicate Records with same Name
Email in the row:
SELECT email,
COUNT(email) AS NumOccur1, name, COUNT(name) AS NumOccur2
FROM mytbl
GROUP BY name, email
HAVING ( COUNT(email) 1 ) AND ( COUNT(name) 1 )
I want to delete all the records which
, Shen139 [EMAIL PROTECTED] wrote:
ALTER IGNORE TABLE mytbl ADD UNIQUE KEY ( field1, field2,... ) ;
On 11/8/05, Rahul S. Johari [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] wrote:
Hi,
I used the following SQL Query to determine Duplicate Records with same Name
Email in the row:
SELECT email
That worked Perfect!!!
Thanks a ton!
On 11/8/05 11:27 AM, Shen139 [EMAIL PROTECTED] wrote:
ALTER IGNORE TABLE mytbl ADD UNIQUE KEY ( Name, email, sex, country ) ;
Rahul S. Johari
Coordinator, Internet Administration
Informed Marketing Services Inc.
251 River Street
Troy, NY 12180
Tel: (518
Ave,
I was wondering the same. Looks like hacked to me. Something's up.
Rahul S. Johari
Coordinator, Internet Administration
Informed Marketing Services Inc.
251 River Street
Troy, NY 12180
Tel: (518) 266-0909 x154
Fax: (518) 266-0909
Email: [EMAIL PROTECTED]
http://www.informed-sources.com
why.
Rahul S. Johari
Coordinator, Internet Administration
Informed Marketing Services Inc.
251 River Street
Troy, NY 12180
Tel: (518) 266-0909 x154
Fax: (518) 266-0909
Email: [EMAIL PROTECTED]
http://www.informed-sources.com
On 4/4/05 12:59 PM, Brent Baisley [EMAIL PROTECTED] wrote:
I've been