#mysql
07 November 2007
Total 24 pages. You are browsing page 1/24.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
--- Log opened Wed Nov 07 00:00:22 2007
00:00 <****> int is 32 bit
00:01 <****> brian over 4 million rows. Now wonder it takes some time. You could of course try loading the table into the memory...
00:03 <****> hi, I have a database with fields a,b,c,d,val can I print a query such that it would only list "val"s in four columns, one for each of four different values of d?
00:04 <****> 422,000 is a lil less than 4 mill
00:05 <****> /dev/lp0
00:05 <****> That'll print the query ;)
00:05 <****> sensei: I hope others have understood my questions
00:06 <****> I understood, I'm just overly tired and should probably be quiet for the rest of the evening
00:08 <****> is it the idea of views I am looking after?
00:20 <****> how do I select from 3 tables?
00:20 <****> inner join?
00:20 <****> left join can do that. probably many ways to do that
00:21 <****> g'day. I have a fairly simply sql query that checks to see if an email is valid or not. if the email address is invalid, it currently returns zero rows. is there some type of sql syntax that handles like IF/THEN so IF zero rows THEN return soemthing else? (has to be in sql, not a language such as php, etc)
00:21 <****> like, select foo from t1, bar from t2, fubar from t3
00:23 <****> joins: http://www.tizag.com/mysqlTutorial/mysqljoins.php
00:23 <****> falz: SELECT IF(count(0) = 0, 'No Match', 'Match') AS answer FROM table ........
00:24 <****> chadmaynard: awesome, let me test. thanks.
00:24 <****> hi I need help syncing a database
00:25 <****> I need to generate a dump based limited by time
00:25 <****> can someone help me with the syntax
00:26 <****> dump.sql -w `fecha`= NOW() -1 hour
00:26 <****> how can I get something like that
00:26 <****> basically it generates a dump of the new inserts that had happened in the last hour
00:27 <****> any idea how will the syntax be like?
00:29 <****> JZA: if your tables have a timestamp, that s indeed a possibility. add a where clause to the dump cmdline
00:29 <****> JZA: don't backtick-quote (`) as that'll mess with your cmdline interpreter
00:30 <****> ok I'll do a test
00:30 <****> is the syntax ok aside from that
00:30 <****> can it actually recognize 1hour
00:30 <****> 1minute
00:30 <****> NOW () - INTERVAL 1 HOUR
00:30 <****> would be the proper syntax
00:30 <****> ok thanks
00:31 <****> (NOW () - INTERVAL 1 HOUR) for keeping it more readable
00:31 <****> so
00:31 <****> (NOW() - INTERVAL 1 HOUR)
00:35 <****> http://gizmodo.com/gadgets/science/tesla-coils-playing-the-mario-bros-theme-are-unsurprisingly-awesome-319384.php
00:38 <****> arjenAU: is not working I got this, am I missing anything?
00:39 <****> That is awesome jeff-at-anl :)
00:39 <****> JZA: is taht a trick question?
00:39 <****> sql.sql
00:39 <****> JZA: yes, you didn't properly read what I wrote ;-)
00:40 <****> JZA: Do you actually have a timestamp column?
00:40 <****> hi kimseong
00:40 <****> `ts`
00:40 <****> sensei: his operator is wrong, that's all
00:40 <****> hi arjen
00:40 <****> Oki
00:40 <****> ToeBee!
00:41 <****> arjenAU: yes 'fecha' is a timestamp field
00:41 <****> rather than =
00:41 <****> mornin arjenAU
00:41 <****> chadmaynard: ?
00:41 <****> hi Shai_Tan
00:42 <****> ToeBee: what kind of OS doesn't come with telnet?
00:42 <****> an awesome OS?
00:43 <****> just "emerge netkit-telnetd" and be happy :p
00:43 <****> how foolish
00:44 <****> what is ts?
00:46 <****> JZA: your timestamp/datetime col, whatever its name is
00:46 <****> fecha
00:47 <****> chadmaynard: you don't want telnet these days
00:47 <****> sql.sql
00:50 <****> sensei: i know. i was floored
00:50 <****> heading home for the day. *poof*
00:50 <****> bye
00:52 <****> How can I list "select value from database where a='1'" and "select value from database where a='2'" as two columns of the same table?
00:52 <****> see UNION
00:52 <****> that'd make two rows
00:52 <****> ah, nm
00:52 <****> yeah
00:53 <****> sup arjenAU
00:53 <****> MrKeuner: clarify more about what you want to do
00:53 <****> morgan, quick as always ;-)
00:54 <****> arjenAU: yes i do
00:55 <****> chadmaynard: huh? do what
00:55 <****> chadmaynard: you don't want telnet these days
00:55 <****> ah
00:55 <****> no really, you don't ;-)
00:55 <****> arjenAU: I have a table a,b,c,d,value. a carries true/false. I would like to get a table of values for both values of a but as two separate columns
00:55 <****> chadmaynard: listen to arjenAU
00:55 <****> chadmaynard: except very very seldom to test basic connectivity to a port
00:55 <****> arjenAU: that's what i'm using it for.... smtp
00:56 <****> Same here..
00:56 <****> thumbs: i wasn't talking to you.
00:56 <****> When I was juvenile, I used to do telnet over ssl, just waiting for someone to come and state the obvious
00:57 <****> more juvenile* :)
00:57 <****> MrKeuner: SELECT IF(a,value,'') AS truecol,IF(NOT A,value,'') AS falsecol FROM ...
00:57 <****> sensei: that is fairly juvenile, yes
00:57 <****> sensei: now, handcrafting your ssl layer inside telnet, that'd be a feat ;-)
00:58 <****> lol that'd be overdoing it :) But indeed a feat
00:58 <****> probably needs rsh rather than telnet as there's too much foo inside telnet already
00:59 <****> No, had to be telnet so people could spot it ;)
00:59 <****> That'd be half the point.. people noticing it and pointing it out so you could inform them of your incredible overengineering adventures :)
01:00 * arjenAU sighs - give it up already
01:01 <****> That's half the point of intentionally overengineering stuff
01:01 <****> hey all, what character set should I be using? I am assuming an english one but little confused on what that is. myphpadmin account sets my tables to latin1 by default
01:03 <****> arjenAU: thank you. but I guess it only applies to true/false values of a. what if a had values 1 or 2?
01:03 <****> arjenAU: can I do IF(a='1',value,'')
Total 24 pages. You are browsing page 1/24.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last