Top "Mysql" questions

MySQL Workbench - Connect to a Localhost

I just installed MySQL Workbench and there are no connections available for my localhost server. When I try to make …

mysql mysql-workbench

How to run mysql command on bash?

The following code works on the command line mysql --user='myusername' --password='mypassword' --database='mydatabase' --execute='DROP DATABASE myusername; CREATE …

mysql bash unix terminal special-characters

How to connect to Mysql Server inside VirtualBox Vagrant?

I mounted a new VirtualBox Machine with Vagrant, and inside that VM I installed Mysql Server. How can I connect …

mysql virtualbox vagrant

PDO mysql: How to know if insert was successful

I'm using PDO to insert a record (mysql and php) $stmt->bindParam(':field1', $field1, PDO::PARAM_STR); $…

php mysql database pdo

How to select rows where column value IS NOT NULL using CodeIgniter's ActiveRecord?

I'm using CodeIgniter's Active Record class to query the MySQL database. I need to select the rows in a table …

php mysql codeigniter activerecord null

How to update MySql timestamp column to current timestamp on PHP?

I want to update the columns of data type timestamp manually through my PHP code. Can you please tell me …

php mysql database timestamp sql-update

Handling MySQL datetimes and timestamps in Java

In a java application what would a good compromise in terms of extracing and inputting date information with a MySQL …

java mysql date jdbc timestamp

MySQL how to join tables on two fields

I have two tables with date and id fields. I want to join on both fields. I tried JOIN t2 …

mysql join

Why is MySQL InnoDB insert so slow?

I am using large random numbers as keys (coming in from another system). Inserts and updates on fairly-small (as in …

mysql performance innodb

Most efficient way to get table row count

I currently have a database with over 6 million rows and growing. I currently do SELECT COUNT(id) FROM table; in …

mysql sql count