| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Comments:
<0> yello, OS?
<1> Jivedue: but if we just modify fields,etc... we'd have to manually create ALTERs
<2> Woo!
<3> Is there an automated tool that will generate UML like images for mysql schema?
<0> :(
<4> hello
<5> anyone here has used emic/continuent cluster?
<4> i would like to know how do i allow a column in a table to enter the current date if the value entered is null
<5> change the value of null to now()
<0> !kick odif_yltsaeb
<0> ;)
<6> I want to do like this: "INSERT INTO players (login) VALUES('1') WHERE p***word='p***word' " but that isn't valid syntax, some help please :)
<7> your asking for the p***word to exist in a row you have not inserted yet
<6> archivist: I want to insert it on another row, not a new one, is that totally wrong?
<5> ErikHK: you cant have INSERT INTO.. WHERE
<6> ramirez: I have understood that, I just explained through that what I really wanted :)
<7> insert is a new row allways
<6> archivist: ooh, ok
<7> !man update
<8> (UPDATE Syntax) : http://dev.mysql.com/doc/mysql/en/UPDATE.html
<5> i think you're trying to do something like UPDATE players SET login='1' WHERE p***word='p***word'
<6> ramirez and archivist: thanks! :D
<9> Therion, you around? :)
<0> Therion does not exist anymore.
<0> Asking for him is ***ing for trouble.
<10> CrazyTux: still working. . .
<11> Yo
<12> what is the equivalent mysql statemtn to pg_notify and pg_listen (asynchronous callback) in postgress?
<13> I can use explain to see how a select works, can I use something else to see how an update works?
<14> what, besides php, do i need to install to get a php+mysql setup on iis?
<14> (windows xp pro)
<15> you need mysql, too
<14> yeah, duh :P
<15> ;)
<14> anything else?
<16> Oh, and linux.
<17> no
<14> lclark: i would use linux
<7> and apache
<17> apache is not required actually
<14> but my mom accidentally sold my net card :s
<17> you can use php-cli
<14> i have iis, good enough for me - this is only for testing things
<16> You can install apache on windows
<16> Theres a win32 apache+php+mysql install package, somewhere.
<14> anyway, my only other connection to my dsl modem is a usb connection, which has windows-only drivers
<16> A guy here uses it for testing.
<14> lclark: all i need is mysql now
<14> i don't need 2 servers
<16> And to configures.
<16> Hehe.
<14> i'm just using it to test scripts
<18> i am trying to get the unix timestamp of the beginning of the week week for any given date time... right now my solution is sort of hokey -- and I was wondering if anyone had a better one? select UNIX_TIMESTAMP(STR_TO_DATE( DATE_FORMAT(firstsaw,'%x%v Monday' ),'%x%v %W' ))
<19> if you have two identical rows in a database, how do you remove all but one? (preferably other than removing them all and adding it back once)
<19> or have N identical rows..
<20> ... LIMIT x;
<20> where x is the number of rows you want to delete (count - 1)
<19> delete from table where value=4 limit 1; will delete one row?
<19> ocol
<19> cool
<19> I knew about 'limit' but only for selects
<19> I will refrain from asking how I can make sure it deletes the right one :)
<14> do a select first
<14> XaXXon: if they're identical who cares?
<20> if they're really identical, who cares?
<19> yah, it was a joke :)
<14> haha, i beat you to it infi
<19> I thought it for a second.. but then I was like "oooh, that's dumb"
<14> :)
<19> hrmm.. I bet there's a query in there somewhere where you can de-dupe a table..
<19> but it probably has joins and subselects
<14> SELECT FROM table WHERE whatever;
<14> (use whatever function you have to count rows - mysql_num_rows() in php)
<19> that's no fun
<14> then delete that many - 1
<19> I meant a single sql query
<19> but anyways, I don't need it
<19> it would just be an excersize
<19> err
<19> exersize?
<14> exercise
<19> ok
<19> speeling be?
<14> oh stfu :P
<19> yay, I added my primary key now :)
<9> Therion, how goes it? :)
<21> is this a user or developer channel? :-)
<7> varies
<22> it's a MySQL channel ;)
<7> with users and devs
<22> and blackjack and hookers!
<22> in fact, forget the channel!
<7> and stabbings
<21> ok :-)
<21> is it possible to put a hard limit on the number of threads?
<21> i have max_connections set to 16
<21> but every now and then, i get a huge blowout of threads, which toasts my memory/swap (thus toasting the uml i'm hosting it in)
<21> usage behaviour hasn't really changed, this started happening since i upgraded from 4 to 5
<7> trying to restrict a server is not a good way to speed things up
<7> you should feed the server, to avoid swap at all costs
<1> Is it me, or is the way that Mysql 5 does stored procedures odd?
<1> I mean, having to do a SELECT session variable after executing a procedure is just silly
<1> I guess stored procedures in mysql are a kludge
<22> not really
<1> ok
<1> help me out then
<10> That's got nothing to do with stored procedures
<1> am I looking at it wrong?
<10> If you are bitching about the lack of ability to raise errors
<10> then yes, that's unfortunate but will be fixed in subsequent releases
<10> That has nothing to do withj "stored procedures" though
<21> archivist: working with very limited resources :-)
<21> archivist: hopefully, restricting the thread count will help point to the real culprit
<21> if it's doable
<1> I'm talking about having to pull the data out of session variable instead of the procedure simply displaying the results
<1> it's possible I don't know what the hell I'm talking about and you CAN simple display the result
<1> but all the examples I see use session variables after the procedure is called
<1> s/simple/simply
<23> is there a way to grant read access to any user on a table?
<23> like grant all on dbname.table1 to *;
<22> *.*
<22> but that will grant a lot more than read access
<22> oh wait, misread
<9> Therion, I caught you! lol
<22> to '%'@'%';
<22> rollergrrl: if you do an SQL query inside the call, it will return that
<22> rollergrrl: the examples all show session variables, but you can use it for regular SQL as well
<9> Therion, I can't get the subselect to use values, from the main query?
<23> hmm thanks darien
<10> rollergrrl: Um, a procedure that SELECTs results produces result set(s)
<10> rollergrrl: so not entirely sure what you're after
<1> I'm just looking over the examples
<10> rollergrrl: The only reason you would _have_ to select a session variable afterward is in order to handle raising of errors, as currently RESIGNAL and SIGNAL and such are not implemented
<22> the examples r sux
<1> hehe THANK GOD!
<10> CREATE PROCEDURE s1 () BEGIN SELECT user, host FROM mysql.user; END
<10> should be fine
<10> rollergrrl: I'll note here that MSSQL is one of the few databases that makes it that easy to return result sets from a procedure
<10> Usually you have to go through cursors
<10> which are a pain in the ***
<1> well sweet!
Return to
#mysql
or
Go to some related
logs:
python socket.recv freezing
pcmcia_list.html
#perl
#lisp
+fluxbox +emwh
#css
themeitem fluxbox
phyton xubuntu
#fedora
ntpd connection refused gentoo
|
|