Home
Topics
Enterprise Linux applications and databases
Open source databases
Mastering MySQL: Ten essential tips

Mastering MySQL: Ten essential tips

Getting started with open source relational database management system, MySQL, doesn't have to be difficult. Here, we've set aside our most-clicked, helpful tips on MySQL. Take a look at these ten essential tips to further your database expertise. If we're missing something, go ahead and ask an expert for further MySQL advice.

Did you find this useful or did we miss something? Email us and let us know what MySQL tips you'd like to see!

10 essential MySQL tips

MySQL: Getting started
The Definitive Guide to MySQL 5: MySQL Administrator and Query Browser
Mastering MySQL: Drivers, clustering and remote access
MySQL database features: ACID, buffer pools and blob fields
MySQL workarounds: Triggers and mutating table errors
Troubleshooting: Bug tracking, remote databases and workarounds in MySQL
Interoperability: Using Excel to analyze MySQL data
Oracle and MySQL: Licensing and the Linux enterprise space
PostgreSQL or MySQL: Which is faster?
SQL Server vs. MySQL: Syntax differences, similar GUIs

Need an answer? Ask an expert

Scott Noyes, MySQL expert
Scott Noyes is the senior Web applications developer for Bookit.com. When he's not working for them, Scott is handing out expert advice on all aspects of MySQL.

More News and Tutorials

Articles

This was first published in April 2007

Join the conversationComment

Share

Comments

Results

Contribute to the conversation

All fields are required. Comments will appear at the bottom of the article.

More from Related TechTarget Sites

Data Center
Server Virtualization
Cloud computing
Enterprise Desktop

Data Center
- Data center modernization starts with cloud, SDN and virtualization
  
  Some of the technologies driving data center modernization include cloud computing, flash storage, virtualization and software-defined networking.
- Data center technologies evolve to meet tomorrow's computing demands
  
  VMware's upcoming public cloud and AMD's 64-bit ARM servers are technologies for the data center that exemplify the changes in the IT industry.
- New data center cooling strategies to improve efficiency, lower costs
  
  Stagnant strategies for data center cooling will keep energy bills climbing ever higher, but a more modern approach can bring them back down to earth.
Server Virtualization
- How to achieve optimal resource allocation and why that matters
  
  Optimal resource allocation is a tricky tightrope act for even experienced IT pros, but you can ease the process by asking yourself a few questions.
- Virtualization widens schism between server and networking teams
  
  Virtual networking has revived tensions between server and networking teams within data centers, but it's a dynamic both sides must embrace.
- Strike a common-sense balance when deciding what to automate
  
  Consider the many factors that determine the potential return on investment when deciding when and what to automate.
Cloud computing
- Interest in private clouds grows as market matures
  
  Growing interest in private clouds reflects an improved understanding of cloud computing among IT pros, experts say.
- Building a cloud ecosystem with open source software
  
  The open source community fosters innovation in the name of cloud. OW2's Cédric Thomas talks of 'coopitition' and the open source cloud revolution.
- Sequestration stymies federal government cloud ambitions
  
  The federal government is under mandates to consolidate data centers and deliver IT as a Service, but sequestration makes this easier said than done.
Enterprise Desktop
- New Office 2013 features can help IT pros as much as end users
  
  New features in Microsoft Office 2013 make desktop management more efficient. See what Office Web Apps Server, Office Telemetry and more can do.
- How to remove a Windows.old folder
  
  Deleting a Windows.old folder seems simple, but it isn't. Our expert explains why Windows Desk Cleanup won't work.
- Finding a prescription for desktop security management at Sharp HealthCare
  
  Desktop security policy must cover the use of mobile devices and the cloud. Sharp HealthCare uses a mix of software for desktop security management.

All Rights Reserved,Copyright 2003 - 2013, TechTarget