Questions tagged [mysql4]
34 questions
1
vote
2 answers
MySQL: Migrating Queries from v4 to v5
When migrating a project from MySQL 4 to MySQL 5, what are the primary things I need to address in order to ensure queries remain compatible?
In general things should be fine, but I know that some things that worked implicitly in MySQL 4 queries…
Wilco
- 32,754
- 49
- 128
- 160
1
vote
1 answer
Use 'show query' as a subquery to count the rows in MySQL 4.1
I have MySQL 4.1 server version installed. I want to use the 'show query' as a subquery in a SELECT statement.
For example:
SELECT count(*) from (SHOW VARIABLES LIKE 'log_bin');
But this gives me an error like:
ERROR 1064 (42000): You have an…
Terminater
- 186
- 7
1
vote
0 answers
MySql 4.1+ hash in C#
Hello I'm trying to make an ASP.Net website and I need my passwords to be stored in the database encrypted in MySql4.1+ method. I have searched the web enough but I still haven't found any tuts that can show me how to make the registration and login…
Mind Rapist
- 19
- 3
1
vote
1 answer
Mysql 4 to 5 query conversion - join headaches
If anyone can help me rewrite my query to work in mysql 5 I would be very grateful. If anyone can provide links to solid, simple tutorials on how to rewrite old queries that would also be great.
My current (version 4) query looks like this:
SELECT
…
Tobias Ekenstam
- 13
- 2
1
vote
4 answers
SQL to delete duplicate records with some common field values?
Consider a table with the following schema:
id, location, starred
There are many records with the same location:
id | location | starred
-----------------------
1 rome yes
2 rome no
3 rome no
4 milan yes
5 …
simpatico
- 10,709
- 20
- 81
- 126
1
vote
1 answer
Can someone explain why this select statement behaves the way it does
While working on generating rankings for a game, I wrote a query similar to the following code (a lot of columns left out for brevity), and noticed the rank was producing seeming gibberish (first query). However changing the table in which…
graham.reeds
- 16,230
- 17
- 74
- 137
1
vote
1 answer
Create table trouble in MySQL 4.1
The column which defined with char type in a create table sentence is defined as varchar()
It was defined as char(8) convert to varchar (8) in desc on DB.
char(1) -> char(1) on same DB
When it defined a table of the char type more than 2 bytes, to…
freddiefujiwara
- 57,041
- 28
- 76
- 106
0
votes
1 answer
Is it possible to create a transactional merge table in mysql?
MySQL docs say that tables that use the MERGE storage engine can only union underlying MyISAM tables, which don't allow use of transactions.
Is there an alternative or workaround so that I can have a table that contains the data of several…
Parris Varney
- 11,320
- 12
- 47
- 76
0
votes
1 answer
docker mysql 4.0.27 start problem after creating dockerfile entrypoint.sh
I have created a docker image, and I have problem to start automatically or even start mysql.
The problem is echo "$@" in entrypoint.sh, I expect to run mysqld_safe, but It doesn't. If a change the line echo "$@" to mysqld_safe --user=mysql it…
szabolcssandor
- 3
- 1
0
votes
1 answer
MySQL 4.0 Gibberish Cannot Convert to Newer MySQL
One of the websites I host still runs on PHP 5.2 with MySQL 4.0. Its text is in Hebrew (displays just fine on the site), but in the DB the text appears as gibberish containing question marks—but not exclusively. It looks some like: ?????£ ?§???¥…
Ynhockey
- 3,845
- 5
- 33
- 51
0
votes
1 answer
Upgrade from mysql 4.1 to mysql 5.5
I was going through upgrade process of mysql server. It is mentioned that to upgrade from 4.1 to 5.5 we need to upgrade step by step like first to 5.0,5.1 ...5.4 and then 5.5.
I have some questions :
What if we directly upgrade from 4.1 to 5.5.…
stefun
- 1,261
- 3
- 24
- 54
0
votes
1 answer
Rails with MySQL v.4.1
Is there any chance to make Rails application connect to old MySQL v4.1.20 server?
rails db
command works fine, but I cannot run the application.
When I generate new app with
rails new app_name -d mysql
I see the following in database.yml…
Mikhail Chuprynski
- 2,404
- 2
- 29
- 42
0
votes
1 answer
MySQL 4 SUM if two rows have the same value on a given column
I'm using an (OLD) MySQL 4.0 database and I need to sum quantities when for two rows, a specific column has the same value.
Example,
So let,s say I have these columns:
doc_nr | client_name | article_id | qty
When they are inserted into the database,…
Zed_Blade
- 1,009
- 3
- 18
- 38
0
votes
3 answers
mysql_query stopped working after upgrade to Mysql5 and PHP 5.2
I can' find solution how to get it working. I upgraded Mysql 4 to Mysql 5 and changed PHP to 5.2, since than i can't activate account and login.
What's wrong with this code?
include_once("conn.php");
$check_num = $_GET['c'];
$exists…
Marcin
- 1
0
votes
2 answers
Not your usual MySQL4 + ODBC connection issue
I've got a problem with ODBC that has me stumped, and I can't find an answer anywhere that addresses my problem. Short version: I can't connect to my MySQL4 installation on Ubuntu Jaunty from my WinXP ODBC System DNS, even tho I can connect just…
Logos
- 366
- 3
- 19