Top "Mysql" questions

Access denied for root user in MySQL command-line

I've just installed xampp, and am using command line to write mySQL. I am using 'root' with no password and …

mysql command-line xampp

PHP and MySQL Select a Single Value

I'd like to know how to select a single value from my MySQL table. The table includes columns username and …

php mysql sql database user-accounts

How to insert image in mysql database(table)?

I want to insert image into a table like CREATE TABLE XX_SAMPLE(ID INT ,IMAGE BLOB); So can you …

mysql database blob mysql-loadfile

phpMyAdmin - Error > Incorrect format parameter?

I have a WordPress production website. I've exported the database by the following commands: select database > export > custom &…

database mysql

How to get the next auto-increment id in mysql

How to get the next id in mysql to insert it in the table INSERT INTO payments (date, item, method, …

mysql sql

delete all from table

what's faster? DELETE FROM table_name; or DELETE FROM table_name where 1=1; why? does truncate table work in access?

sql mysql ms-access optimization performance

mysql update multiple columns with same now()

I need to update 2 datetime columns, and I need them to be exactly the same, using mysql version 4.1.20. I'm using …

mysql sql-update

SQLSTATE[HY000] [1045] Access denied for user 'username'@'localhost' using CakePHP

I am new to PHP and CakePHP. I am finding problems while wiring my database using CakePHP. Below is my …

php mysql cakephp cakephp-3.0

Why shouldn't I use mysql_* functions in PHP?

What are the technical reasons for why one shouldn't use mysql_* functions? (e.g. mysql_query(), mysql_connect() or mysql_…

php mysql

How do you use the "WITH" clause in MySQL?

I am converting all my SQL Server queries to MySQL and my queries that have WITH in them are all …

mysql common-table-expression with-clause subquery-factoring mysql-8.0