Hi,
Thank you very much that was what I looking for.
Best regards,
Cristi
Harald Fuchs wrote:
In article <[EMAIL PROTECTED]>,
iNFERNo <[EMAIL PROTECTED]> writes:
Hi,
First of all thank you all for the quick replys.
Now here's:
select * from events limit 10;
+--+---
In article <[EMAIL PROTECTED]>,
iNFERNo <[EMAIL PROTECTED]> writes:
> Hi,
> First of all thank you all for the quick replys.
> Now here's:
> select * from events limit 10;
> +--+--
> --+++--+-+---+--+---+--
>
> +
> | id |
nal Message -
From: "Michael J. Pawlowsky" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>;
Sent: Wednesday, April 06, 2005 7:51 PM
Subject: Re: I need some help
Rhino wrote:
- Original Message -
From: "iNFERNo" <[EMAIL PROTE
- Original Message -
From: "Michael J. Pawlowsky" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>;
Sent: Wednesday, April 06, 2005 7:51 PM
Subject: Re: I need some help
> Rhino wrote:
>
> >- Original Message -
> >From: &qu
Rhino wrote:
- Original Message -
From: "iNFERNo" <[EMAIL PROTECTED]>
To: "mysql"
Sent: Wednesday, April 06, 2005 5:23 PM
Subject: I need some help
Hi,
I have a problem: I am using mysql 4.0.24 and I need to make
some reports from a databa
- Original Message -
From: "iNFERNo" <[EMAIL PROTECTED]>
To: "mysql"
Sent: Wednesday, April 06, 2005 5:23 PM
Subject: I need some help
> Hi,
>
> I have a problem: I am using mysql 4.0.24 and I need to make
> some reports from
Hi,
I have a problem: I am using mysql 4.0.24 and I need to make
some reports from a database:
mysql> describe events;
+-+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+-+--
On 13 Jan 2004, at 19:11, Jochem van Dieten wrote:
I most certainly hope this Oracle idiosyncracy will never make it into
MySQL.
The SQL standard defines a different syntax for doing recursive
queries, using WITH RECURSIVE. I see no reason for MySQL to implement
a non-standard way for doing recurs
more on nested set models.
Cheers,
Matt
-Original Message-
From: Steve Folly [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 13, 2004 1:59 PM
To: MySQL MySQL
Subject: Re: hierarchical records, I need some help!! ;(
On 13 Jan 2004, at 09:19, Victor Reus wrote:
> Hi again,
>
>
>I want to have all the items into a recorset with only one query like
>Select id, reference, component from NOMS where reference = '4'
>but i want not only the primary relations, i want all relations.
>Could somebody help a newbie like me?
It can also help to change the way you look at the r
Steve Folly said:
>
> However, I suspect this isn't the full story. Do you also want to
> see what components make up C003 and D003 in the same query? I
> think you're after a feature not yet implemented in MySQL - the
> 'CONNECT BY PRIOR' SELECT statement, just the ticket for
> hierarchical que
On 13 Jan 2004, at 09:19, Victor Reus wrote:
Hi again,
Second: specify what you mean with "all relations". Can you
share some sample data and sample output (that is: what
do you expect the query to return).
Ok my table noms is like
| id | int(11) | | PRI | [NULL] | a
Hi again,
> Second: specify what you mean with "all relations". Can you
> share some sample data and sample output (that is: what
> do you expect the query to return).
Ok my table noms is like
| id | int(11) | | PRI | [NULL] | auto_increment
| reference| varchar(255) |
Victor,
First: don't ask the same thing twice.
> I have one table called noms like this:
>
>
> | id | int(11) | | PRI | [NULL] | auto_increment |
> | reference| varchar(255) |
> | component| varchar(255) |
>
> the relation between reference and component is hierarch
Hi
I have one table called noms like this:
| id | int(11) | | PRI | [NULL] | auto_increment |
| reference| varchar(255) |
| component| varchar(255) |
the relation between reference and component is hierarchical like
reference - > component
reference
Hi
I have one table called noms like this:
| id | int(11) | | PRI | [NULL] | auto_increment |
| reference| varchar(255) |
| component| varchar(255) |
the relation between reference and component is hierarchical like
reference - > component
reference
L Mailinglist
Subject: RE: little problem, I need some help...
Every SQL database requires the ability to locate a record which is
unique
in some way. You can't have two records which look the same.
That's why you need to define a primary KEY on a column or coumns.
You need to r
hello everyone:
1) in my school groups are called forms, so I used it not to confuse you
2) I hadn't learnt how to define indexes on MySQL so I hadn't defined any
3) now I have, and...
4) the query worked.
thanks for your help,
Emilio Pisanty
e-
> From: 3mip1s4la-Emilio Pisanty [mailto:emipisala@;lancaster.edu.mx]
> Sent: Sunday, 10 November 2002 11:34
> To: R. Hannes Niedner
> Cc: MySQL Mailinglist
> Subject: Re: little problem, I need some help...
>
>
>
> > > tables have met with a 1175 error ("You
On Sat, 2002-11-09 at 19:34, 3mip1s4la-Emilio Pisanty wrote:
>
> > > tables have met with a 1175 error ("You are using safe update mode and you
> > > tried to update a table without a WHERE that uses a KEY column").
> > Nothing is obvious and is hard to advise you if you don't give us some more
>
lt;[EMAIL PROTECTED]>
To: "R. Hannes Niedner" <[EMAIL PROTECTED]>
Cc: "MySQL Mailinglist" <[EMAIL PROTECTED]>
Sent: Sunday, November 10, 2002 12:34 AM
Subject: Re: little problem, I need some help...
>
> > > tables have met with a 1175 error (&quo
> > tables have met with a 1175 error ("You are using safe update mode and you
> > tried to update a table without a WHERE that uses a KEY column").
> Nothing is obvious and is hard to advise you if you don't give us some more
> info on the table structure and the update query you have trouble wi
On 11/9/02 3:14 PM, "3mip1s4la-Emilio Pisanty" <[EMAIL PROTECTED]>
wrote:
> hello everyone:
>
> to begin with, I apologise for asking a question which is probably
> obvious. My name is Emilio Pisanty and I and one of the two makers of my
> school's website. recently we updated the database system
hello everyone:
to begin with, I apologise for asking a question which is probably
obvious. My name is Emilio Pisanty and I and one of the two makers of my
school's website. recently we updated the database system (on mysql) from
version 3.23 to version 4. since then, any attmepts we've made t
sachin,
Friday, August 30, 2002, 10:30:47 AM, you wrote:
ss> Description:
[skip]
ss> I got this
ss> MySQL-3.23.52-1
ss> That means mysql is installed successfully.
ss> What is the step by step procedure for post
ss> Installation configuration of MySql server?
Check chapter "2.4 Post-install
From: root
To: [EMAIL PROTECTED]
Subject: I need some help in MySql installation
Description:
I tried to install MySQL,version :- MySQL-3.23.52-1
using RPM which I downloaded from mysql website. I
copied it in my root directory i.e. [root@FireWall2
/root]
My machine name is
I was wondering if anyone could help me converting some PostgreSQL
queries with sub-queries into a similar form usable (hopefully) by both,
or at least into a form that I can use in place of the PostgreSQL ones.
I'm going to post them - I hope no one minds. If this is the wrong
mailing list for
mysql must own the database directories.
chown -R mysql /var/lib/mysql
( or whatever the database directory is )
Mike Eggleston wrote:
> Folks,
>
> I know I am new here, and I really need your help. You see, the MySQL
> server is saying that it cannot find the host.frm file. Now, I can see i
Folks,
I know I am new here, and I really need your help. You see, the MySQL
server is saying that it cannot find the host.frm file. Now, I can see it
clear as day, and I think that I have the configurations correctly. However
I really am a programmer, not a server admin. Could someone out th
29 matches
Mail list logo