DATE_FORMAT(date,format) Formats the date value according to the format string.
Tag Archives: MySQL
PHP’s sprintf() on a MySQL query utilizing DATE_FORMAT()
So what’s the solution? You have to “comment-out” the % that aren’t part of your sprintf() substitution. You can do this by putting another % in front of the ‘%’ symbols in the DATE_FORMAT() function. This deems them as a literal percent-sign instead of the start of another sprintf() “variable”.
Introduction to PHP PDO
Introduction to PHP PDO (PHP Data Objects) by Kevin Waterson Contents What is PDO What Databases does PDO support Where do I begin? Connect to a Database Connect to PgSQL Connect to SQLite Connect to MySQL Connect to Firebird Connect to Informix Connect to Oracle Connect to ODBC Connect to DBLIB Connect to IBM There …
NoSQL databases
NoSQL DEFINITION: Next Generation Databases mostly addressing some of the points: being non-relational, distributed, open-source and horizontal scalable. The original intention has been modern web-scale databases. The movement began early 2009 and is growing rapidly. Often more characteristics apply as: schema-free, easy replication support, simple API, eventually consistent / BASE (not ACID), a huge data …
Retrieving Records from Multiple Tables
It does no good to put records in a database unless you retrieve them eventually and do something with them. That’s the purpose of the SELECT statement—to help you get at your data. SELECT probably is used more often than any other in the SQL language, but it can also be the trickiest; the constraints …
Concatenate and NULL/Blank fields
CONCAT() and RTRIM() both return NULL if any of their arguments are NULL. So CONCAT(‘xyz’, NULL) returns NULL. RTRIM(NULL) returns NULL. CONCAT(‘xyz’, NULL, ‘123’) returns NULL. coalesce(FIELD, ‘—‘)