Wednesday, April 24, 2013

About PHP / MySQL: Remove an entire table with: drop table

If you can't see this email, click here

About

PHP / MySQL

PHP Basics

MySQL Basics

Advanced Skills



From Angela Bradley, your Guide to PHP / MySQL
Hello Programmers!
Today we are covering how to edit a MySQL database, and in particular how to remove an entire table and all of its contents.
Have a great week!

Remove an entire table with: drop table
If you want to remove an entire table from your database you can do so using drop.  Be careful when doing this because you will preeminently lose all of the... Read more

Switch databases using the use command
If you are working with more than one database you can switch between them using the use command.  For example if you had a database called "Pandas" and a database... Read more

Use floor to always round down
The floor function is used to always round down.  For example:  2.1 and 2.9999999 would both round down to 2.  This is sometimes used because you can't have a fraction... Read more

Security for PHP and MySQL
When using PHP and MySQL it is important to program in a safe way to keep out hackers and risk losing sensitive information.

 


Related Searches
Featured Articles
PHP and MySQL Basics
Tools and Resources
Troubleshooting
Programing Glossary
Reader Response
Social Networking with PHP @ About.com

 

More from About.com

10 Easy Ways to Look Thinner
Don't wait until you've lost those first pounds to make these simple, slimming changes. Read more...>



Create a Shared Photo Stream
Sharing your photo stream with friends and family is a great way to keep in touch. Read more...>




This newsletter is written by:
Angela Bradley
PHP / MySQL Guide
Email Me | My Blog | My Forum
 
Sign up for more free newsletters on your favorite topics
You are receiving this newsletter because you subscribed to the About.com PHP / MySQL newsletter. If you wish to change your email address or unsubscribe, please click here.

About.com respects your privacy: Our Privacy Policy

Contact Information:
1500 Broadway, 6th Floor
New York, NY, 10036

© 2012 About.com
 


Must Reads
Learn PHP
Using PHP with MySQL
Learn MySQL
Create Email Forms
PHP Login Script
 
Follow me on:
Facebook Twitter

Advertisement

No comments:

Post a Comment