Top "Mysql" questions

mysql :: insert into table, data from another table?

I was wondering if there is a way to do this purely in sql: q1 = SELECT campaign_id, from_number, …

sql mysql

MySQL and GROUP_CONCAT() maximum length

I'm using GROUP_CONCAT() in a MySQL query to convert multiple rows into a single string. However, the maximum length …

mysql group-concat

Remote Connections Mysql Ubuntu

For some reason, I've been unable to connect remotely to my MySQL server. I've tried everything and I'm still getting …

mysql ubuntu remoting

MYSQL Truncated incorrect DOUBLE value

When the SQL query below is executed: UPDATE shop_category SET name = 'Secolul XVI - XVIII' AND name_eng = '16…

mysql

MySQL, update multiple tables with one query

I have a function that updates three tables, but I use three queries to perform this. I wish to use …

mysql sql sql-update

What's the difference between MyISAM and InnoDB?

I understand that this question has been asked before, but most of the time it is asked in relation to …

mysql database innodb myisam

How to use GROUP BY to concatenate strings in MySQL?

Basically the question is how to get from this: foo_id foo_name 1 A 1 B 2 C to this: foo_id …

sql mysql string aggregate concatenation

Can't import database through phpmyadmin file size too large

I have been trying to import Database through phpMyAdmin. My database file is a.sql and it's size is 1.2 GB …

mysql database apache phpmyadmin wampserver

how to mysqldump remote db from local machine

I need to do a mysqldump of a database on a remote server, but the server does not have mysqldump …

mysql mysqldump

How to rename uploaded file before saving it into a directory?

Below is the code I used in order to upload files into a directory. It works fine. My main question …

php mysql file-upload file-rename