Creation and Design of MySQL Schema Objects Required Knowledge > Design and create normalized databases > Create and modify tables using appropriate data types and indexing > Describe and create table constraintsRead More…
Required Knowledge > Explain MySQL implementation of identifiers including case sensitivity, qualified names, aliases and use of reserved words. > Identify MySQL data type properties and appropriate usage > Recognize and useRead More…
General MySQL Syntax Required Knowledge > Explain MySQL implementation of identifiers including case sensitivity, qualified names, aliases and use of reserved words. > Identify MySQL data type properties and appropriate usage >Read More…
MySQL Architecture Required knowledge: > Use MySQL client programs to interface with the MySQL Server interactively and in batch > Describe SQL Modes and their impact on behavior of MySQL > IdentifyRead More…
I couldn’t really find an exam prep tool for the MySQL 5.6 Developer Exam, so I decided to create my own. I figured if I had something online, then I could study anywhere,Read More…
When I first ran across Events in MySQL, I wondered what I could use them for, particularly things I normally did with PHP or Python. In most instances where I am loadingRead More…
Recently I have been updating one of my older sites to a completely new code base, and with that new code I’ve switched all old MySQL calls from the old mysql_* functionsRead More…
One of the library scripts was pulling borrower data, but for some people a required “email” field was missing. I was using IFNULL() to test if a particular type of email existed,Read More…
Today I was working on setting up a MySQL backup/failover for our Identity Management servers and needed to install some additional MySQL Utilities to make it work. I downloaded the files toRead More…
I normally use the PHP PDO to retrieve data from a MySQL database, and then convert the data to JSON after calling $statement->fetchAll(PDO::FETCH_ASSOC). This has worked well for me, and each rowRead More…