Top "Mysql" questions

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

Unable to connect to any of the specified mysql hosts. C# MySQL

I am getting the above error when I execute the code - MySqlConnection mysqlConn=new MySqlConnection("server=127.0.0.1;uid=pankaj;port=3306;…

c# mysql visual-studio-2010 sharpdevelop
phpMyAdmin is throwing a #2002 cannot log in to the mysql server phpmyadmin

I have installed MySQL server enterprise 5.1 on my local machine and now I want to install phpMyAdmin, but it does …

mysql phpmyadmin
MySQL: Invalid use of group function

I am using MySQL. Here is my schema: Suppliers(sid: integer, sname: string, address string) Parts(pid: integer, pname: string, …

mysql sql mysql-error-1111
Bug? #1146 - Table 'xxx.xxxxx' doesn't exist

I am using windows XP. I am creating a table in phpMyAdmin using its built-in create table feature, my database …

mysql phpmyadmin mysql-error-1146
How can I merge two MySQL tables?

How can I merge two MySQL tables that have the same structure? The primary keys of the two tables will …

sql mysql merge
how to customize `show processlist` in mysql?

I want to order by Time,but seems no way to do that ? mysql> show processlist; +--------+-------------+--------------------+…

mysql filter sql-order-by processlist
How to change the default collation of a table?

create table check2(f1 varchar(20),f2 varchar(20)); creates a table with the default collation latin1_general_ci; alter table check2 …

mysql sql collation
UnicodeEncodeError: 'latin-1' codec can't encode character

What could be causing this error when I try to insert a foreign character into the database? >>UnicodeEncodeError: …

python mysql unicode pylons
MySQL - force not to use cache for testing speed of query

I'm testing the speed of some queries in MySQL. The database is caching these queries making it difficult for me …

mysql
Best data type for storing currency values in a MySQL database

What is the best SQL data type for currency values? I'm using MySQL but would prefer a database independent type.

mysql sql sqldatatypes