Hot backup in mysql

2003-06-11 Thread alx
/ a software or any other kinda of information But there is something I don't understand: Mysql HOt Backup is a non-free solution Does it works onyl with InnoDB or also with MyIsam Can Someone suggest me some way to follow ? TIA Alx -- alx <[EMAIL PROTECTED]> -- MySQL General Mail

self foreign keys and InnoDB is it possible ?

2003-04-03 Thread alx
s are 1-2-4 \-5 3-6 and then I want to delete all child from a id that is their father. example deleting 3 has to delete 3 and 6 deleting 2 has to delete 2,4,5 deleting 1 has to delete 1,2,4,5 I hope this could be enough to explain my SQL problem... TIA ALx -- alx <[EMAIL PROTECTED]>

Re: Join Question

2003-03-27 Thread alx
how to normalize a table... can you suggest me some reads ? TIA ALx -- alx <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

[Fwd: InnoDB Foreign Keys]

2003-03-24 Thread alx
ION | | RESTRICT}] <--/ WHat are they? what's the use of them ? Thank you ! Alx --- End Message --- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

InnoDB Foreign Keys

2003-03-24 Thread alx
ICT}] <--/ WHat are they? what's the use of them ? Thank you ! Alx -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: auto_increment every year

2003-02-17 Thread alx
ple. > > You have written the following: > > HI all > I'm searching in how to generate a auto_increment number starting form 1 > every year > I mean > > ID DATE > 1 2003 > 2 2003 > > 1 2004 > 2 2004 > etc > maybe possible or I've to

how to get the Nth record of a result ?

2003-01-27 Thread alx
HI all I'm trying to get the Nth record of a query which i don't know nothing but the table name. I mean something like select * from table where . "give me the Nth result"; I hope someone can h