| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9
Comments:
<0> !m DogWater date functions
<1> DogWater: (Year 2000 Compliance) : http://dev.mysql.com/doc/mysql/en/Year_2000_compliance.html
<0> err no
<0> arg
<2> what are the mysql-bins? in the directory of the data of mysql?
<3> which mysql
<2> 5?
<3> type it on a shell
<3> which is a linux command
<3> to show you the path to the binary
<4> frank- its something to do with to_date i know how to do it in mysql5
<0> DogWater: ah
<4> err to_days
<0> I would read the docs, to be honest
<0> they will give you the syntaxt
<2> ehm...it has sql inside those files
<4> i just wanna say like select * from table where date 7 days ago
<4> or whatever
<4> no idea huh
<5> anyone know what the scope of LAST_INSERT_ID() is? Is it per-connection? per-database? per mysql instance? If it's by connection that's fine...anything more general than that is a race condition from hell
<4> oh, i guess it would be within the last week
<4> within the last 7 days,
<4> hmm
<4> i wonder if it can even do that
<2> I will compile mysql5 again, should I use the --with-pthread ? or not?
<5> DogWater: what base language? Not sure you can do it in sql. In java (say) I'd create a date string that represented a week ago and ask for dates > that
<5> ah, you can do it in sql
<5> try something like:
<5> select * from sometable where date_field between ((now()-interval 7 day) and now());
<5> the syntax might be a little off there, needs some testing
<2> bye bye and thank you !
<6> _m6s_: yes
<6> ***uming your OS supports pthreads
<7> Hi there
<0> hi
<0> who's there?
<6> nobody here but us chickens
<0> Darien: hah
<4> SELECT id FROM things -> WHERE DATE_SUB(CURDATE(),INTERVAL 7 DAY) <= date
<4> anyone see an issue there?
<0> no
<6> nope
<6> other than the ->
<6> but I ***ume that's from a newline in the MySQL command-line client
<7> perhaps date?
<7> Date is a restricted word in mysql.. it's a data type
<0> right
<8> is it possible to rename a database in mysql without copying all the tables to a new one and deleting the old one?
<6> dude
<6> if you have an error next time,, paste it
<6> don't post SQL and say 'is there a problem with this?' because if there is, why are you asking, and if not, why aren't you using it?
<0> !m optimism_ rename mysql database
<1> optimism_: Nothing found
<0> !m optimism_ rename database
<1> optimism_: Nothing found
<0> arg
<8> :D
<8> alter database doesnt allow you to rename it like alter table does :(
<0> I never attempted that
<9> it seems an odd thing to try to do :P
<8> im restoring some backups and i spelled the db name wrong. occurred to me i have no idea how to rename an entire database
<9> apparently you need to stop mysqld before you can rename the database
<4> Hmm, if you have an item in a table that was created today, and you run 7 queries on it one for 7 14 30 60 90 180 and 360 and they all return for that query i pasted above anyone know whats wrong with that, lol?
<7> I don't think that's possible.. could have disasterous effects it if was
<8> easy enough just to wipe it and re-restore the backup, but surely there is a way
<9> i guess you just change the directory name while mysqld is stopped or something
<8> andrewbryson: that would mess up the privileges table though?
<9> i have no idea how old is the help i am reading though
<9> no idea sorry
<8> meh ill wipe it
<4> I'm just trying to count how many rows fit into each category
<9> well you might as well try renaming it first :P
<4> 7, 14, 30, 60, 90, 180, 360 days old
<9> ok have found a more in depth page
<9> it says do that, then check the grants
<8> eugh
<8> ty :)
<9> can you detach a database with mysql ?
<4> oh; I guess thats accurate if i have one that i created today it would
<4> show up in all of them
<4> lol
<4> im a dumb***
<9> that might be a preferable solution to stopping the server
<8> its ok, its all fixed now :)
<9> cool :P
<0> optimism_: great
<8> apart from the horrible php warnings you get when moving from one platform to another :P
<0> optimism_: well the win32 platform is horrible
<0> so the warnings are quite accurate
<8> oh gods not more trolls please :P
<0> hehe
<8> actually i just moved *from* a windows platform and *now* im getting warnings :P
<8> so much for linux being the whole superior operating system and all that crap ;)
<0> huh
<9> probably php for windows was just not warning you about the broken things
<0> a unix server will force you to be more rigorous
<9> at least now you know :P
<9> yup
<8> indeed
<0> your code is most likely full of bugs
<0> :P
<8> but relax, cos im not a complete windows fanboy
<8> my code, bugs :O get out! :P
<8> just some lame timezone warnings is all
<0> hehe
<0> I am not trolling
<9> whyever not ?
<9> :P
<8> im just messing with you ;)
<8> i get enough trolling at uni
<8> there we go, simple phpini hack and were done
<0> you see
<0> it's so easy in unix
<9> "hack" is never a good word to use when working with production systems
<0> couple changes restart deamon, done.
<9> or just sighup the daemon :P
<8> frank-: yet under win32 it didnt even need restarting :P
<9> why restart unless it is necessary ? :P
<8> though thats an unfair comparison
<9> under windows it did not complain about the errors in the first place
<9> if it was me, i would rather know about them :P
<8> to be fair thats due to a different architecture regarding timestamps under win32
<8> there is no problem until you move the code to nix
<0> actually
<0> you can code cross platform code as far as dates and timestamps are concerned
<0> it just takes a little more effort
<8> i know :)
<0> knowing this
<0> I got around 10 bugs/warnings in my php site I should fix
<8> sounds like i missed somethign fun
<9> it does doesn't it ?
<10> hi! is there any query to get a column in a database, but skip those values I already have? eg. I have a column containing "foo", "bar" & "foo" then I want the query to contain "foo" & "bar". Just return one of multiple entries
<8> distinct?
<0> distinct would do that
<9> yup certainly would
<10> thanx, will read about that!
<8> select distinct from blah where blah;
<10> ok... thanx
<9> you might want to put a blah after the distinct too :P
<10> :P
<8> indeed yes :P
<8> long time since i wrote a select query actually
<9> it is ?
<8> indeed
<9> hell i have to write them every day :(
<8> heh
<8> last time i wrote sql was when i was writing my sql-writer :P
<9> oh cunning
<8> which was like back in october or something _
<10> what blah would i put after distinct if I want all rows, but only one of those with multiple entries?
Return to
#mysql
or
Go to some related
logs:
#perl
#centos
dapper snes
compiling dillo on ubuntu fltk error
#css
#perl
chicken/cider
gam-server umount
e2e5e0bfb2edffd2ce02dd77bda4558e
#php
|
|