Mysql: Comments in Fields
April 9, 2008 by daynah
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. ;)
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 provides short, easy-to-read explanations of how to get database design right the first time... Read More >
PHP and MySQL Web Development (4th Edition)PHP and MySQL are popular open-source technologies that are ideal for quickly developing database-driven Web applications. PHP is a powerful scripting... Read More >
MySQL High Availability: Tools for Building Robust Data CentersServer bottlenecks and failures are a fact of life in any database deployment, but they don't have to bring everything to a halt. MySQL has several... Read More >
Popularity: 10% [?]
FQL: Facebook Query Language
February 26, 2007 by daynah
Filed under So Much Data
Introducing, FQL! What is FQL you may ask? FQL is a way to query the same Facebook data you can access through the other API functions, but with a SQL-style interface. In fact, many of the normal API calls are simple wrappers for FQL queries. All of the usual privacy checks are still applied. A typical query looks something like this:
SELECT name, pic FROM user WHERE uid=211031 OR uid=4801660
Read More about the Facebook API here.
Related Products:
Electronics Fundamentals: Circuits, Devices & Applications (8th Edition)This renowned book offers a comprehensive yet practical exploration of basic electrical and electronic concepts, hands-on appli... Read More >
Electronics For DummiesElectronics is fascinating – want to make something of it? This book shows you how!You can make all sorts of things, once you understand what ele... Read More >
Electronics For DummiesElectronics is fascinating – want to make something of it? This book shows you how!You can make all sorts of things, once you understand what ele... Read More >
Popularity: 24% [?]
SQL Zoo
April 8, 2005 by daynah
Filed under Daily Ramblings, Links and Resources, So Much Data
Interested in learning about databases? Try this great interative tutorial called SQL Zoo. Here, you can learn about: SQL Server, Oracle, MySQL, DB2, Mimer SQL, PostgreSQL and Access.
Related Products:
Getting Started in ElectronicsThis is a complete electronics course in 128 pages! Author Forrest Mims teaches you the basics, takes you on a tour of analog and digital components, ... Read More >
HDMI Cable 2M (6 Feet)Perfect for connecting your HDTV, DVD/Blu-Ray players, gaming systems, and other home theater/entertainment components.These HDMI cables are ATC (Authorized Testing Center) certified, meaning you can count on them to pass a high-definition signal up to 1080p.
Make: Electronics (Learning by Discovery)"This is teaching at its best!"
--Hans Camenzind, inventor of the 555 timer (the world's most successful integrated circuit), and author of... Read More >
Popularity: 10% [?]
WordPress: Error 28
March 18, 2005 by daynah
Filed under So Much Data, Wordpress
I got an Error 28 after posting on my WordPress blog yesterday. So I searched the Support forums to find out why. I found this helpful wiki page that showed me how I can avoid the Error 28.
“If you get this error, check all filesystems in which MySQL operates. If you followed recommendations to split datadir, tmpdir and log files into dedicated filesystems, more than one filesystem is involved. In addition, be aware that MySQL often creates temporary tables for some queries. Most of these are placed in tmpdir; however, some may be found in the database directory (e.g. ALTER TABLE). Also, ensure that sufficient free disk space is available for MySQL.”
If you get this error, running “repair table” in phpMyAdmin can fix it. Or just contact your host and let them know about the problem.
Related Products:
Make: Electronics (Learning by Discovery)"This is teaching at its best!"
--Hans Camenzind, inventor of the 555 timer (the world's most successful integrated circuit), and author of... Read More >
Electronics For DummiesElectronics is fascinating – want to make something of it? This book shows you how!You can make all sorts of things, once you understand what ele... Read More >
HDMI Cable 2M (6 Feet)Perfect for connecting your HDTV, DVD/Blu-Ray players, gaming systems, and other home theater/entertainment components.These HDMI cables are ATC (Authorized Testing Center) certified, meaning you can count on them to pass a high-definition signal up to 1080p.
Popularity: 7% [?]
@
