Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [mysql-5]

Generic MySQL version 5 tag. Please use a mysql-5.x tag instead. Also tag with mysql for search purposes.

There are still thousands of users in the world using older version of MySQL.

Such versions include GA release of MySQL 5.1

  • 5.1.30 being the first GA
  • Some are using 5.1 releases prior to 5.1.30 in production at their own risk
  • Some are using MySQL 5.0, 4.1 and 4.0 and even 3.23.58
178 questions
4
votes
1 answer

Find clients who bought more than 1 million units in 3 consecutive months

I want to find the client's code (cCode), who bought more than 1 million units, in three consecutive months. Here is my data: gDate cCode buy 2014-10-22 15108164 1653410 2014-12-22 15108164 1653410 2014-10-22 16100286 …
Milad.K
  • 51
  • 2
3
votes
1 answer

count(id) on Char(0) column does not work!

Possible Duplicate: What is the difference between select count(*) and select count(any_non_null_column)? I have a column with the type of char(0). some of the rows are NULL and some of them are empty(''). The question is that when I run the…
Alireza
  • 3,636
  • 10
  • 37
  • 44
3
votes
1 answer

Structure of my database design?

I've been developing a C# Bus System app using SQL, and I need some advice. I don't know if asking on here is the right thing to do, but I essentially need someone to analyse the .SQL file I have, where I have designed my database schema. Primary…
Suzan Aydın
  • 133
  • 3
2
votes
1 answer

MySQL Error 10048 on nested Delphi Queries

I'm having a problem with MySQL (Server 5.1.11) interfacing with a Delphi application The problem occurs when trying to use the application to do a bulk export to Excel. During the application queries for a list matching projects (Query A), then…
Dan Kelly
  • 181
  • 6
0
votes
1 answer

Trying to avoid bad MySQL database design - can't figure out how to avoid too many columns

I am pretty much a beginner having only created a few small php web applications relying on a MySQL database. I am now working on a somewhat larger project. I am in the planning stages of setting up the database and am having difficulty wrapping my…
Jeff Michael
  • 3
  • 2