RE: Trouble in unsubscribing
Hi all, there must be some kinds of technical difficulties as I'm also not able to unsubscribe at the moment. At 14:28 29.01.02 +, you wrote: >could you be subscribed under two (or more) email addresses? > >Peter > > > -Original Message- > > From: Yuxia Li [mailto:[EMAIL PROTECTED]] > > Sent: 29 January 2002 06:15 > > To: [EMAIL PROTECTED] > > Subject: Re: Trouble in unsubscribing > > > > > > > > Hi: > > > > Does anyone know how to unsubcrib from sql mailing list? I tried twice a > > few days ago but still getting emails. I even receieved a confirm which > > told me my email has been removed from the mysql list after I > > unsubcribed. My mail box can't stand for getting too many emails a day. > > > > Thanks a lot! > > > > helen > > > > > > > > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > >- >Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php urbia Grüße - best regards Tobias Kremer Webmaster / Software-Entwicklung urbia.com AG Hohe Str.115, 50667 Köln tel:+49 (0)221 - 2949 154 fax:+49 (0)221 - 2949 599 e-mail: [EMAIL PROTECTED] http://www.urbia.de - we are family http://www.urbia.fr - votre espace famille http://www.urbia.co.uk - the family site "Linux is like a wigwam. No gates, no windows but an apache inside" - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: selecting over various tables
At 15:52 28.01.02 +0100, you wrote: > > Your suggestion might work but I'm not sure if it's fast enough to be > > done "on-the-fly" (i.e. during a http user request) due to the fact that > > the tables are quite large and I have to "manually join" 10 tables :( > >I'd say that a UNION over 10 tables is a sure sign for a bad DB design. That's for sure. Fortunately it wasn't my idea but unfortunately I'm not able to convert it so I have to use workarounds for now :( >- >Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php urbia Grüße - best regards Tobias Kremer Webmaster / Software-Entwicklung urbia.com AG Hohe Str.115, 50667 Köln tel:+49 (0)221 - 2949 154 fax:+49 (0)221 - 2949 599 e-mail: [EMAIL PROTECTED] http://www.urbia.de - we are family http://www.urbia.fr - votre espace famille http://www.urbia.co.uk - the family site "Linux is like a wigwam. No gates, no windows but an apache inside" - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: selecting over various tables
Thanx, Roger. Harald was right: What I want to do is a UNION which is not implemented in mysql prior 4.0.0 :(( Your suggestion might work but I'm not sure if it's fast enough to be done "on-the-fly" (i.e. during a http user request) due to the fact that the tables are quite large and I have to "manually join" 10 tables :( At 15:04 28.01.02 +0100, you wrote: >* Tobias Kremer :: IT > > Thanx dn. I know how to build joined selects but the problem is that those > > two tables are not joinable. I don't have an entry in table 1 which > > references to a field in table 2. I just want to create a list of > > both tables ordered by date and limited to say 20 entries. > >I don't think it can be done with one statement in 3.23, but you can use >multiple statements and a temporary table: > >create temporary table tmp1 select * from table1; >insert into tmp1 select * from table2; >insert into tmp1 select * from table3; >select * from tmp1 order by date limit 20; > >-- >Roger urbia Grüße - best regards Tobias Kremer Webmaster / Software-Entwicklung urbia.com AG Hohe Str.115, 50667 Köln tel:+49 (0)221 - 2949 154 fax:+49 (0)221 - 2949 599 e-mail: [EMAIL PROTECTED] http://www.urbia.de - we are family http://www.urbia.fr - votre espace famille http://www.urbia.co.uk - the family site "Linux is like a wigwam. No gates, no windows but an apache inside" - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: selecting over various tables
Hi, Thanx dn. I know how to build joined selects but the problem is that those two tables are not joinable. I don't have an entry in table 1 which references to a field in table 2. I just want to create a list of both tables ordered by date and limited to say 20 entries. At 12:22 28.01.02 +, you wrote: >Hi Tobias, > >Assume I have various tables which all have these three fields: > >userid, title, date_created > >Now I want to create a list containing entries >of all tables ordered by date_created with a single select. > >Is this possible or do I have to make either various >selects or create an extra table which stores just this >information ? > > >=Yes it can be done in a single statement, eg > >SELECT * > FROM userid, title, date_created > WHERE -join the tables together- > ORDER BY date_created > >=This is quite a large/involved topic. If you are not familiar with SQL >and relational techniques then instead >of attempting to read it in an email msg, it would be better to check out >some of the introductory articles on >the various PHP-support sites (start with the links at PHP.net); or >getting hold of an introductory text book. > >=Establish the linkage/relationship between each pair of tables using a >'join'. >=Establish the sequence of the resultset by using the ORDER BY clause of a >SELECT statement. >=These are detailed in the online manual (which has a search facility). > >=Regards, >=dn urbia Grüße - best regards Tobias Kremer Webmaster / Software-Entwicklung urbia.com AG Hohe Str.115, 50667 Köln tel:+49 (0)221 - 2949 154 fax:+49 (0)221 - 2949 599 e-mail: [EMAIL PROTECTED] http://www.urbia.de - we are family http://www.urbia.fr - votre espace famille http://www.urbia.co.uk - the family site "Linux is like a wigwam. No gates, no windows but an apache inside" - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Table Lock
Hi Hayan, have a look at: http://www.mysql.com/doc/L/O/LOCK_TABLES.html for information on (un)locking tables. At 11:48 28.01.02 +0300, you wrote: >Hi, Is there a way to lock a table so that only one user can change it and >then unlockit? >I need to do this coz I want visitors to retrieve some values from a >database but each value must be retrieved only by one user and then marked >up to be expired, so I don't want two users to retrieve the same value >Any suggestions > >Best Regards >Hayan > > >- >Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php urbia Grüße - best regards Tobias Kremer Webmaster / Software-Entwicklung urbia.com AG Hohe Str.115, 50667 Köln tel:+49 (0)221 - 2949 154 fax:+49 (0)221 - 2949 599 e-mail: [EMAIL PROTECTED] http://www.urbia.de - we are family http://www.urbia.fr - votre espace famille http://www.urbia.co.uk - the family site "Linux is like a wigwam. No gates, no windows but an apache inside" - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
selecting over various tables
Hi list, Assume I have various tables which all have these three fields: userid, title, date_created Now I want to create a list containing entries of all tables ordered by date_created with a single select. Is this possible or do I have to make either various selects or create an extra table which stores just this information ? Thanx for your help! urbia Grüße - best regards Tobias Kremer Webmaster / Software-Entwicklung urbia.com AG Hohe Str.115, 50667 Köln tel:+49 (0)221 - 2949 154 fax:+49 (0)221 - 2949 599 e-mail: [EMAIL PROTECTED] http://www.urbia.de - we are family http://www.urbia.fr - votre espace famille http://www.urbia.co.uk - the family site "Linux is like a wigwam. No gates, no windows but an apache inside" - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php