First export the tables from MS-Access into a text file and then use infile command to import that text file into MySQL.
Here is an example of infile command:
LOAD DATA INFILE ‘name_of_export ed_file.txt’
INTO TABLE table_name
FIELDS TERMINATED BY ‘,’
LINES TERMINATED BY ‘\r\n’;...
CodeMaster123
Last Activity: Feb 19 '08, 08:27 AM
Joined: Feb 18 '08
Location:
-
If you are using PHP as a server side scripting language use mail function of PHP to send an e-mail
...Code:[B]syntax:[/B] bool mail ( string to, string subject, string message [, string additional_headers [, string additional_parameters]] ) [B]example:[/B] <?php $body_of_mail = "Line 1\nLine 2\nLine 3"; $receivers_email_id="xyz@abc.com"; $subject="mail"; mail($body,
Leave a comment:
-
How to change password of user in MySQL
Is there any way to change the password which is assigned to user in MySQL -
Instead of storing videos in database you should store their URL in database and use them to access your video.
I don't know which scripting language you use so I can't give you a perfect solution.Leave a comment:
No activity results to display
Leave a comment: