Top "Mysql" questions

MySql : Grant read only options?

I have a user, whom I want to grant all the READ permission on a db schema. One way is …

mysql sql

MySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near

I have the Stored procedure like this: CREATE PROCEDURE ProG() BEGIN SELECT * FROM `hs_hr_employee_leave_quota`; END But …

mysql mysql-error-1064

Meaning of "n:m" and "1:n" in database design

In database design what do n:m and 1:n mean? Does it have anything to do with keys or relationships?

mysql database foreign-keys relationship

How can I initialize a MySQL database with schema in a Docker container?

I am trying to create a container with a MySQL database and add a schema to these database. My current …

mysql docker database-schema

For homebrew mysql installs, where's my.cnf?

For homebrew mysql installs, where's my.cnf? Does it install one?

mysql homebrew

UTF-8: General? Bin? Unicode?

I'm trying to figure out what collation I should be using for various types of data. 100% of the content I …

mysql utf-8 collation

MySQL config file location - redhat linux server

What is the default location for the MySQL configuration file on a redhat linux box?

mysql linux redhat

Working with INTERVAL and CURDATE in MySQL

I'm building a chart and I want to receive data for each month. Here's my first request which is working: …

mysql datetime date intervals

How Can I Set the Default Value of a Timestamp Column to the Current Timestamp with Laravel Migrations?

I would like to make a timestamp column with a default value of CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP using …

php mysql laravel laravel-4 laravel-5

MySQL CURRENT_TIMESTAMP on create and on update

I want to define table which will have 2 TIMESTAMP fields, someting like this: CREATE TABLE `msgs` ( `id` INT PRIMARY KEY …

mysql timestamp mysql-error-1293