| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Comments:
<0> ok, so how can I do something like SELECT foo from bar WHERE StartTime >= NOW() - 24 hours ? Starttime is a datatime data type of format 0000-00-00 00:00:00
<0> ***id: maybe becouse CURRENT_TIMESTAMP is date + time and DATE is just date
<1> doesnt matter. eventually its a function
<1> you can try DATE_SUB
<2> Isn't it possible to INSERT INTO table1 SELECT something with subquery from same table1 . Is it?
<2> I got "can't reopen table" . I can somehow rephrase query ?
<3> YazzY: select foo from bar where starttime > = date_sub(now(), INTERVAL 24 HOUR);
<1> mlt: fix thetable
<2> ***id: what ?
<1> repair table tablename
<2> Table has ENGINE=MEMORY
<3> I don't think you can do INSERT ... SELECT on same table
<4> How can I get he size of a table?
<5> mlt: Your select blocks the insert.
<2> so.. I am to use another temporary inmemory table ?
<5> mlt: I'm only guessing here but try SQL_BUFFER_RESULT or use an intermediary table (temporary)
<0> shabbs: this will include dates from one day back and days from today and i only want to list dates from one day back in time
<2> I'am tired with temporary tables...:(
<0> shabbs: basically i need to check when user has loged in and select that user if it was more than 24 hours ago
<0> exclusive today
<3> YazzY: select foo from bar where starttime >= date_sub(now(), INTERVAL 24 HOUR) AND starttime <= NOW();
<3> or
<3> YazzY: select foo from bar where starttime >= date_sub(now(), INTERVAL 24 HOUR) AND starttime < DATE(NOW());
<0> thanks a lot!
<0> omg it was so simple
<0> ah no fsck
<0> it still shows todays date
<6> hey ppl by mistake i have DROP the mysql db, how can i rebulid it ?
<7> uh
<8> From your backups
<3> did you do the 2nd one? with < date(NOW()) instead of
<0> < DATE(NOW()) worked
<7> restore from backup :)
<3> yeah
<0> shabbs: :))
<0> yes sir
<6> infi dont have any
<6> :(
<3> SOL
<7> well, today you have learned a lesson.
<0> shabbs: remind me to buy you a beer when you see YazzY written on someone's chest
<6> lool ...
<7> at least you won't ask us how to reorder your auto_increment column, now
<3> YazzY: cheers, will do :)
<0> shabbs: thanks again, you made my day
<2> \me wants MySQL 5 backport for Debian Sarge ....
<0> mlt: FreeBSD has had MySQL 5 in ports for quite some time now
<0> or create your own .deb
<2> Is migration painless? Btw.. I would be on my own regarding security updates
<2> I can't give up on security updates
<7> for large vendor-maintained applications like MySQL, I generally prefer to use the vendor's distros. reason: you get more frequent updates and don't have to rely upon your distro author to make new ones
<7> of course, if you don't do it from the start, you may/most likely will have to reorganize a bit.
<2> infi: I don't want to do offten apt-get -b source mysql-server from experimental or smthng by myself...
<3> which is why you should get binaries from mysql.com
<2> shabbs: Are there any way to "autoget" those binaries in the case of security updates?
<2> I think no
<3> not that I know of
<9> postgresql > mysql
<7> heh
<3> appreciate your opinion
<9> everytime i try to type in myspace .. i end up typing mysql
<7> that's because MySQL AB teamed up with several keyboard manufacturers to occasionally and transparently replace it in your keystream
<10> hi.
<10> sorry, i asked this before, but i can't remember the answer - should InnoDB logfiles and relay log files be on "forcedirectio" filesystems, like innodb data? (no read caching)
<3> I type mysql instead of myself
<9> i think they infiltrated some of my cells
<6> whery can i make the download of the original mysql db ?
<7> 1.0?
<6> i have found already
<7> did you really want 1.0?
<6> just loooking the dir to put it
<11> select * from users where zipcode in ('05032','05033');
<11> whats wrong with taht in?
<10> what does mysql say is wrong with it?
<11> error in syntax
<11> near that :)
<10> near what?
<10> paste the entire exact error
<3> and your entire query too
<7> and your credit card number
<12> and your family
<7> only if your mom is a MILF though
<12> or if she has three breasts..
<12> god i'm bored..
<6> fix it
<2> bb
<6> ERROR 1036 (HY000): Table 'user' is read only
<6> what can i do to change this ?
<6> grrr
<3> change permissions possibly
<6> chmod 666
<6> right
<7> 644 would probably be wiser, or 664 at most
<7> especially on your permissions tables ;)
<6> humm yehh you right
<13> Anyone familiar with Access/ODBC and MySQL? My InnoDB table values are all #deleted
<7> !perror 1036
<7> does SQL only respond to certain users?
<14> gv
<13> Anyone familiar with this problem?
<15> sql has been known to hang
<16> !m Johnny23|work error 1036
<17> Johnny23|work: Nothing found
<16> heh
<7> SummerWo: http://dev.mysql.com/doc/refman/5.0/en/msaccess.html, 23.1.11.5 might be relevant
<3> no, it won't give an answer to !perror 1036 cuz it can't find that error
<3> !perror 14
<17> System error: 14 = Bad address
<3> !perror 1036
<3> see? :)
<7> !perror 1035
<7> oh.
<7> it's actually perror(3), heh
<7> I thought it searched the mysql error number reference for its values
<18> )
<3> !perror 3
<17> System error: 3 = No such process
<7> !perror 0
<17> System error: 0 = Success
<7> heh
<7> my favorite
<19> hey all
<13> thanks infi
<13> I tried those instructions before posting here, to no avail.
<19> my eyes have already gl***ed over... anyone see any syntax problems in this: SELECT * FROM news WHERE (published LIKE '2006%') LIMIT 5 ORDER BY published DESC
<19> fyi: published is a datetime
<3> what's the error?
<19> syntax error is all i get
<3> should give you at least where the syntax error is
<15> like is a text comparison
<3> oh yeah
<3> you could try something like WHERE year(published) = 2006
<15> year(published) = 2006
<3> or even better: year(published) = year(now)
<3> year(now())
<3> rather
<7> summerwo, what column type are the offending fields?
<13> All fields in one table are #deleted .. two are bigint, four enum(), two varchar, and one timestamp to follow those directions
<20> hi
<19> okay... as long as I've been using MySQL and I never knew that the order you enter commands in is picky... the problem was that the limit was before the order by...
<20> can you advice me some method of implementing quotas in mysql 4.1 . also some other limits
<20> like connection limits
<19> I guess I just always happened to put everything in the proper order without knowing it, until now that is
<20> i would like to set some limits per database
<13> infi: you've seen this before? it's frustrating!
<7> I have, but I don't really use that configuration very often
<20> i need it for m***-hosting
Return to
#mysql
or
Go to some related
logs:
#suse
#centos
Partiton magic
libmtp win32
#web
ubuntu 1470 broadcom
ati xorg.conf Rotate
gentoo xmss
ubuntu current groupname
#linux
|
|