| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Comments:
<0> alter table tablename add index field....
<1> !kick [RainMkr]
<0> don't make him clean the chan again
<1> !man server variables
<2> (System Variables) : http://dev.mysql.com/doc/mysql/en/System_Variables.html
<3> yay.
<4> Therionnnnnn
<5> Hey guys -- how does one get the number of rows in a sql result?
<6> um
<6> mysql_num_rows?
<6> d'oh....wrong channel
<7> hey..i've got mysql 4.1 installed on Fedora Core 2....I can't remember how I installed it..but I'd like to uninstall it..
<7> using 'rpm -e mysql-server' yields "package not installed"
<7> ...anyone/
<8> can you do joins between 2 db on the server ?
<9> yes
<9> db.table
<10> domas, you own.
<9> wooo
<9> Therion
<9> did you like BMG? :)
<11> hi.. iam new to mysql. can you tell me the command to alter a field or adda new field in the tables..
<8> domas, is there a pointer that talk about what type of joins you can do in mysql versions ?
<9> !tell dos000 about joins
<2> Alrighty.
<9> dos000: left/right outer, inner, natural, straight
<12> !m karthikeayn alter table
<2> karthikeayn: (ALTER TABLE Syntax) : http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html
<3> !tell infi about joins
<2> Alrighty.
<1> domas: yeah
<11> thanks for the link.. SQL
<1> infi: SQL is fixed! etc
<13> woo
<8> domas, i am on debian sarge .. and i think the db version is 4.0
<9> dos000: there're no differences in joins supported...
<9> Leithal: were there any people late? :)
<14> hello mysql is hogging 40% cpu
<12> surffy, explain your query to check if its using an index etc
<14> im sorry?
<15> :)
<12> !m surffy explain
<2> surffy: (EXPLAIN Syntax (Get Information About a SELECT)) : http://dev.mysql.com/doc/mysql/en/EXPLAIN.html
<16> how can i temporairly shutdown mysqld?
<17> flush tables with read lock;
<17> doesn't shut it down, but blocks everything
<18> Hi, I came accross this. http://www.cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2006-1516
<16> well i'm trying to test for errors codes like 2, 111, 123, 145, etc..
<18> I have 5.0.20, is 5.0.21 affected by this?
<17> hussam, go read the changes
<18> where can I find them?
<19> 5.0.20 is vulnerable, 5.0.21 is not
<18> ok thanks
<17> mysql.com, click downloads, click 5 ... and you'll see "changes..."
<18> ok I'll check the changes, bye and thank you guys.
<16> what would i use to unlock afterward?
<20> ****
<17> if you're a woman, sure.
<16> i don't think that'll work.
<17> MikeDub, i'm not sure what you're really doing.. I'd suspect .. mysqlcheck -Ac -pyourp***word
<17> is what you're looking for
<17> but if it's not, who knows
<21> stored proc question: stored procedure x returns a result set. stored procedure y calls that procedure. can y go through the result set, without necessarily printing it out?
<16> well, what really i'm doing is seeing how my code reacts to different mysql errors.
<17> shnazz, i'd think you could do that but who knows. mysqldevelopment.com should have samples
<16> so i can built functionality to catch the erorrs in the future, and have my application contact an admin when **** goes down.
<20> anyone good with replication?
<20> I am getting error on slave ie ...
<21> my issue is i cant seem to figure out how to store the results of one sp inside another sp to use
<21> ill check mysqldevelopment
<20> 60517 15:05:36 [ERROR] Slave I/O thread: error connecting to master 'repl@xxx.xxx.com:3306': Error: 'Access denied for user 'repl'@'xx.xxx.xxx.xxx' (using p***word: YES)' errno: 1045 retry-time: 60 retries: 86
<22> I want it create a value string to use it in a where clause with IN('bla', 'blu') but I can't get it done - right now i split them with a comma $sub_county .= $row['county'].', ';
<19> shnazz: p*** it through temporary tables
<23> kokoko1: That error message looks pretty clear.
<21> is there no better way?
<21> feels like a hack...
<20> mhillyer, yes
<23> And?
<20> but problem is that if its connect with "mysql -u repl -p -h xxx. xxx .xxx"
<20> I duno why its giving error while connecting from mysqld,
<20> both slave/master running same versio of mysql
<23> Do you test with the exact same p***word from the exact same IP?
<24> kokoko1: did you create the user as repl@yourhost.dom.com or repl@xxx.xxx.xxx.xxx?
<20> MarcN, i have created the user with....
<20> GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%' IDENTIFIED BY 'xxxxx' require SSL
<20> why its working from shell :(
<23> require SSL is there but perhaps the slave is not connecting with.
<20> mysql --ssl -u repl -p -h xxx.xxx.xxx working :(
<20> I have setup each and every thing proper
<23> I'm saying that maybe your slave MySQL server cannot connect with SSL.
<20> No don't thinks, then it have to give some other error
<23> Aah very good then, have fun.
<20> sure
<20> coz I don't agree with you ?
<25> It's not a debate, you asked for help.
<20> MySQL have ssl support
<20> both master/slave
<26> hi people. will the syntax of the stored procedures/functions change after 5.0.21 ? the manual states"The MySQL implementation of stored routines is still in progress."
<25> My crystal ball is in the shop today :)
<26> mendel - i need that ball
<26> i need to start development on a new project but i dont want to write pages and pages of stored procs only to replace them later
<21> i think that means that they are adding features. Up till 5.0.10 there wasnt a define security param but all sp's created prior to versions with the define security param did work
<8> i have 2 tables i need to join . is there a way i can concatenate a string to one of the fields so that t1.a and t2.b can be compared to each other.
<26> indeed shnazz, that is my bet too.. bug fixes are understandable. but for the rest i am sure the language structure itself is then clearly stable by now
<12> !m dos000 concat
<2> dos000: (String Functions) : http://dev.mysql.com/doc/mysql/en/String_functions.html
<21> the core of it i'de say (im no expert) but things like error handling with signals will be implemented later.
<21> so you wont have to rewrite your stored procs, but they may be better with the signal feature when its implemented, in which case you may consider rewriting those stored procs for that
<26> shnazz: yes. the signal is in the alpha version now?
<21> im not sure where its at, if they've even released some version of it, but Im pretty certain that the feature is to be implemented for producton use
<21> at some point in the future
<27> real quick so a 2 year old could understand, what are the advantages/disadvantages of using varchar vs char?
<28> ?
<17> fixed length vs dynamic
<27> is there a performance hit with varchar then?
<27> obviously miniscule
<26> shabbs_: varchar.. you dont have extra whitespace..also smaller sizes
<17> shabbs_, no.. a performance gain with varchar.. as it doesn't require more IO for the field...
<27> lakez: more io? it has to read the size of the field before it can read the field, whereas with char it already knows the size
<21> ive read that char outperforms varchar in many scenarios
<17> shabbs_, imagine 10 M rows... if you had 200 characters per row and only using 10 ... ?
<27> lakez: then you have a poorly setup field :)
<17> then use char
<12> which gets silently changed to varchar
<27> !man string types
<2> (String Types) : http://dev.mysql.com/doc/mysql/en/String_types.html
<4> stupid fpdf
<29> what are the mysql (command line) commands to inspect the database?
<30> What kind of info do you want?
<29> i'm looking for: list of databases (i see mysqlshow from the command line), see list of tables, see list of views, see columns and constraints on a particular table, see the sql of a view
<30> !m MFen show
<2> MFen: (SHOW Syntax) : http://dev.mysql.com/doc/mysql/en/SHOW.html
<29> aha
<31> I need to have a mysql trigger run an update to an oracle db.... Any ideas?
<29> yeah, i think that's it
<29> had a hell of a time getting google to show me that
<29> i thought "inspection" would be a good keyword but no
<29> introspection! that's what i meant
<29> no, that doesn't really do it either.
<29> anyway, thanks!
<21> what kind of performance changes do you get when creating a temporary table and selecting from it - i cant seem to find any good articles on it...
<19> compared to doing what?
<21> hitting a table directly
<19> depends on 'hitting' the table
<19> some queries internally create temporary tables
<32> shnazz: it's not a question of performance changes necessarily, it's a question of maybe you need to do some work on a set of data without mucking about with the original table
<32> e.g. doing sorts, re-joins, queries, updating values, etc.
<19> shnazz: you can create temporary tables in memory if you want
<32> select your data into a temporary table, muck about with it, and off you go
Return to
#mysql
or
Go to some related
logs:
#centos
stumbleuppon
#perl
shycamteens torrent
#ubuntu
mergefb beryl
webadmin ubuntu
#lisp
#lisp
Can't send mail: sendmail process failed with error code 67
|
|