Top "Mysql" questions

How to 'insert if not exists' in MySQL?

I started by googling, and found this article which talks about mutex tables. I have a table with ~14 million records. …

php mysql sql primary-key sql-insert

MySQL: Insert record if not exists in table

I am trying to execute the following query: INSERT INTO table_listnames (name, address, tele) VALUES ('Rupert', 'Somewhere', '022') …

mysql

How can I import a database with MySQL from terminal?

How can I import a database with mysql from terminal? I cannot find the exact syntax.

mysql import

Access denied for user 'root@localhost' (using password:NO)

I'm new to MySQL, I'm trying to run WordPress in my Windows desktop and it needs MySQL. I install everything …

mysql wordpress mysql-error-1045

Solving a "communications link failure" with JDBC and MySQL

I'm trying to connect to the local MySQL server but I keep getting an error. Here is the code. public …

java mysql jdbc

Access Denied for User 'root'@'localhost' (using password: YES) - No Privileges?

I am continuously receiving this error. I am using mySQL Workbench and from what I am finding is that root's …

mysql root mysql-workbench workbench

mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row()/mysql_num_rows etc... expects parameter 1 to be resource

I am trying to select data from a MySQL table, but I get one of the following error messages: mysql_…

php mysql

How to delete a column from a table in MySQL

Given the table created using: CREATE TABLE tbl_Country ( CountryId INT NOT NULL AUTO_INCREMENT, IsDeleted bit, PRIMARY KEY (CountryId) ) …

mysql ddl alter-table

Create new user in MySQL and give it full access to one database

I want to create a new user in MySQL and give it full access only to one database, say dbTest, …

mysql access-control database-security

How do I check if a column is empty or null in MySQL?

I have a column in a table which might contain null or empty values. How do I check if a …

mysql sql