Top "Mysql" questions

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

How to delete a certain row from mysql table with same column values?

I have a problem with my queries in MySQL. My table has 4 columns and it looks something like this: id_…

mysql delete-row
How to find all the tables in MySQL with specific column names in them?

I have 2-3 different column names that I want to look up in the entire DB and list out all …

mysql information-schema
Convert text into number in MySQL query

Is it possible to convert text into number within MySQL query? I have a column with an identifier that consists …

mysql sql
How to get current date & time in MySQL?

Is there a value or command like DATETIME that I can use in a manual query to insert the current …

mysql sql datetime
MySQL error 1449: The user specified as a definer does not exist

When I run the following query I get an error: SELECT `a`.`sl_id` AS `sl_id`, `a`.`quote_id` …

mysql permissions
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO

I've looked through all the other StackOverflow (and google) posts with the same problem, but none seemed to address my …

php sql mysql pdo mysql-error-1064
Error Code: 2013. Lost connection to MySQL server during query

I got the Error Code: 2013. Lost connection to MySQL server during query error when I tried to add an index …

mysql sql database mysql-workbench
How to find out the MySQL root password

I cannot figure out my MySQL root password; how can I find this out? Is there any file where this …

mysql database
How does MySQL process ORDER BY and LIMIT in a query?

I have a query that looks like this: SELECT article FROM table1 ORDER BY publish_date LIMIT 20 How does ORDER …

mysql sql sql-order-by sql-limit
Trying to get property of non-object in

on Control page: <?php include 'pages/db.php'; $results = mysql_query("SELECT * FROM sidemenu WHERE `menu_id`='".$menu."…

php mysql object foreach fetch