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

If you can't see this email, click here

PHP / MySQL 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 PHP and MySQL MySQL MySQL DB Tool Programming Tutorial MySQL Check Tables 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: Advertisement

About PHP / MySQL: Use floor to always round down

If you can't see this email, click here

PHP / MySQL PHP / MySQL PHP Basics MySQL Basics Advanced Skills From Angela Bradley, your Guide to PHP / MySQL Hello Programmers This week we look at another way to round. You can use floor to always round down. So no matter what comes after the decimal point, the number is always rounded down. Have a great week! 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 Use Ceil to always round up Ceil (short for Ceiling) is used to always round a number up.  So for example, 5.1 and 5.9 would both round up to the number 6 if you were using... Read more April Fools Day! All around the world web masters are playing tricks on their readers today.  Its a fun little tradition to play an April fools day joke online.  Did you do something... Read more Learn MySQL MySQL is a relational database and a powerful online tool for storing important information and delivering that information back to your website on demand. Here you can learn more about how to use MySQL. Related Searches PHP and MySQL MySQL Round Up Rounding Math Tutorial Sites Featured Articles Advanced PHP PHP with MySQL Graphics- GD Library Step By Steps PHP Functions MySQL Commands   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: Advertisement

About PHP / MySQL: Use Ceil to always round up

If you can't see this email, click here

PHP / MySQL PHP / MySQL PHP Basics MySQL Basics Advanced Skills From Angela Bradley, your Guide to PHP / MySQL Hello Programmers! This week we take a look at one way to round using PHP. The Ceil function is used to always round up. For example, if you needed a certain amount of sugar, and you could only order full bags not half or .74343 of a bag, you'd always need to round up to the amount of full bags to order. Have a great week! Use Ceil to always round up Ceil (short for Ceiling) is used to always round a number up.  So for example, 5.1 and 5.9 would both round up to the number 6 if you were using... Read more April Fools Day! All around the world web masters are playing tricks on their readers today.  Its a fun little tradition to play an April fools day joke online.  Did you do something... Read more What is a relational database? You've heard the term relational database used to describe MySQL, but you might not actually know what it means.  This article helps you visualize what it is using real world... Read more Tools and Resources Tools and Resources useful to people working with PHP or MySQL. Related Searches MySQL PHP PHP Scripts Ajax and PHP MySQL Tutorial Zend PHP Featured Articles Troubleshooting Programing Glossary Reader Response Social Networking with PHP @ About.com Learn PHP Learn MySQL   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: Advertisement