Import file size limit in PHPMyAdmin?

I have changed all the php.ini parameters I know: upload_max_filesize, post_max_size. Why am I still seeing 2MB? I...

Unknown column in 'field list' error on MySQL Update query?

I keep getting MySQL error #1054, when trying to perform this update query: UPDATE MASTER_USER_PROFILE, TRAN_USER_B...

What does it mean when MySQL is in the state “Sending data”??

What does it mean if the Mysql query: SHOW PROCESSLIST; returns "Sending data" in the State column? I imagine ...

The web application [] appears to have started a thread named [Abandoned connection cleanup thread] com.mysql.jdbc.AbandonedConnectionCleanupThread?

In the middle of my web-development I just close my web-app in my eclipse IDE, about a minute, I just saw a WARNING ...

Copy row but with new id?

I have a table "test" with an auto incremented id and an arbitrary number of columns. I want to make a copy of a ro...

mysql create user if not exists?

I have a query to check mysql users list for create new user. IF (SELECT EXISTS(SELECT 1 FROM `mysql`.`user` WHERE ...

How should I tackle --secure-file-priv in MySQL??

I am learning MySQL and tried using a LOAD DATA clause. When I used it as below: LOAD DATA INFILE "text.txt" INTO t...

update positive to negative value in mysql?

i have payment table fields update reason and amount & total field are change negative UPDATE payment SET r...

#1045 - Access denied for user 'root'@'localhost' (using password: YES)?

This might seem redundant but I was unable to find a correct solution. I was unable to login to mysql using the mys...

Reset MySQL root password using ALTER USER statement after install on Mac?

I'm new to the whole Mac experience. I recently installed MySQL and it seems I have to reset the password after inst...

How do you use MySQL's source command to import large files in windows?

I have a large (~150mb) sql file that I am trying to import. It is too large to do it through PHPMyAdmin even split...

SQL query for matching multiple values in the same column?

I have a table in MySQL as follows. Id Designation Years Employee 1 Soft.Egr 200...

How to insert BLOB and CLOB files in MySQL??

I want to store images and .docx/.doc, .pptx/.ppt, .pdf files using the front end of my software. I don't understand...

Which MySQL data type to use for storing boolean values?

Since MySQL doesn't seem to have any 'boolean' data type, which data type do you 'abuse' for storing true/false info...