Top "Mysql" questions

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

Truncate all tables in a MySQL database in one command?

Is there a query (command) to truncate all the tables in a database in one operation? I want to know …

mysql
Forbidden :You don't have permission to access /phpmyadmin on this server

Hi I have installed phpmyadmin on my centos machine and when I try to hit phpmyadmin through my browser I …

php mysql phpmyadmin
How can I access the MySQL command line with XAMPP for Windows?

How can I access the MySQL command line with XAMPP for Windows?

mysql windows xampp mysqldump
Find rows that have the same value on a column in MySQL

In a [member] table, some rows have the same value for the email column. login_id | email ---------|--------------------- john | …

sql mysql database
How to grant remote access permissions to mysql server for user?

If I do SHOW GRANTS in my mysql database I get GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY …

mysql connection grant
MySQL: @variable vs. variable. What's the difference?

In another question I posted someone told me that there is a difference between: @variable and: variable in MySQL. He …

mysql sql variables
How to save MySQL query output to excel or .txt file?

How do you save output of a MySQL query to a MS Excel sheet? Even if it's only possible to …

mysql excel
SQL - find records from one table which don't exist in another

I've got the following two SQL tables (in MySQL): Phone_book +----+------+--------------+ | id | name | phone_number | +----+------+…

sql mysql
How to find the mysql data directory from command line in windows

In linux I could find the mysql installation directory with the command which mysql. But I could not find any …

mysql database linux windows command-line
How to import an excel file in to a MySQL database

Can any one explain how to import a Microsoft Excel file in to a MySQL database? For example, my Excel …

mysql excel