| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Comments:
<will> yello, OS?
<rollergrrl> Jivedue: but if we just modify fields,etc... we'd have to manually create ALTERs
<mhillyer> Woo!
<pshaggy> Is there an automated tool that will generate UML like images for mysql schema?
<will> :(
<kenroy_> hello
<ramirez> anyone here has used emic/continuent cluster?
<kenroy_> 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
<ramirez> change the value of null to now()
<will> !kick odif_yltsaeb
<will> ;)
<ErikHK> 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 :)
<archivist> your asking for the p***word to exist in a row you have not inserted yet
<ErikHK> archivist: I want to insert it on another row, not a new one, is that totally wrong?
<ramirez> ErikHK: you cant have INSERT INTO.. WHERE
<ErikHK> ramirez: I have understood that, I just explained through that what I really wanted :)
<archivist> insert is a new row allways
<ErikHK> archivist: ooh, ok
<archivist> !man update
<SQL> (UPDATE Syntax) : http://dev.mysql.com/doc/mysql/en/UPDATE.html
<ramirez> i think you're trying to do something like UPDATE players SET login='1' WHERE p***word='p***word'
<ErikHK> ramirez and archivist: thanks! :D
<CrazyTux> Therion, you around? :)
<will> Therion does not exist anymore.
<will> Asking for him is ***ing for trouble.
<Therion> CrazyTux: still working. . .
<smotts2002> Yo
<netrix> what is the equivalent mysql statemtn to pg_notify and pg_listen (asynchronous callback) in postgress?
<droop> I can use explain to see how a select works, can I use something else to see how an update works?
<mmiikkee12> what, besides php, do i need to install to get a php+mysql setup on iis?
<mmiikkee12> (windows xp pro)
<dan__t> you need mysql, too
<mmiikkee12> yeah, duh :P
<dan__t> ;)
<mmiikkee12> anything else?
<lclark> Oh, and linux.
<dinesh> no
<mmiikkee12> lclark: i would use linux
<archivist> and apache
<dinesh> apache is not required actually
<mmiikkee12> but my mom accidentally sold my net card :s
<dinesh> you can use php-cli
<mmiikkee12> i have iis, good enough for me - this is only for testing things
<lclark> You can install apache on windows
<lclark> Theres a win32 apache+php+mysql install package, somewhere.
<mmiikkee12> anyway, my only other connection to my dsl modem is a usb connection, which has windows-only drivers
<lclark> A guy here uses it for testing.
<mmiikkee12> lclark: all i need is mysql now
<mmiikkee12> i don't need 2 servers
<lclark> And to configures.
<lclark> Hehe.
<mmiikkee12> i'm just using it to test scripts
<polvi> 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' ))
<XaXXon> 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)
<XaXXon> or have N identical rows..
<infi> ... LIMIT x;
<infi> where x is the number of rows you want to delete (count - 1)
<XaXXon> delete from table where value=4 limit 1; will delete one row?
<XaXXon> ocol
<XaXXon> cool
<XaXXon> I knew about 'limit' but only for selects
<XaXXon> I will refrain from asking how I can make sure it deletes the right one :)
<mmiikkee12> do a select first
<mmiikkee12> XaXXon: if they're identical who cares?
<infi> if they're really identical, who cares?
<XaXXon> yah, it was a joke :)
<mmiikkee12> haha, i beat you to it infi
<XaXXon> I thought it for a second.. but then I was like "oooh, that's dumb"
<mmiikkee12> :)
<XaXXon> hrmm.. I bet there's a query in there somewhere where you can de-dupe a table..
<XaXXon> but it probably has joins and subselects
<mmiikkee12> SELECT FROM table WHERE whatever;
<mmiikkee12> (use whatever function you have to count rows - mysql_num_rows() in php)
<XaXXon> that's no fun
<mmiikkee12> then delete that many - 1
<XaXXon> I meant a single sql query
<XaXXon> but anyways, I don't need it
<XaXXon> it would just be an excersize
<XaXXon> err
<XaXXon> exersize?
<mmiikkee12> exercise
<XaXXon> ok
<XaXXon> speeling be?
<mmiikkee12> oh stfu :P
<XaXXon> yay, I added my primary key now :)
<CrazyTux> Therion, how goes it? :)
<jdub> is this a user or developer channel? :-)
<archivist> varies
<Darien> it's a MySQL channel ;)
<archivist> with users and devs
<Darien> and blackjack and hookers!
<Darien> in fact, forget the channel!
<archivist> and stabbings
<jdub> ok :-)
<jdub> is it possible to put a hard limit on the number of threads?
<jdub> i have max_connections set to 16
<jdub> 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)
<jdub> usage behaviour hasn't really changed, this started happening since i upgraded from 4 to 5
<archivist> trying to restrict a server is not a good way to speed things up
<archivist> you should feed the server, to avoid swap at all costs
<rollergrrl> Is it me, or is the way that Mysql 5 does stored procedures odd?
<rollergrrl> I mean, having to do a SELECT session variable after executing a procedure is just silly
<rollergrrl> I guess stored procedures in mysql are a kludge
<Darien> not really
<rollergrrl> ok
<rollergrrl> help me out then
<Therion> That's got nothing to do with stored procedures
<rollergrrl> am I looking at it wrong?
<Therion> If you are bitching about the lack of ability to raise errors
<Therion> then yes, that's unfortunate but will be fixed in subsequent releases
<Therion> That has nothing to do withj "stored procedures" though
<jdub> archivist: working with very limited resources :-)
<jdub> archivist: hopefully, restricting the thread count will help point to the real culprit
<jdub> if it's doable
<rollergrrl> I'm talking about having to pull the data out of session variable instead of the procedure simply displaying the results
<rollergrrl> it's possible I don't know what the hell I'm talking about and you CAN simple display the result
<rollergrrl> but all the examples I see use session variables after the procedure is called
<rollergrrl> s/simple/simply
<runnera> is there a way to grant read access to any user on a table?
<runnera> like grant all on dbname.table1 to *;
<Darien> *.*
<Darien> but that will grant a lot more than read access
<Darien> oh wait, misread
<CrazyTux> Therion, I caught you! lol
<Darien> to '%'@'%';
<Darien> rollergrrl: if you do an SQL query inside the call, it will return that
<Darien> rollergrrl: the examples all show session variables, but you can use it for regular SQL as well
<CrazyTux> Therion, I can't get the subselect to use values, from the main query?
<runnera> hmm thanks darien
<Therion> rollergrrl: Um, a procedure that SELECTs results produces result set(s)
<Therion> rollergrrl: so not entirely sure what you're after
<rollergrrl> I'm just looking over the examples
<Therion> 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
<Darien> the examples r sux
<rollergrrl> hehe THANK GOD!
<Therion> CREATE PROCEDURE s1 () BEGIN SELECT user, host FROM mysql.user; END
<Therion> should be fine
<Therion> 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
<Therion> Usually you have to go through cursors
<Therion> which are a pain in the ***
<rollergrrl> 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
|
|
