How to execute the notepad data in sql as a table

[prabhakarld]

Hi

This is my first query in sql .......


I have a data like

Email id
[e-mail]
[e-mail]
[e-mail]
[e-mail]
.
.
.
upto 80,000



So i want to create a table in sql and to display the this data in sql and how to export this data after modification to excel or notepad any of them in word processors or spreadsheet

Pls help me any one of this query....
Regards,
Prabhakar Reddy

[mwasif]

Create a sample table emails with a single UNIQUE column i.e. email (this will contain email address). SQL will be

CREATE TABLE `emails` (
  `email` varchar(255) NOT NULL default '',
  UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM;

Use file() to read the data from text file.

[PHP]
// code to create database connection will go here
$emails = file('path/to/text/file');

foreach ( $emails as $email )
{
if( trim($email) == "" ) continue;
mysql_query("INSERT IGNORE INTO email('$email')");
}[/PHP]

I have made the email column in DB as UNIQUE and used INSERT IGNORE to avoid inserting the same email twice.

To download the data as spread sheet/csv/excel check this small article. BTW, you can open this text file in excel or any wordprocess and Save As in your required format.

Post back if you need to know more.

Note: I have not tested this code, but I hope this will work for you.

[mwasif]

Or simply use this MySQL command

LOAD DATA INFILE 'path/to/text/file'
IGNORE INTO TABLE emails;