Select Page
How to format dates directly in MySQL

How to format dates directly in MySQL

[toc]This tutorial explains how to format a MySQL date field to suit your needs without using PHP or any other post-processing.For example, you can output your dates in a long format such as Monday, 12th May 2016 or as a short date format – 17/Dec/86. MySQL...
How to format dates directly in MySQL

Adding users to your databases

[toc]This tutorial explains how to create new MySQL database users using SQL commands. As well as creating the users you’ll also learn how to restrict what they can do in specific databases. Please note:All the commands shown in this tutorial are SQL commands....
How to format dates directly in MySQL

Connecting to MySQL and creating databases

[toc]Although there are plenty of tools out there to help you create and manage mySQL databases, sometimes the fastest (or only) way is to use the mysql command line tool. This article will explain how to create a database, create a user for that database and give...