Top "Mysql" questions

MySQL is a free, open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL).

How to call a MySQL stored procedure from within PHP code?

I have stored procedure that I created in MySQL and want PHP to call that stored procedure. What is the …

php mysql stored-procedures mysqli user-defined-functions
When to use MyISAM and InnoDB?

MyISAM is designed with the idea that your database is queried far more than its updated and as a result …

mysql database database-schema
How do I install command line MySQL client on mac?

I want to install the MySQL client for the command line, not a GUI. I have searched over the web …

mysql macos terminal
Connect to mysql in a docker container from the host

(It's probably a dumb question due to my limited knowledge with Docker or mysql administration, but since I spent a …

mysql docker dockerfile
How to kill MySQL connections

I'm building a website with MySQL. I'm using TOAD for MySQL and suddenly I can't connect to the database as …

mysql connection
MySQL Trigger - Storing a SELECT in a variable

I have a trigger in which I want to have a variable that holds an INT I get from a …

mysql sql triggers
Delimiters in MySQL

I often see people are using Delimiters. I tried myself to find out what are delimiters and what is their …

mysql delimiter
How to make join queries using Sequelize on Node.js

I am using sequelize ORM; everything is great and clean, but I had a problem when I use it with …

mysql node.js orm sequelize.js
Select data from "show tables" MySQL query

Is it possible to select from show tables in MySQL? SELECT * FROM (SHOW TABLES) AS `my_tables` Something along these …

mysql sql metadata
How to take complete backup of mysql database using mysqldump command line utility

How can I make a complete backup of mysql database using mysqldump? When I am making a backup, my tables …

mysql backup mysqldump complete