Forum: MySQL

I'm currious - what multibyte charsets does MySQL support? utf8 is a multibyte charset, I think, as is sjis and maybe ujis. What other ones...

Hi, I'm helping a friend to build a system to handle advertisments from local dealers in different regions/cities. In this system, an...

I'm creating an application that has data for each user in a basically unlimited number of rows and columns. As a result the data itself is a bit...

Given a database with MyISAM tables, that one does not want to take offline for more than is absolutely necessary, what's the quickest (in terms of...

I have received a data file feed that is a little peculiar. The last field holds a currency value, represented adequately in the table as a...

Hi. I started local apache ( v.2.0) server on my desktop computer. I've installed php (v.5) and MySQL (v.5) I wrote php script that connects to...

Hello, I've been using mySql for a couple of years now. I was wondering about administration tools that use people out there. I have read many...

Hello, I've been using MySQL as my main tool for creating PHP/MySQl based web projects. But I've been so busy that I feel like I learned what I...

IPB WARNING mysql_connect() : Too many connections (Line: 131 of /ips_kernel/class_db_mysql.php) There appears to be an error with the database....

Hi there. I'm building a music site, and there are a few so called many-to-many (i believe) related tables in it. For instance i have Artists,...

Team,Score,Team,Score A,4,B,3 B,5,C,2 C,3,D,1 D,3,A,5 I have those 4 records in a database - I need to have them summarized like this: ...

How to make a query within to tables with a linked table ? How to get for instance all the adresses in a mail_group of a determinated "nom" of...

I'm using PHPMyAdmin on an Apache2Triad install (latest version; 5.x.x, which installs PHP5 and PHPMyAdmin5 as well). In Access, I exported a table...

Hi, I seem to be running Mysql 3.23. I want to upgrade to 5. I looked at the downloads page and cannot figure out which Linux version I should...

Hi, I would like to personalise my auto_increment reference field. Example : INSERT INTO my_table (data_field) VALUES ("value"); Normal way...

Hi, As InnoDB has been acquired by Oracle, it that means the future version of MySQL will not ship with InnoDB? Will it cause licensing...

I've read a lot of posts on how to do this, and so far, it seems the most popular ideas are: 1) Use the MyODBC to run the import via ODBC...

Hi! I'm trying to set an '1' to all records that return NULL in below query, using COALESCE, but I get errors which way I try...probably a...

What is the advantages if using MaxDB? Performance ? Reliability? When should we use MaxDB instead of say, InnoDB? thanks.

Looking to write a script such as: select * from domains where hostname=MYSQL.CLIENT.HOSTNAME that dynamically matches against the hostname (or...