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:

Beginning Database Design: From Novice to ProfessionalBeginning Database Design: From Novice to Professional

Beginning Database Design: From Novice to Professional provides short, easy-to-read explanations of how to get database design right the first time... 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 >
Beginning Database Design: From Novice to ProfessionalBeginning Database Design: From Novice to Professional

Beginning Database Design: From Novice to Professional provides short, easy-to-read explanations of how to get database design right the first time... 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:

Murach's PHP and MySQL (Murach: Training & Reference)Murach's PHP and MySQL (Murach: Training & Reference)This book was developed by the same team that authored Murach's JavaScript and DOM Scripting, and it has the same strong content organization that let... Read More >
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 (4th Edition)MySQL (4th Edition)

The Definitive Guide to Using, Programming, and Administering MySQL 5.0 and 5.1

 

Popularity: 25% [?]