Top "Mysql" questions

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

Laravel $q->where() between dates

I am trying to get my cron to only get Projects that are due to recur/renew in the next 7 …

php mysql laravel eloquent datetime-format
How to Solve the XAMPP 1.7.7 - PHPMyAdmin - MySQL Error #2002 in Ubuntu

I have been through lots of forums and checked various posts on similar topic but non seems to work out …

mysql ubuntu phpmyadmin xampp mysql-error-2002
How to search for rows containing a substring?

If I store an HTML TEXTAREA in my ODBC database each time the user submits a form, what's the SELECT …

mysql odbc
How do I insert NULL values using PDO?

I'm using this code and I'm beyond frustration: try { $dbh = new PDO('mysql:dbname=' . DB . ';host=' . HOST, …

php mysql pdo null sql-insert
Insert data into table with result from another select query

I am seeking help on the following issue: I have two tables Table_1 columns are itemid, locationid, quantity Table_2 columns …

mysql select insert
Mysql DATE_SUB(NOW(), INTERVAL 1 DAY) 24 hours or weekday?

I am trying to get the total amount of registered users per day. At the moment I am using this: $…

mysql date sql-date-functions
How to provide a mysql database connection in single file in nodejs

I need to provide the mysql connection for modules. I have a code like this. var express = require('express'), app = …

mysql node.js express node-modules
#1025 - Error on rename of './database/#sql-2e0f_1254ba7' to './database/table' (errno: 150)

So I am trying to add a primary key to one of the tables in my database. Right now it …

mysql sql phpmyadmin innodb mysql-error-1025
When running UPDATE ... datetime = NOW(); will all rows updated have the same date/time?

When you run something similar to: UPDATE table SET datetime = NOW(); on a table with 1 000 000 000 records and the query takes 10 …

mysql sql datetime sql-update
How to add the JDBC mysql driver to an Eclipse project?

I have downloaded the mysql-connector-java-5.1.24-bin.jar I have created a lib folder in my project and put the jar …

java mysql servlets jdbc driver