Top "Mysql" questions

Remove Primary Key in MySQL

I have the following table schema which maps user_customers to permissions on a live MySQL database: mysql> describe …

mysql sql database-design primary-key mysql-error-1075

How to get multiple counts with one SQL query?

I am wondering how to write this query. I know this actual syntax is bogus, but it will help you …

mysql sql join count group-by

update columns values with column of another table based on condition

I have two tables... table1 ( id, item, price ) values: id | item | price ------------- 10 | book | 20 20 | copy | 30 30 | pen | 10 ....table2 ( id, item, price) …

sql mysql sql-server oracle

Downloading MySQL dump from command line

I am moving away from Linode because I don't have the Linux sysadmin skills necessary; before I complete the transition …

mysql command-line command-line-arguments linode

#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 …

mysql phpmyadmin localhost port wamp

Multiple Updates in MySQL

I know that you can insert multiple rows at once, is there a way to update multiple rows at once (…

mysql sql sql-update

How to enable MySQL Query Log?

How do I enable the MySQL function that logs each SQL query statement received from clients and the time that …

mysql logging

Cast int to varchar

I have below query and need to cast id to varchar Schema create table t9 (id int, name varchar (55)); insert …

mysql sql database casting mariadb

mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in

I'm have some trouble checking if a Facebook User_id already exists in my database (if it doesn't it should …

php mysql mysqli boolean

selecting unique values from a column

I have a MySQL table which contains the following type of information: Date product 2011-12-12 azd 2011-12-12 yxm 2011…

php mysql sql