| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
Comments:
<0> or does it goe in "'s?
<1> in quotes
<0> okies thanks
<1> read carefully
<2> is there a way to show the last query?
<2> i.e. like a query history in mysql...
<1> hit the up arrow in the CLI
<0> so ("newpw")'?
<1> 'single quotes'
<2> Darien, the query comes from an application
<1> Fastly: then no
<0> do i need the ('s?
<1> vaijr2002: yes
<1> damnit
<1> Fastly: you could enable the general query log
<0> okies thanks
<1> Fastly: but on a busy server, that will fill your disk rapidly and obliterate performance
<1> Fastly: or enable the binary log and check that
<2> i'll look into it, thanks
<3> hello
<1> !man binary log
<4> (The Binary Log) : http://dev.mysql.com/doc/mysql/en/Binary_log.html
<1> !man general query log
<4> (The General Query Log) : http://dev.mysql.com/doc/mysql/en/Query_log.html
<3> i'm trying to do an export/import of a mysql database
<3> I start with a fresh mysql database
<0> SET P***WORD FOR 'root'@'localhost' = P***WORD('wiggles')'
<0> bash: syntax error near unexpected token `('
<0> <<what did i do wrong?
<3> import the data/structure
<0> oh i see i put a ' instead of a ;
<0> der
<3> the "mysql" database doesn't seem to import correctly because I can use the mysql client without specifying a p***word for root
<3> on the local server of course
<5> vaijr2002: uhm........................
<0> nope
<0> still didnt work
<1> abchirk: then you should set a p***word
<5> vaijr2002: you can't type SQL in a bash shell
<5> I mean you can but it won't understand it
<6> Yeah you can...
<7> aber|wrk, Darien wrote sth for you ;)
<0> hmm i am doing this as root in terminal
<5> vaijr2002: read all the instructions
<0> okies grrr lol
<3> vijr2002: UPDATE user SET P***word=P***WORD('myp***') WHERE user='root';
<5> not just lines that look interesting
<1> abchirk: perhaps you didn't run mysql_secure_installation ?
<1> abchirk: please don't do that
<1> don't modify the grant tables directly
<1> and don't advise other people to do it :/
<7> Darien, you talk with wrong person ;)
<8> Does "Lost connection to MySQL server during query" mean anything concretely?
<3> darien wrote me what??
<6> !m scarfboy gone away
<4> scarfboy: (MySQL server has gone away) : http://dev.mysql.com/doc/mysql/en/Gone_away.html
<1> grr
<1> damnit
<1> pick distinct nicks!
<1> I hate you all :/
<8> haha
<5> that's ok, we hate you back
<1> <3
<8> yes people, let's be hashable here:)
<7> lol Darien but i wrote it too you ;)
<5> a hash is still useless if you only use the first 2 charaters of it
<8> some hash implementations just use the first element to hash on
<1> last time I try talking on IRC with a sinus infection
<8> STL, if I recall correctly, does so.
<3> should the original p***word get imported?
<8> Got a lot better when I added crc32
<3> from the server I imported it from?
<1> aber|wrk: only if you dumped the mysql table as well
<1> er, database
<3> I did
<1> then yes
<3> and it imported
<8> So if you learn to do c3c32 in your brain you'll be right, Darien
<3> but I can use the mysql client on the local server without specifying a p***word
<3> do I need to flush the privilages.?
<0> hmm guess i need to read more lol
<3> that did it
<3> FLUSH PRIVILEGES;
<3> sorry my nick is not DISTINCT enough
<3> ; )
<0> brb
<9> i would like to create a table column with 41 bytes long specially for storing hash p***words anyone can help ??
<10> !m iturk column types
<4> iturk: (Column Types) : http://dev.mysql.com/doc/mysql/en/Column_types.html
<10> !m iturk alter table
<4> iturk: (ALTER TABLE Syntax) : http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html
<9> thanks
<10> iturk: that should give you what you need
<8> hmm, it loses the connection every time, though. Nothing in the logs either.
<9> inviso: just one thing in varchar which char represents a byte ?
<9> each i mean
<10> iturk: eh?
<3> laterrrrrrrrr
<9> in varchar each char represents a byte ?
<10> iturk: yes, unless you're using a multi-byte charset
<9> ok
<11> yay! server split :)
<11> shabbs: I'm afraid the group-wise maximum is not the answer
<11> it still doesn't solve the problem of multiple f_id's
<11> is there a way that I can do a subquery and return it as some sort of list to use in an IN() condition?
<6> Try it?
<11> BOOH YAH!
<11> BOO YAH!!!!
<11> shabbs, scarfboy: I totally got it
<11> SELECT `id` AS `data_id`, `system_id`, `hull_id`, `field_id`, `revision_date`, `revision_number`, `document_number`, `comments`, `color_id`, `user_id`, `date` FROM `program_cost_management_data` WHERE `id` IN (SELECT MAX(`id`) FROM `program_cost_management_data` WHERE `system_id` = 3 AND `hull_id` = 4 GROUP BY `field_id`)
<10> ewwww
<11> gives me the latest row from each field ID
<10> FROM program_cost_management_data JOIN (your subselect here) tmp ON blah = blah. The way you did it will be much slower with large tables
<11> apparently, I can do a subquery to get the latest Id's ***ociated with each one, then use the IN() operator in the where clause of its parent query
<10> erm, that's not quite right either
<11> inviso: hmm... you may be on to something :)
<10> you'd want to add a group by as well to gather the results up
<10> anyway, what you have works, but it will execute the subquery once for each row it checks
<8> tcp port 3306 is enough, right?
<11> inviso: ick... that explains why it was several seconds worth of a query :)
<8> to open on a firewall, I mean
<12> has anyone ever experienced a crash in the mysql C API using prepared queries?
<11> mitchless C API, or microsoft API ?
<11> inviso: like this?
<11> SELECT `id` AS `data_id`, `system_id`, `hull_id`, `field_id`, `revision_date`, `revision_number`, `document_number`, `comments`, `color_id`, `user_id`, `date` FROM (SELECT * FROM `program_cost_management_data` AS `x` JOIN SELECT MAX(`id`) FROM `program_cost_management_data` WHERE `system_id` = 3 AND `hull_id` = 4 GROUP BY `field_id` AS `y` ON (`x`.`id` = `y`.`id`) )
<12> C API
<11> mitchless: no to that one, but yes on the mikeysoft api's called from C :)
<12> the crash occurs in when we call mysql_stmt_fetch
<12> tenshi: definitesly the C API, it occurs on both Windows and Solairs
<12> if only i could type... definitely
<11> mitchless: aww .. I was looking for another reason to bash mikeysoft programmers :(
<12> hehe
<10> Tenshi: not quite. you'll want select field_id, max(id) from .... as your subselect so you have a field_id to join against when doing the lookup
<11> but that's definitely not a mikeysoft issue
<11> inviso: attempting to rework ...
<12> I was able to dig into the mysql code on Solaris and it looks like a couple of the MYSQL_STMT object are uninitialized
<12> hence a segfault
<8> !$#@
<11> mitchless: have you checked for bug reports and/or that you have the latest version ... if that's under your control
<11> inviso: I think I need a little bit of help on this one. I'm falling back into a syntax error loop that I never quite figured out
<11> so first of all, something like this?
<11> SELECT `id` AS `data_id`, `system_id`, `hull_id`, `field_id`, `revision_date`, `revision_number`, `document_number`, `comments`, `color_id`, `user_id`, `date` FROM ((SELECT * FROM `program_cost_management_data`) AS `x` JOIN (SELECT MAX(`id`) AS `id` FROM `program_cost_management_data` WHERE `system_id` = 3 AND `hull_id` = 4 GROUP BY `field_id`) AS `y` ON (`x`.`id` = `y`.`id`))
<6> What happens when you try it?
<11> syntax error
<6> Where?
<11> near 'AS `x` JOIN ...'
<11> there's something about subqueries on either side of a join that MySQL seems to be very picky about
<10> Tenshi: no reason to embed program_cost_management_data in a subselect.
<11> inviso: could you show me what you mean?
Return to
#mysql
or
Go to some related
logs:
lilo usplash howto
.fluxbox/keys defunct
glibc ntplonly
xgl tightvnc
#php
#osdev
#sdl
Programming Perlwarez
#asm
#perl
|
|