Top "Mysql" questions

MySQL is a free, open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL).

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

I am trying to run mysql client on my terminal. I have installed the latest mysql gem. ➜ ~ git:(master) ✗ ruby …

mysql terminal rvm osx-lion mysql.sock
How can I edit a view using phpMyAdmin 3.2.4?

I need to simply edit a very complicated view in phpMyAdmin 3.2.4 but I cannot figure how to do that. Any …

mysql database phpmyadmin
GROUP_CONCAT ORDER BY

I've a table like: +-----------+-------+------------+ | client_id | views | percentage | +-----------+-------+------------+ | 1 | 6 | 20 | | 1 | 4 | 55 | | 1 | 9 | 56 | | 1 | 2 | 67 | | 1 | 7 | 80 | | 1 | 5 | 66 | | 1 | 3 | 33 | | 1 | 8 | 34 | | 1 | 1 | 52 | I tried group_concat: SELECT li.…

mysql sql-order-by group-concat
MySQL Data Source not appearing in Visual Studio

I just installed the ADO.NET connector from here http://dev.mysql.com/downloads/connector/net/ Yet MySQL doesn't appear …

mysql visual-studio-2012 ado.net
How to ORDER BY a SUM() in MySQL?

I have a table: "ID name c_counts f_counts " and I want to order all the record by sum(…

sql mysql sql-order-by
MySQL: ignore errors when importing?

I am importing a fairly large database. The .sql file has almost 1,000,000 lines in it. Problem is that I am …

mysql database import
Is there a naming convention for MySQL?

Here's how I do it: Table names are lower case, uses underscores to separate words, and are singular (e.g. …

mysql naming-conventions mysql-workbench
Remove privileges from MySQL database

Before you think this is a duplicate question, I believe I have a unique, even if it is somewhat dim-witted, …

mysql ubuntu phpmyadmin privileges grant
PyMySQL can't connect to MySQL on localhost

I'm trying to connect to MySQL on localhost using PyMySQL: import pymysql conn = pymysql.connect(db='base', user='root', passwd=…

python mysql mysql-error-2003
MySQL CONCAT returns NULL if any field contain NULL

I have following data in my table "devices" affiliate_name affiliate_location model ip os_type os_version cs1 inter …

mysql sql null concat