Form Processor with no SPAM from robots.
Anti-spam, anti-robot, anti-flame, Guestbook for your website.
Manage Remote websites from your website. Allow clients to update sections of their own web pages.
Quick MySQL 1.1
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Overview
Quick MySQL combines the speed of a number of useful preset functions with the ability to completley control your stored data via direct execution/query of your own SQL statements. There is nothing limiting about this program, after 15 minutes of using it you'll wonder how you ever managed without it!
WARNING: This program is oriented to professional webmasters and programmers with experience in SQL syntax and statements. As such, this is a very powerful program. Misuse of this program can result in the deletion of an entire database with very little or no warning.
Prior to using this program, we strongly suggest you familiarize yourself with its protocol and safe usage methods. Perl Services is not liable for any loss of data or cost to you due to misuse us this program. Note that there is nothing in this program that will cause any deletion of data unless such a command is initiated by you the user. Your use of this program implies acceptance of our usage policies and warnings.
To Top
Requirements
Here are the requirements to run Quick MySQL:
To Top
Please read the Perl Services Licensing Agreement
By downloading, purchasing, acquiring and/or implementing any PerlServices software, you agree to be bound by the terms and conditions of the distribution policy.
To Top
How to install the program
Installation is fast and easy. First you must make sure the path to Perl is correct at the top of the script (as with all other CGI programs written in Perl). Now, FTP the program onto your server in ASCII format. CHMOD 755.
That's it. The program is installed and ready to run. When you first call the script, you will be presented with the login page:
Simply enter the Hostname, Database Name, Username and Password for the Database and click the connect button. If the connection is successful then you will be presented with the main program screen ( shown on the Index page ). You may also choose to have the login details remembered for this database by checking the box that is labeled "Remember Password". The details are stored in a persistent cookie. We do not set or use any other cookies in this program! You can easily delete the cookie by unchecking the box labeled "Remember Password". Login details are only stored if the connection was successful. Each database's login details are then added to the "Drop down menu" where if selected, will immediately populate the remaining fields for you.
If your database is running as "localhost", then put "localhost" in the Hostname field.
WARNING: It is recommended that you run this program on a secure server. We always run our copy of it on a secure server only. Why? Do you want someone port sniffing your transmission when your sending out the access information for your database?
If you do install this on a secure server, there is one more step you must take. Because some secure servers resolve the server name differently from what you are entering in your browser, you must manually set the URL to the script. In the script around line 55 you will see the variable "$ScriptURL". Set this variable to the absolute URL to the program. Don't forget the "https://" !!
To Top
What are the Quick Table Functions?
There are six Quick Table functions that you can perform on any table in the working database. The working database is the database you are currently signed into. To access these Quick Table functions, select a table name from the list, select a function by clicking on it's radio button and finally click on the "Execute" button. The page will refresh with the results. The results will be displayed in the recovery area.
The Quick Table Functions available are:
NOTE: Any time you drop a table or add a table or transfer a table, you may need to click on the "Refresh" button to make sure the list of tables is up to date. It's not a bug, it was written that way.
To Top
What are the Quick DB Functions?
There are seven Quick DB Functions that you can perform. These Quick DB Functions will be performed on the current database that you are logged into. These functions are:
To Top
What are the Quick Table Transfer Functions?
There are three Quick Table Transfer Functions that you can perform on any table in the database. Note that you can only perform the Quick Table Transfer functions on one table at a time.
The first thing you have to do is select a table from the current working database. The current working database tables can be found in the drop down list labeled "From Table". This list is identical to the list under Quick Table Functions. Just remember the table must be selected from the list under Quick Table Transfer.
If you have chosen to "Remember Login" details, you will be able to quickly populate the reamining fields by selecting a Database to transfer to.
When you are rebuilding a table on a remote server or are rebuilding and transferring data to a remote server, you can re-name that table to any legal name you want. Note, if you attempt to Rebuild on remote or Rebuild and transfer to remote, that table name can NOT be on the remote server. If it is already on the remote server, the function will fail. If you wish to take a table on your current working server and copy it to the same database on the same server (in case you want to test some new code without affecting the live data), you can simply specify the current working server as the remote server by filling in the appropriate information.
The Quick Table Transfer Functions that you can perform are:
To Top
What is a Quick Query (Manual)?
The is the most versatile feature of the program and the most dangerous. In the Quick Query form field, simply enter a properly formatted and syntactically correct SQL statement. When you click the "Quick Manual Query" button, the program will take that SQL statement and process it. There are no warnings, no checks and no cautions. Whatever you enter, will be processed immediately.
You will see the "SQL Samples" drop down list. This list contains several common SQL statements in a generic form. If your not sure about the syntax of a statement, click on the selected operation from the list and a sample of that code will appear in the text entry area.
This program will by default, read everything in that text area as a single SQL statement. You can, however, submit multiple SQL statements and have them all processed. If you want to submit multiple SQL statements, you MUST click the checkbox labeled "Multiple Statements".
I will reiterate here, this is a powerful program. The program will not, however, do anything on it's own. It will only do what YOU tell it to. Therefore, if after processing a function/query you realize that you have irreversibly lost or altered data, it is your OWN fault. There program will only do what YOU tell it to do.
To Top
What SQL syntax is supported?
All standard SQL syntax is supported.
To Top
What is the recovery area?
The recovery area is where you see the results. Everything you process will return a result or query specific data. This returned data will always display in the "Recovery Area".
To Top
Does this program work on mSql?
No. However, we will soon be releasing a version of the program for the mSql database server. Join the Perl Services Mailing List for news and updates including information on new programs and upgrades to programs. Note that your e-mail address will NOT be sold to anyone, we take our clients and friends privacy very importantly.
To Top
Will this program work with the DBI API?
No. However, we will soon be releasing a version of this program that works with the DBI API. Join the Perl Services Mailing List for news and updates including information on new programs and upgrades to programs. Note that your e-mail address will NOT be sold to anyone, we take our clients and friends privacy very importantly.
To Top
MySQL Tips
Quick MySQL combines the speed of a number of useful preset functions with the ability to completley control your stored data via direct execution/query of your own SQL statements. There is nothing limiting about this program, after 15 minutes of using it you'll wonder how you ever managed without it!
WARNING: This program is oriented to professional webmasters and programmers with experience in SQL syntax and statements. As such, this is a very powerful program. Misuse of this program can result in the deletion of an entire database with very little or no warning.
Prior to using this program, we strongly suggest you familiarize yourself with its protocol and safe usage methods. Perl Services is not liable for any loss of data or cost to you due to misuse us this program. Note that there is nothing in this program that will cause any deletion of data unless such a command is initiated by you the user. Your use of this program implies acceptance of our usage policies and warnings.
To Top
Requirements
Here are the requirements to run Quick MySQL:
- UNIX web server
- Perl4 or higher
- MySQL database server (any release above 2.0 should be fine).
- Mysql.pm module must be installed on the server with it's supporting module Statement.pm. These can be downloaded in the Mysql.pm distribution from CPAN at http://www.cpan.org/.
To Top
Please read the Perl Services Licensing Agreement
By downloading, purchasing, acquiring and/or implementing any PerlServices software, you agree to be bound by the terms and conditions of the distribution policy.
To Top
How to install the program
Installation is fast and easy. First you must make sure the path to Perl is correct at the top of the script (as with all other CGI programs written in Perl). Now, FTP the program onto your server in ASCII format. CHMOD 755.
That's it. The program is installed and ready to run. When you first call the script, you will be presented with the login page:
Simply enter the Hostname, Database Name, Username and Password for the Database and click the connect button. If the connection is successful then you will be presented with the main program screen ( shown on the Index page ). You may also choose to have the login details remembered for this database by checking the box that is labeled "Remember Password". The details are stored in a persistent cookie. We do not set or use any other cookies in this program! You can easily delete the cookie by unchecking the box labeled "Remember Password". Login details are only stored if the connection was successful. Each database's login details are then added to the "Drop down menu" where if selected, will immediately populate the remaining fields for you.
If your database is running as "localhost", then put "localhost" in the Hostname field.
WARNING: It is recommended that you run this program on a secure server. We always run our copy of it on a secure server only. Why? Do you want someone port sniffing your transmission when your sending out the access information for your database?
If you do install this on a secure server, there is one more step you must take. Because some secure servers resolve the server name differently from what you are entering in your browser, you must manually set the URL to the script. In the script around line 55 you will see the variable "$ScriptURL". Set this variable to the absolute URL to the program. Don't forget the "https://" !!
To Top
What are the Quick Table Functions?
There are six Quick Table functions that you can perform on any table in the working database. The working database is the database you are currently signed into. To access these Quick Table functions, select a table name from the list, select a function by clicking on it's radio button and finally click on the "Execute" button. The page will refresh with the results. The results will be displayed in the recovery area.
The Quick Table Functions available are:
- Empty: This will remove all records from the table without altering or dropping the table. This is permanent and irreversible. This Quick Table function is equivalent to:
"DELETE FROM tablename"
- Drop: This will remove all records from the table and drop the table from the database. This is permanent and irreversible. This Quick Table function is equivalent to:
"DROP TABLE tablename"
- Show Contents: This will show the entire contents of the table. I had to choose a format that would be suitable for most people and that would be most useful. Therefore, the contents of the table are displayed in the form of an SQL insert statement (we will customize this output for US$75.00). If necessary, you can cut and paste the resulting lines into a program of your own for execution. They are pre formatted and ready to go.
- Show Definitions: This will show the definitions for each column in that table that were defined when the table was created and will include any definitions if the table has been altered/modified since creation.
- Re-Build Statement: This will return an SQL Create statement so that you can easily store (the definitions) or rebuild the table somewhere else.
- Count Records: This will return an integer representing how many records there are in the table. Remember, each row in the table is a record.
NOTE: Any time you drop a table or add a table or transfer a table, you may need to click on the "Refresh" button to make sure the list of tables is up to date. It's not a bug, it was written that way.
To Top
What are the Quick DB Functions?
There are seven Quick DB Functions that you can perform. These Quick DB Functions will be performed on the current database that you are logged into. These functions are:
- Show All Definitions: This will show the definitions for each column of every table in the database. The definitions will be the ones that were established when the table was created and will include any definitions if the table has been altered/modified since creation.
- Show All Contents: This will show the entire contents of the database. I had to choose a format that would be suitable for most people and that would be most useful. Therefore, the contents of the table are displayed in the form of an SQL insert statement (we will customize this output for US$75.00). If necessary, you can cut and paste the resulting lines into a program of your own for execution. They are pre formatted and ready to go.
- Rebuild All: This will return an SQL Create statement for every table in the database so that you can easily store or rebuild the tables somewhere else.
- Count All Records: This will return a series of integers representing how many records there are in each table of the database. Remember, each row in the table is a record.
- Server Variables & Server Status: These return specialized information about the database server that will only be of interest if you are administering the database server.
- New Connection: Any time you want to get out of the current working database and connect to a new one, click the "New Connection" button. You will be taken back to the main entry screen and the current database pseudo-connection will be destroyed.
To Top
What are the Quick Table Transfer Functions?
There are three Quick Table Transfer Functions that you can perform on any table in the database. Note that you can only perform the Quick Table Transfer functions on one table at a time.
The first thing you have to do is select a table from the current working database. The current working database tables can be found in the drop down list labeled "From Table". This list is identical to the list under Quick Table Functions. Just remember the table must be selected from the list under Quick Table Transfer.
If you have chosen to "Remember Login" details, you will be able to quickly populate the reamining fields by selecting a Database to transfer to.
When you are rebuilding a table on a remote server or are rebuilding and transferring data to a remote server, you can re-name that table to any legal name you want. Note, if you attempt to Rebuild on remote or Rebuild and transfer to remote, that table name can NOT be on the remote server. If it is already on the remote server, the function will fail. If you wish to take a table on your current working server and copy it to the same database on the same server (in case you want to test some new code without affecting the live data), you can simply specify the current working server as the remote server by filling in the appropriate information.
The Quick Table Transfer Functions that you can perform are:
- Rebuild on remote: This will look at the "From Table" selected, extract it's definitions and then rebuild it on the remote server. It is recommended that you immediately check this tables definitions on the remote server.
NOTE: Due to vagaries in definitions and different versions of MySQL servers, I can not account for every single definition. Therefore, it is recommended that you perform a Quick Table Query for a Re-build statement and check it's veracity. If the rebuild statement is correct, then you may proceed with the Quick Table Transfer function that rebuilds the table on a remote server.
- Rebuild & Transfer to remote: This is identical to the above function except that it also transfers the contents of the table to the remote server as well. If it is a large table, then this transfer may be affected by bandwidth, how busy communications channels are, server load, etc. Therefore, after you have performed this function, immediately check the table on the remote server to ensure that all data was transferred to it.
- Replace on remote: This function assumes the selected "From Table" has a duplicate on the remote server. That is, a table with the same name and same definitions. The function does two things. First, it erases the data from the table on the remote server and THEN it transfers the data from the current working database to the table on the remote server. If it is a large table, then this transfer may be affected by bandwidth, how busy communications channels are, server load, etc. Therefore, after you have performed this function, immediately check the table on the remote server to ensure that all data was transferred to it.
If the table does not exist on the remote server, prior to executing the "Rebuild on remote" or "Rebuild and transfer to remote" the function will fail.
If the table on the remote server does not have the same definitions, then you will likely only have a portion of the data transferred.
To Top
What is a Quick Query (Manual)?
The is the most versatile feature of the program and the most dangerous. In the Quick Query form field, simply enter a properly formatted and syntactically correct SQL statement. When you click the "Quick Manual Query" button, the program will take that SQL statement and process it. There are no warnings, no checks and no cautions. Whatever you enter, will be processed immediately.
You will see the "SQL Samples" drop down list. This list contains several common SQL statements in a generic form. If your not sure about the syntax of a statement, click on the selected operation from the list and a sample of that code will appear in the text entry area.
This program will by default, read everything in that text area as a single SQL statement. You can, however, submit multiple SQL statements and have them all processed. If you want to submit multiple SQL statements, you MUST click the checkbox labeled "Multiple Statements".
I will reiterate here, this is a powerful program. The program will not, however, do anything on it's own. It will only do what YOU tell it to. Therefore, if after processing a function/query you realize that you have irreversibly lost or altered data, it is your OWN fault. There program will only do what YOU tell it to do.
To Top
What SQL syntax is supported?
All standard SQL syntax is supported.
To Top
What is the recovery area?
The recovery area is where you see the results. Everything you process will return a result or query specific data. This returned data will always display in the "Recovery Area".
To Top
Does this program work on mSql?
No. However, we will soon be releasing a version of the program for the mSql database server. Join the Perl Services Mailing List for news and updates including information on new programs and upgrades to programs. Note that your e-mail address will NOT be sold to anyone, we take our clients and friends privacy very importantly.
To Top
Will this program work with the DBI API?
No. However, we will soon be releasing a version of this program that works with the DBI API. Join the Perl Services Mailing List for news and updates including information on new programs and upgrades to programs. Note that your e-mail address will NOT be sold to anyone, we take our clients and friends privacy very importantly.
To Top
| • Comparison operators | |
| = | Equals |
| < | Less than |
| <= | Less than or equal to |
| > | Greater than |
| >= | Greater than or equal to |
| <> | Not equal to |
| != | Not equal to |
| LIKE | Compare strings |
| • Mathematical operators | |
| ( ) | Use parentheses to force precedence |
| + | add |
| - | subtract |
| * | multiply |
| / | divide |
| % | modulo |
| • Conditional operators | |
| || | Logical "or" |
| | | Bitwise "or" |
| OR | Same as Logical "or" |
| && | Logical "and" |
| & | Bitwise "and" |
| AND | Same as Logical "and" |
| • Some Common Functions | |
| CONCAT(str1,str2) | Concatenates strings |
| DAYNAME(date) | Returns the dayname for the given date |
| LAST_INSERT_ID( ) | Returns the last record ID inserted |
| LENGTH(column) | Returns the length of a string in characters |
| TRUNCATE(n,n) | Returns stated number of decimal places |
| UNIX_TIMESTAMP( ) | Returns the epoch |
| • Some Aggregate Functions | |
| AVG(column) | Average number from returned results |
| MAX(column) | Returns the largest number from returned results |
| MIN(column) | Returns the smallest number from returned results |
| SUM(column) | Returns the sum of all returned results |
Note : not all databases support all functions. There are over 100 SQL functions, that can be used alone or nested within one another. You really should buy a book for a complete reference.
To Top
Support Information
If you are unable to set-up this program or are uncomfortable setting up the program then please contact our support department.
We offer an installation service for a fee of US$40. Note that at this stage QuickMySQL will only run on a UNIX server. We plan to release a WINDOWS version for SQL Server 7.0 by October 1st.
If you do not receive a response from our support centre within 24 hours, contact us
To Top
