Tables can be created, modified, and deleted using phpMyAdmin, a free web interface to your MySQL database. It provides you with an easy-to-use system for administration of your database without telnet access.

'('abc','d','ef@gh.ij','kl@mn.op')

 

Data retrieval can be done as follows:

 

select account, email_type, address from my_table_name where email_type = 'd' and destination like 'a%' order by account

 

MySQL supports several aggregate functions, i.e.:

 

select count(account) from my_table_name select avg(email_usage) from my_table_name

While the above commands can be entered using Domain Support's SQL Executer, you will typically want to execute them from within your Perl or C code.

Remember to "backslash" single quotes and backslashes before entering them into the MySQL command stream.