Learn HTML, JavaScript, CSS, PHP, MySQL, SEO
Posts tagged "MySQL"
I didn’t know until it happened to me recently, but MySQL tables can crash. When one of my tables crashed the first I knew about it was when I tried to browse it using phpMyAdmin and received an error message.
MySQL can do far more than just insert, update and select data. In fact the world’s most popular open source database has a whole host of incredibly useful functions built in that you might never know about until you find one day that you need them – and then you wonder how you coped without them!
The MySQL relational database management system (RDBMS) supports a wide range of data types. The data type that you chose for your table columns is important because it determines how MySQL will store your data. It’s possible that any one of multiple data types could be used to store a piece of data, but which one is the best or optimal data type to use?
Continue reading "How to Choose the Optimal MySQL Data Type" »