#mysql
16 October 2007
Total 19 pages. You are browsing page 1/19.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
--- Log opened Tue Oct 16 00:00:14 2007
--- Day changed Tue Oct 16 2007
00:00 <****> myfile
00:00 <****> verry complicated
00:01 <****> thanks!
00:02 <****> chadmaynard: lol
00:03 <****> I don't see his name in a google news search... I guess thats a good sign :)
00:03 <****> 2007-10-09 05:48:33 was the last messages I saw from the_wench.
00:04 <****> almost a week
00:05 <****> how come I get a syntax error on
00:05 <****> DROP TABLE *;
00:05 <****> honesttussey: because you can't do that
00:05 <****> what's the proper way
00:06 <****> if you want to drop all tables in a database, just drop the database and recreate it
00:06 <****> I can't
00:06 <****> I don't have those privs, I'm not root
00:06 <****> is there a way to find out what my privs are?
00:06 <****> show grants for current_user();
00:06 <****> ah. then do a "show tables" query and loop through that and issue drop statements for each table
00:07 <****> chadmaynard: current_user() is default for "SHOW GRANTS"
00:07 <****> i know
00:08 <****> ty
00:28 <****> Hello, I'm having some syntax trouble on a pretty simple query. Not sure what's up. Here's my query: "SELECT * FROM companies, auctions WHERE companies.is_auctioneer = '1' LEFT JOIN auctions ON companies.id = auctions.company_id;" Mysql says the error is at "LEFT JOIN"
00:29 <****> joins come before WHERE clause
00:30 <****> Ah, thanks
00:33 <****> RobotDeathSquad: and you should not quote integer values
00:33 <****> Thanks
00:39 <****> I have a table that has about 814,000 rows in it. One of the columns is indexed - it's a varchar(7). I have two queries that I'm comparing, they are identical except for the index value. One of them takes approx .1 seconds to run, the other takes approx 2.5 seconds to run. The value for the shorter one is '10036' and the value for the longer one is 'K1A0B1'...I've been trying to find some info about indecies and all numeric vs alphanumeric
00:41 <****> dave_mwi, it's faster on numeric indexes...
00:41 <****> always will be too
00:41 <****> so if the varchar value I"m searching for happens to be all numeric, then it's faster?
00:41 <****> vs a value that has alphas in it?
00:42 <****> shouldn't be
00:42 <****> run EXPLAIN on both queries
00:43 <****> hello everyone
00:43 <****> dave_mwi, this is covered in "high performance mysql" .. by jeremy zadownsky or whatever
00:43 <****> guys, what's the correct vale type to store -15224.01142 into mysql?
00:43 <****> i read his book, pretty easy read
00:43 <****> Tapout: ok...interesting.
00:43 <****> then it's something else I guess.
00:44 <****> dave_mwi: EXPLAIN both queries and see if the optimizer is doing something different
00:44 <****> ..
00:44 <****> ToeBee: right...testing
00:45 <****> Long? :)
00:46 <****> hmm. The explains are totally the same.
00:47 <****> odd
00:47 <****> dave_mwi: most indices are b-tree in mysql, you might be running into some odd corner case
00:48 <****> Toerkeium: considering Long is not a valid mysql data type... no :)
00:48 <****> lol ToeBee
00:48 <****> seekwill: hello.
00:48 <****> just trying to brings someone attention :P)
00:48 <****> heh
00:49 <****> double would be fine right?
00:49 <****> Toerkeium: is the . a decimal separator?
00:49 <****> probably... just keep in mind that float/doubles can introduce strange rounding errors
00:50 <****> hmm no, I am trying to store longitud and latitude
00:50 <****> decimal might be better if you need precision
00:50 <****> precision or accuracy?
00:51 <****> the I will try decimal, it should store the exact number
00:51 <****> otherwise people will go to the wrong place :)
00:51 <****> eh, found out what it was...
00:51 <****> thank you guys
00:51 * ToeBee wonders if this is why google maps always seems to have the errow about 200 feet off
00:51 <****> there was a function in the where...slowing it way down.
00:51 <****> very much
00:51 <****> lol ToeBee
00:59 <****> http://pastebin.ca/index.php < Anyone? no idea why it's giving error. It's sure its because of the long and lat fields
01:00 <****> sorry, it's http://pastebin.ca/738030
01:00 <****> Wrong link
01:00 <****> long is reserved word
01:01 <****> damn!
01:01 <****> quote it or change it
01:01 <****> changed
01:01 <****> lets ee
01:01 <****> see
01:07 <****> worked!
01:07 <****> beautifuL! :)
01:08 <****> thanks people
01:08 <****> very much
01:08 <****> how do you create your own database?
01:08 <****> create database name;
01:09 <****> mysqladmin create db
01:11 <****> thanks :)
01:23 <****> hi, Im reviewing a UML and DB modeling tool, I´ve googling but i want to know if you can recommend any tool
01:24 <****> Power Designer is a good but cpstly tool. I want to know your opinion on Visual Paradigm
01:24 <****> so to convert from 2007.10.12 to 12.10.2007 i must use DATE_FORMAT('2007.10.12','YYYY.MM.DD') right?
01:25 <****> ops...
01:25 <****> DATE_FORMAT('2007.10.12','DD.MM.YYYY')
01:26 * fulketerraun confused
01:28 <****> %m.%d.%Y
01:29 <****> it will be DATE_FORMAT('2007.10.12','%d.%m.%Y') i guess
01:30 <****> DATE_FORMAT('2007-10-12','%d.%m.%Y')
02:03 <****> ok, when I left join two tables onto one, I end up with every first joined table, joins all the third joined items, which ends up with a whole lot more information than I was looking for, is there a way I can join two tables with null values for missing items on the first and second joined tables instead of just the last joined tables?
02:04 <****> so if table3 has more items than table2, table 2 will pad in null items and stop running instead of finding the whole table3 set per every row in the result of table2 ?
02:05 <****> Xedecimal: you want grouping.
02:05 <****> if I group by table2, I'll end up missing items in table3 won't I?
02:05 <****> fulketerraun: consider using str_to_date() to convert your format to mysql format
02:06 <****> then date_format() to convert to your other format
02:06 <****> which matches this, I see: GET_FORMAT(DATE,'EUR') '%d.%m.%Y'
02:07 <****> DATE_FORMAT(STR_TO_DATE('2007-10-12',GET_FORMAT(DATE,'USA')),GET_FORMAT(DATE,'EUR'))
Total 19 pages. You are browsing page 1/19.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last