unscribe
-- Dwayne Hottinger Network Administrator Harrisonburg City Public Schools -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
unscribe
Quoting Richard Lynch <[EMAIL PROTECTED]>: > On Wed, November 9, 2005 11:05 am, Chris W wrote: > > Richard Lynch wrote: > > > >>On Sun, November 6, 2005 2:17 am, Chris W wrote: > >> > >> > >>>I just tried to use the output of the export function on phpmyadmin > >>>and > >>>got a million errors. After looking at the file I found that > >>> certain > >>>columns that are strings were not quoted at all. I can't find any > >>>reason why some are and some are not quoted. Anyone have any idea > >>> why > >>>this is happening? > >>> > >>> > >> > >>Because unless a field contains a ',' or '"' character, it doesn't > >>NEED quotes to delineate it: > >> > >>1,test,3 > >>1,"I said,""It's not the same""",3 > >> > >>is the same thing as: > >>1,"test",3 > >>1,"I said,""It's not the same""",3 > >> > >>Your import function is BROKEN in a major way, by requiring quotes > >>where they are not strictly necessary to conform to the CSV > >>specification. > >> > >>That said, it's probably easier to get phpMyAdmin to always quote the > >>output than it is to fix whatever broken import tool you are using. > >> > >> > >> > > The program I am using to import the data is the MySQL tools. They > > don't like the output of phpMyAdmin 2.6.1-rc1. And I don't have any > > control over the server so I can't upgrade the version either. Unless > > I > > find a work around, I'm SOL > > You could probably import into something smart enough to handle the > missing quotes, then export with a setting that always quotes. > > I believe Excel (gak!) would do this correctly. > > PHP's http://php.net/fgetcsv might do the right thing, and you could > write out the CSV any which way you want... Or, at that point, just > write an INSERT query. > > Which route to take depends how big the file is, and how often you > have to do this and what tools you are familiar with. > > -- > Like Music? > http://l-i-e.com/artists.htm > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- Dwayne Hottinger Network Administrator Harrisonburg City Public Schools -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
unscribe
please,remove my email from your database __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
unscribe
--- Roger Baklund <[EMAIL PROTECTED]> wrote: > * Robert Kilroy > > I've been trying to work out a query for this > project > > and I'm finally at the end of my rope. Basically, > I > > have a ticket sales app. There is a table that has > > row_num and seat_num and seat_status. What I need > to > > do is retrieve X number of seats that are > sequential. > > For example, if someone requests 4 seats, and > seats 1 > > and 2 are sold, he would get seats 3, 4, 5, 6. Or > if > > seats 5, 6 are sold he would get 7, 8, 9, 10. > > Try a grouped self join: > > SELECT t1.row_num,t1.seat_num,COUNT(t2.seat_num)+1 > AS "seats" > FROM theater t1 > LEFT JOIN theater t2 ON > t2.row_num = t1.row_num AND > t1.seat_num < t2.seat_num AND > t2.seat_num < t1.seat_num + 4 AND > t2.seat_status="free" > WHERE > t1.seat_status="free" > GROUP BY > t1.row_num,t1.seat_num > HAVING > seats = 4; > > This example finds 4 seats, both occurences of the > digit "4" in the above > query needs to be dynamic, and changed to whatever > number of seats you want > to find. You can also find seats "in the back" or > "in the front" by adding a > check in the WHERE clause on t1.row_num larger or > smaller than whatever is > the middle seat row in the theatre. > > Explanation of the query: First we read all free > seats > (t1.seat_status="free"), then we join to the same > table, finding all free > seats on the same row (t2.row_num = t1.row_num), > with a higher seat number > (t1.seat_num < t2.seat_num), but smaller than the > current seat from t1 + 4 > (t2.seat_num < t1.seat_num + 4 ), because we want to > find 4 seats. > > The counter is one off, because we don't count the > first seat from t1, that > is why you need to add 1 to the COUNT(). > > Then we use GROUP BY to get one result row per seat, > and finally HAVING to > select only the free seats with 3 free seats next to > it. > > HTH, > > -- > Roger > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
unscribe
-Messaggio originale- Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Inviato: mercoledì 20 novembre 2002 21.51 A: [EMAIL PROTECTED] Oggetto: Re: unscribe Your message cannot be posted to [EMAIL PROTECTED] because it did not follow the format expected by our spam/off-topic filter. To this list we accept only repeatable bugs reports, meaning that you can describe a set of steps we can follow to repeat the bug on our systems. If you are having problems with MySQL but are unable to provide the required description, and have not purchased a support contract from MySQL AB, you should send your message to [EMAIL PROTECTED] and possibly one of our knowledgable users or developers will help you. However, we do not guarantee that every message on [EMAIL PROTECTED] will be answered. We can afford to provide free code, but unfortunately, we cannot afford to provide guaranteed free support on top of that. We do, nevertheless, fix our bugs regardless of who reports them and whose systems they affect, and will investigate your problem if you can prove to us with a test case that the error is in our code and not yours. If you have purchased a support contract from MySQL AB, you should follow the standard support request procedure to report this problem. Support contracts are available at https://order.mysql.com/. If you are able to describe how we can repeat the problem, include the string "How-To-Repeat:" in the body of your message, followed by the detailed description of what we need to do to make it happen, and our filter will accept your message. If you use mysqlbug script, which comes with the MySQL distribution, to post the message, it will be automatically accepted. You have written the following: ---start of your message Ing. Stefano Scattini P.zza Sauro 4d 20030 Giussano (MI) 335 7070893 __ Tiscali ADSL. Scopri la fantastica promozione di Natale: tutto Gratis fin= o al 9 gennaio! Abbonati ora: prima ti abboni, pi=F9 risparmi! http://point.tiscali.it/adsl/index.shtml ---end of your message--- MySQL Development Team - 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
MySQL,sql my unscribe info appears in mail
database,sql,query,table > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > database,sql,query,table > > If you just reply to this message, and include the entire text of it in > the reply, your reply will go through. However, you should > first review the text of the message to make sure it has something to > do with MySQL. Just typing the word MySQL once will be sufficient, for > example. > > You have written the following: > > Is it my mail program or the list program. > But when I reply to mail "MY" unsubscribe information appears. > > David - 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
