#mysql
01 November 2007
Total 22 pages. You are browsing page 22/22.
First :: Prev :: [...] [18] [19] [20] [21] [22] :: Next :: Last
22:57 <****> jbalint I have a field named "data"
22:57 <****> but when I query SELECT DATE_FORMAT(dd,'%d/%m/%Y'),* FROM table
22:57 <****> it returns and error
22:57 <****> sorry
22:57 <****> but when I query SELECT DATE_FORMAT(data,'%d/%m/%Y'),* FROM table
22:57 <****> use `
22:57 <****> to quote it
22:57 <****> hmm
22:57 <****> thanks
22:58 <****> is data a reserved word?
22:58 <****> I guess
22:58 <****> cause I dont see any other error on query
22:58 <****> no
22:58 <****> pastebin the error
22:58 <****> unless your table is actually called "table"?
22:58 <****> rafb.net/paste
22:58 <****> no
23:00 <****> jbalint http://pastebin.com/d7c20256
23:00 <****> dkr: thanks :)
23:01 <****> jbalint I got it I need to specify all the fields I need on query
23:01 <****> nooneelse: looks like you have to put the * first
23:01 <****> really ?
23:01 <****> lemme try it too
23:02 <****> jbalint yeah it worked too, thanks man
23:06 <****> anyone know if/when mysql will support indexes on expressions -- like LOWER(column)
23:11 <****> say I have 20 million entries that I want to index (website visitors) -- can anyone outline what the recommended table setup would be for something like that ? It's just a single column in one table, so is there a benefit of using myisam over innodb for this (or vice-versa) ? Pretty straight forward, but any performance increase would help.
23:13 <****> hi
23:13 <****> where to activate mysql??
23:13 <****> sorry
23:13 <****> where to activate innodb?
23:20 <****> how do you guys recommend i install mysql on mac os x 10.5?
23:20 <****> mac ports etc or just the other instant install one?
23:21 <****> anathematic, I always use the MySQL installer from mysql.com
23:21 <****> has never failed me.
23:21 <****> yeah sure why not i'll do that =)
23:21 <****> you use apple for servers?
23:21 <****> I upgraded from Tiger to Leapord and my old installation works
23:21 <****> dkr: na it's just my development server
23:22 <****> dkr, I use Mac all the time so its nice to have a local copy running :)
23:22 <****> acidity: ahh okay then i was just under the influence it didn't work under leapoard
23:22 <****> instant install here i come then! wwhew~
23:22 <****> Bah
23:22 <****> "under the influence" is a term for being on drugs or drunk, :)
23:22 <****> Is there any way to start logging for the server or for an individual user or something, without restarting the sql server?
23:23 <****> dkr: this is true in most other contexts ;)
23:23 <****> does redbull count?
23:23 <****> anathematic, the only problem i had that my apache was not working and it turned out that Leapord upgrade didng copy the Apache config from Tiger. There was a blog post that told exact steps to fix it. So till now, no problems at all :)
23:23 <****> and friday fever!
23:23 <****> you were probably just under the impression, :)
23:23 <****> <3 for the english lesson
23:23 <****> dan__t, do you mean MS SQL Server when you say SQL Server?
23:24 <****> yeha that's what i was talking about acidity, i'll google the fix now
23:24 <****> dan__t, if its MySQL then I dont think you can do it. These are mysqld options so you will need to restart
23:24 <****> anathematic, too bad I am not at home. Its bookmarked up there. I would have given you the link.
23:25 <****> I need to figure out to manage my bookmarks between home and school :)
23:25 <****> acidity: yeah i was just going to write a system tonight actually for me to look at my bookmarks from my domain anywhere haha
23:25 <****> and then just upload html files to it
23:26 <****> No, I mean MySQL. We're in #mysql. I know better than to ask about MSSQL in here ;)
23:26 <****> Well, that's a drag.
23:28 <****> dan__t, hahahahahaha....you will be surprised that there are many people otherwise :) But I hope that answered your question.
23:28 <****> haha
23:28 <****> it did, thanks.
23:36 <****> I have a small issue i was wondering if i can get some help with.
23:36 <****> ask first
23:36 <****> in a table i have passwords in plain text
23:36 <****> i was given: UPDATE `Profiles` SET password = MD5("password")
23:36 <****> to set them as md5
23:37 <****> well, it set them as md5.. but every password is now 'password'
23:37 <****> well that IS what you told it to do :p
23:37 <****> i can fix that back to the original 'plain text passes'
23:37 <****> what could i use to set their own password as 'their pass in md5'
23:37 <****> column names are either not enclosed with anything or with `
23:38 <****> what do you mean? i dont really understand that too much.
23:38 <****> you put " around it which turned it into a string literal
23:38 <****> oh
23:39 <****> Interex set password=md5(password)
23:39 <****> I'll give that a shot
23:39 <****> no ""
23:40 <****> Trengo: ok I will try this in just a few minutes.
23:40 <****> if i re-import the table again will it overwrite the existing table?
23:40 <****> Interex i dont know, what are you talking abou?
23:41 <****> I exported the table before running the SQL command that broke the passwords.
23:41 <****> if i 'import' it will it set it back to before it broke it or should i drop the table then import it?
23:42 <****> depends on how you exported it
23:42 <****> #1062 - Duplicate entry '1' for key 1
23:44 <****> i'll empty the table and just import what i saved.
23:46 <****> ok so it isnt case sensetive is it?
23:46 <****> cause in the .sql it shows Password, and the execute string says password
23:50 <****> Interex, nope. Its not. Its a mysql built in function.
23:50 <****> ok.
23:52 <****> i've got a table name, value, date how can i find the value for a particular name where the date is the highest before today
23:58 <****> mmm anyone else having problem starting mysql on leopard using the system pref interface?
23:58 <****> (mine keeps locking up)
23:59 <****> uhh
23:59 <****> i think ive herad of some issues with that
23:59 <****> ToeBee, and Trengo: thanks a lot login fixed :)
--- Log closed Fri Nov 02 00:00:02 2007
Total 22 pages. You are browsing page 22/22.
First :: Prev :: [...] [18] [19] [20] [21] [22] :: Next :: Last