| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Comments:
<0> tiny 1 seater
<1> no, a 172 can hold 4 people. maybe not Americans, but normal-sized people.
<2> hahah
<0> i was thinking americans
<3> haha.
<4> I noticed that the benchmarks on mysql.com are from 2002 which means mysql4 right? are there any comparisons of 4 vs 5?
<1> well, let me clarify: there are 4 seats in a Cessna 172. how big your *** is, is not the airplane designer's concern.
<3> So the network is not the bottleneck in my cluster here.
<2> Frb i wouldn't doubt they used mysql 3
<2> i think in 2002 mysql 4 was still in beta
<4> the other part that bothers me is that mysql was run on a Sun, while everything else was run on PCs
<5> Madsret: A number of the buffer and cache variables are helpful. I think there's a tuning doc up on mysql's site as well
<2> frb: it doesn't really matter anyhow. There are two kinds of lies. Statistics and Benchmarks.
<4> well, I can't just flip a coin and pick a DB
<2> what is the criteria that needs to be met?
<4> so many variables right now
<4> we are upgrading our web dev platofm
<4> err platform
<2> to what?
<2> i use mysql for web dev all the time
<2> and i must tell you, it's never let me down, and it's very fast.
<4> I need to gather information on php5, mysql5, .net, mssql, apache, iis, windows, linux, and interactions thereof
<2> i wouldn't use mssql
<2> i hate it :(
<4> most if not all people on this channel would say that
<2> most if not all people who've used it would say that
<2> db2 is a good option though frb
<5> frb: lots and lots of testing in your own environment against your own sample code is really the only way to get an accurate picture.
<4> I don't know enough about anything
<2> if you need something more robust thatn mysql. But that seems unlikely.
<4> I don't think performance will really be a factor for us too much
<2> so what are the factors?
<4> but numbers look good when presenting to managers
<5> frb: it is or it isn't. Perhaps you need to decide that first?
<4> development time, integration, ease of administration
<2> what looks really good to managers is when you switch over and everything works.
<4> right now our env is Win2k+IIS5+ASP3+SQL2k
<6> Hello.
<6> What's wrong with SELECT * FROM some_table ORDER BY a_binary_field ?
<4> needless to say, it's outdated, and frustrating to work with
<5> !tell us about what's wrong
<7> inviso asked me to tell you this: Don't ask us "What's wrong with this query...". We are not SQL parsers. We do not care to look character by character looking for errors when MySQL will tell all of us WHERE the error is. Paste the FULL error issued by MySQL.
<4> nitishp, #sql for that one
<2> frb: omg, you poor guy.
<6> frb: Okey doke.
<4> now, in the next week, we are going to decide on what to upgrade to
<5> nitishp: here is fine. We just need more info
<2> nitishp: that syntax looks correct to me.
<2> nitishp: what error are you getting?
<6> It tells me to check my manual..
<4> does .net work well with mysql?
<6> It doesn't even print out an error.
<6> It just says there is an error with it.
<5> nitishp: paste the *full error please
<6> Gah, it's like a two liner, mind if I dump it here?
<5> nitishp: go ahead
<6> Alright cool :)
<6> You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'relation' at line 1
<6> relation is a binary field.
<0> reserved word
<6> Ah, alright, that explains it.
<6> Thanks :)
<2> you can use `'s around it if you want
<2> but i'd choose a diff field name personally.
<6> Wow, I changed the field to be "affiliation" and I still get the same error as before except s/relation/affiliation/
<2> can you paste your sql query you're using instead of what you think it looks like?
<6> SELECT * FROM roster ORDER BY affiliation DESC
<6> affiliation is a binary field.
<2> the syntax seems correct to me
<2> paste the error?
<6> You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'affiliation DESC' at line 1
<5> nitishp: and if you pick a different field, does it work correctly?
<6> It was originally relation remember? I already changed it and it doesn't work.
<6> I'll change it again if you think that'll do anything.
<5> nitishp: I mean a different column
<6> Oh yeah, it works fine otherwise.
<5> version of mysql?
<6> 5.0.9 version 6.3 says the man page.
<5> nitishp: select version();
<5> nitishp: also, please paste a query that does actually execute. (Ie, no syntax error)
<6> inviso: It is 5.0.9 beta. As for a query that works: SELECT * FROM roster ORDER BY lastName
<5> nitishp: there's a chance that you're dealing with a bug that has since been fixed
<6> inviso: Gah, what would this bug be?
<6> binary field sorting doesn't work?
<5> nitishp: just guessing. It's an older version and a beta to boot. Bugs get fixed. try a search on bugs.mysql.com against your version or perhaps a couple minor versions older
<6> Okey doke, thanks :)
<8> In MySQL I'm having trouble effectively + efficiently matching columns against inclusive/exclusive values. I'm hoping to find some relevant documentation online (a book maybe?) that could help me deal with this. I've outlined the issue @ http://www.iceburg.net/bmail/index.php/Mysql under 'troubles'
<9> SELECT bolted_users.usr_name, bolted_users_online.usr_id, bolted_users_online.usr_login, bolted_users_online.usr_lastactive FROM bolted_users INNER JOIN bolted_users_online ON bolted_users_online.usr_id = bolted_users.usr_id ....... wrong?
<1> !tell eml about whats wrong
<7> Alrighty.
<9> sorry
<9> wups
<9> seems like the error is in php o.o
<1> it usually is.
<9> yeah, I have to use mysql more
<9> sorry
<8> can anyone take a seond to look over my troubles @ http://www.iceburg.net/bmail/index.php/Mysql ?
<10> hello. I'm trying to get a response from mysql.com. The Guy I keep speaking to seems very clueless on my question
<10> maybe someone here has information on what I need to do. I've a commercial app(not opensource), and a BSD licensed mysql tcp/ip client library. I need to know how I must include the source for mysql server. Do I need to package it with the CD installer, or is a simple link to the mysql website sufficient?
<11> hi
<11> it's probably a faq, but searching for this thing isn't as easy as I thought... how can I select records that have modified(timestamp) field set to more than 1 hour ago?
<1> WHERE modified < DATE_SUB(NOW(),INTERVAL 1 HOUR)
<9> ALTER TABLE `bolted_users_online` DROP UNIQUE(`usr_login`); well, is this not the right syntax for droping the unique property?
<11> thank infi
<11> thanks even ;)
<1> tvset: make sure it works
<1> eml: perhaps you want DROP INDEX
<11> infi: it works like a charm ;)
<1> enjoy
<9> well infi, I'm inserting a date... Invalid query: Duplicate entry '2006-02-25' for key 1 Whole query: INSERT INTO `bolted_users_online` (`usr_id`, `usr_login`, `usr_lastactive`) VALUES('3', '06:02:25', '02:49:25')
<1> uh, it's converting the time you are attempting to p*** into usr_login into a date, which is apparently part of a unique key. the problem isn't the key, it appears to be your understanding of column types.
<12> does anyone know how to join to a mysql
<1> what column type is usr_login?
<12> i.e what does one have to type in the xterminal
<1> sharmaa: ECANNOTPARSE
<12> mysql -h not sure anyone know
<1> sharmaa: do you mean "connect to a mysql database server" perhaps ?
<12> yes
<12> like the syntax
<1> mysql [-u USER] [-h HOST] [-p[P***WORD]] [DATABASE]
<1> things in [] are optional. but you probably want -u, -h, and -p
<10> sharmaa: its "connect" to a mysql server, not join
<10> some german guy who spent his vacation here in Alaska told me, "your lights were burning". I thought it was the funniest thing. I told him, the car turns them off for me after 10 minutes. He was astonished
<12> hm
<13> Is the Exists subquery supported in 4.0?
<13> I have been trolling the changelogs and have not found it yet
<10> vuud: trolling? :P
<10> grepping :)
<13> searching :)
<10> vuud: doesn't sound nerdy enough
<13> "optically scanning"?
<10> :D
<1> ogrep
<14> you could say perusing
<14> and then someone would try to correct you because they dont know the proper definition of peruse
<1> OptiGrep(tm) v3.0, the Visual Scanning Utility
<14> thus you could be both nerdy and pedantic concomitantly
<12> hm it still doesnt connect for some reason
<1> hansbrix: what might someone confuse "peruse" for?
<10> infi: sounds like mysql ab's idiodic interpretation of the GPL
<1> sharmaa: paste the exact error message
<14> infi: most people think peruse means to briefly scan
<14> or to succinctly look over
<1> oh. well, that's their problem ;)
<14> indeed
<13> select * from MISC where not exists (select * from USERS where USERS.UID = MISC.UID);
<13> Okay, then thats the statements that screwing me... does it look right?
<13> I've been thinking maybe its not supported in 4.0.20...
<1> subselects didn't work until 4.1 (I believe)
Return to
#mysql
or
Go to some related
logs:
#fedora
/etc/sudoers: + centos
#perl
#ubuntu
#linuxhelp
vim7 perl
ubuntu totem-xine opendivx
skype frugalware
saa7134 no picture mythtv
SQL temporary table subtable mysql
|
|