I'm afraid this is a completly application-related question and not
MySQL one.
Migrating data from old table format to the new one should be done using
a specially made software for that (PHP, Perl, etc etc). You should read all
data from old tables and insert them in the new ones.
I
Probably there's nothing wrong with the query. The problem seems to be
that MySQL you're using (v3) does NOT support subqueries. Note that MySQL
v4.0, the actual production release, does NOT support subqueries either.
Subqueries are supported on MySQL v4.1, which is still in ALPHA stages
igues
- Original Message -
From: "Wang Feng" <[EMAIL PROTECTED]>
To: "Leonardo Rodrigues Magalhães" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Sunday, September 28, 2003 9:51 AM
Subject: Re: newbie Q: create a table in a database
> That's
You can create a table in any database without 'changing' to that
database, via USE or logging again. You can make
create table database.tablename (tabledefinition);
>
> >c:\mysql\bin\mysql line 1
> mysql>create database DB1line 2
mysql>cre
As far as I know, MySQL Access Privilege system does not allow you to
create groups of users. You can have only users.
Communication between MySQL Server and MySQL client is, normally, NOT
encrypted. You can do that using SSL connections to your server (Mysql4
feature). Check
http://www.m
MySQL 4.0 (the current stable brench) does not support subqueries.
This feature is present in the beta brench of MySQL, v4.1.
http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html#ANSI_diff_Subqueries
Sincerily,
Leonardo Rodrigues
- Original Message ---
Hello Guys,
I have the following table:
CREATE TABLE tempo_resposta (
id int(11) NOT NULL auto_increment,
idmaquina int(11) NOT NULL default '0',
tempo int(11) NOT NULL default '0',
horario datetime NOT NULL default '-00-00 00:00:00',
PRIMARY KEY (id)
) TYPE=MyISAM;
I
Hello Guys,
I have a char field, and I'd like to have select ordering it by lowercase
caracteres, uppercase caracters then special characters. I was reading about sort and
this seems to be related to charset of the server, and I dont have access to change
this.
I was thinking on