Mysql: Comments in Fields

April 9, 2008 by  
Filed under So Much Data

I never really noticed that you could create comments in your mySQL fields until now. My co-worker recently upgraded one of the web servers to have phpMyAdmin – 2.11.5.1, and the forms made the “comment” field more visible to me.

Below is a very basic table for “locations.” This simple table is for demonstration purposes only. ;)

Mysql table in PHPmyAdmin
Click on the image for a zoomed in view.
Read more

Related Products:

Modern Database Management (10th Edition)Modern Database Management (10th Edition)Provide the latest information in database development.

Focusing on what leading database practitioners say are the most important aspects to ... Read More >
MySQL Crash CourseMySQL Crash Course

MySQL is one of the most popular database management systems available, powering everything from Internet powerhouses to individual cor... Read More >

Databases DeMYSTiFieD, 2nd EditionDatabases DeMYSTiFieD, 2nd EditionLearning DATABASE fundamentals just got a whole lot EASIER!

Now you can design, build, and manage a fully functional database with ease. Tho... Read More >

Popularity: 10% [?]

How to Connect to a MySQL Database using PHP

March 29, 2005 by  
Filed under Code Snippets, PHP, Scripts and Coding

I was helping my coworker yesterday to create her first PHP-Database program. She already knew how phpMyAdmin worked, so I created a sample page for her to show how to connect to the database and then retrieve data from a query. Maybe this sample page could help you too. I commented as much of the code as I could. Let me know if you have any questions.

Read more

Related Products:

MySQL Administrator's Bible (Bible (Wiley))MySQL Administrator's Bible (Bible (Wiley))With special focus on the next major release of MySQL, this resource provides a solid framework for anyone new to MySQL or transitioning from another ... Read More >
Beginning Database Design Solutions (Wrox Programmer to Programmer)Beginning Database Design Solutions (Wrox Programmer to Programmer)This book is intended for IT professionals and students who want to learn how to design, analyze, and understand databases. The material will benefit ... Read More >
The Code Book: The Science of Secrecy from Ancient Egypt to Quantum CryptographyThe Code Book: The Science of Secrecy from Ancient Egypt to Quantum CryptographyIn his first book since the bestselling Fermat's Enigma, Simon Singh offers the first sweeping history of encryption, tracing its evolution and reveal... Read More >

Popularity: 26% [?]

Stop SOPA!

SOPA breaks our internet freedom!
Any site can be shut down whether or not we've done anything wrong.

Stop SOPA!