Top "Mysql" questions

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

Which ORM should I use for Node.js and MySQL?

I'm rewriting a project to use Node.js. I'd like to keep using MySQL as the DB (even though I …

Read More
mysql orm node.js
How do you stop MySQL on a Mac OS install?

I installed MySQL via MacPorts. What is the command I need to stop the server (I need to test how …

Read More
mysql macos
MySQL Workbench: How to keep the connection alive

Error Code: 2013. Lost connection to MySQL server during query I am using MySQL Workbench. Also, I am running a batch …

Read More
mysql sql mysql-workbench connection-timeout
Count with IF condition in MySQL query

I have two tables, one is for news and the other one is for comments and I want to get …

Read More
mysql join if-statement count
1114 (HY000): The table is full

I'm trying to add a row to an InnoDB table with a simply query: INSERT INTO zip_codes (zip_code, …

Read More
mysql innodb
MySQL Query to select data from last week?

Hi I have a table with a date field and some other information. I want to select all entries from …

Read More
mysql sql database datetime
adding 1 day to a DATETIME format value

In certain situations I want to add 1 day to the value of my DATETIME formatted variable: $start_date = date('Y-m-d …

Read More
php mysql date datetime
Convert JS date time to MySQL datetime

Does anyone know how to convert JS dateTime to MySQL datetime? Also is there a way to add a specific …

Read More
javascript mysql
MySQL "WITH" clause

I'm trying to use MySQL to create a view with the "WITH" clause WITH authorRating(aname, rating) AS SELECT aname, …

Read More
mysql sql common-table-expression
How to get next/previous record in MySQL?

Say I have records with IDs 3,4,7,9 and I want to be able to go from one to another by navigation …

Read More
sql mysql