My weekend project was to explore Morpheus, a Cloud Database As A Service. Here is what I learned about running SQL, NoSQL and caching databases in one place.
MySQL – Export the Resultset to CSV file
In MySQL you can export a resultset to CSV in more than one way. I show two methods: the Export option in Workbench and the INTO OUTFILE command.
MySQL – UDF – Validate Integer Function
MySQL has no ISNUMERIC function like SQL Server, so here is a simple user defined function that uses a regular expression to validate integer values.
MySQL – How to Format Date in MySQL with DATE_FORMAT()
MySQL uses the DATE_FORMAT function to show a date or datetime value in the format you need. Here are simple, self-explanatory examples for common formats.
MySQL – How INSERT() Function Works for MySQL
MySQL has an INSERT() function that has nothing to do with adding rows. It replaces characters within a string at a given position. Here is how it works.
MySQL – Add a Column at Particular Ordinal Position in Table
SQL Server needs the designer to add a column at a particular ordinal position, but MySQL does it with ALTER TABLE and AFTER. Here is a quick example.
MySQL – Dynamic SQL with EXECUTE and PREPARE Statements
MySQL supports dynamic SQL with EXECUTE and PREPARE statements. Here is how to pass a table name as a parameter and return all rows from it.