Articles
Do you provide phpMyAdmin web interface to manage the MySQL Database?
Yes, we provide that. You can login to DotNetPanel first Create MySQL Database, create MySQL...
Does mysql support foreign keys?The answer to this is two-fold. Yes. MySQL _DOES_ allow the creation of foreign key...
How can I select random rows from a table?SELECT * FROM table_name ORDER BY RAND(); Found at...
How do I delete a table from a database?Use this SQL command : "DROP TABLE yourtablename"
I'm new to MySQL, where should I start?The best source of MySQL information is the excellent on-line manual : ...
Select statement to join tables?For a simple join: SELECT a.*, b.*FROM tblAlpha a, tblBeta bWHERE (a.keyfield = b.foreignkey);...
What are the differences between GROUP BY and ORDER BY... The manual is not clear on thisGROUP BY is a way to sub-total your results, or perform some other "aggregate" function on them....
What does this error message means - Warning: Supplied argument is not a valid MySQL result resource and how do you solve it?I think you got this message from PHP. You get this message when you are trying to access...
