| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Comments:
<0> Sure, and family/famulus/slave
<1> Therefore bad is in fact the ideal word to describe malformed or fallacious queries.
<0> You are not an amoeba
<1> The sense of the word remains.
<2> How do I convert my tables to InnoDB?
<0> In fact it does not.
<0> Unfortunate that it does not, but it does not. ;)
<1> Then you think a bad job is an evil or morally depraved job?
<0> inono: ALTER TABLE tblname ENGINE=InnoDB;
<0> StoneCypher: What is a bad job? :)
<1> Because I was raised to think a bad job was an inferior or defective job.
<1> You did a bad job of washing the dishes, for example.
<2> Therion, if my DB supports innoDB, those tables will have transactions right?
<0> I would do a "poor" job of washing dishes, not a "bad" job.
<1> This is well used and common english on both sides of the pond.
<0> Perhaps if I washed them in the blood of virgin sacrifices it could be a bad job. ;)
<0> StoneCypher: It is _improper_. ;)
<1> one notes that poor implies directly a lack of wealth
<1> well
<1> that's the thing
<1> you say it's improper, but it isn't
<0> It is.
<1> the etymology and the usage both support it
<1> where's your data?
<2> Therion, ERROR 1064: You have an error in your SQL syntax near 'engine=InnoDB' at line 1
<2> ???
<0> inono: TYPE=
<1> Your english major and my english major seem to be at odds. Rather than name dropping, perhaps you could simply defend your ***ertion?
<0> inono: Use a current release? ;)
<2> ah
<2> TYPE=InnoDB?
<0> inono: Go for it
<2> thanks
<0> inono: Though any reasonably modern version understands the ENGINE syntax
<0> StoneCypher: If you have an English major, that explains your degree of wankery.
<1> Ah, ad hominem.
<1> Cute.
<0> Yes
<0> So?
<0> This is #mysql, not #english
<1> Mmm.
<2> Therion, will all InnoDB tables support transactions?
<0> And my epeen is bigger than yours
<0> inono: "Yes".
<3> Okay, English majors.
<0> inono: Though unless you disable autocommit you will have to explicitly start your transactions
<4> ok.. now im baffled.. why isnt this working? select if(ps_id,(replace prosyk values (ps_id,2,2)),null) from prosyk where profil_id = 2 and syk_id = 2;
<3> Okay, English major.
<0> Wow, he finally shut up
<3> Should the puncuation appear inside or outside the quotation marks in a case such as "this?"
<3> "Or how about this?"
<0> Julian|Work: That depends on whether you are writing for an American audience or not.
<3> Usually.
<0> A better question is .....just about any one you can imagine
<0> Americans tend to want the punctuation inside the quotation marks.
<0> Others do not.
<3> You're saying that's the worst question I could've imagined? :(
<5> others may not use " either >>
<0> Julian|Work: LOL, it is what I said but it is not what I intended to say. ;)
<3> Therion, I was being cautious of veiled jabs brought on by my stupidity.
<3> Well cool. I had a smart girlfriend once, and we actually argued about that ****.
<6> Main Entry: bad: 1 a : failing to reach an acceptable standard : POOR b : UNFAVORABLE <make a bad impression> ...
<0> That's crazy
<3> The smart ones are.
<0> I prefer arguing about whether or not I have any comp***ion and whether or not she's out of her friggin' mind.
<7> hi... can somebody point me to notes about a non-root mysql installation?
<5> you don't need to be root
<5> !m avr_ install
<8> avr_: (Choosing an Install Type) : http://dev.mysql.com/doc/mysql/en/mysql-install-wizard-install-type.html
<5> !m avr_ installing mysql
<8> avr_: (Installing MySQL) : http://dev.mysql.com/doc/mysql/en/Installing.html
<7> sjrussel: thanks
<7> sjrussel: what if the mysql package is already installed, and i just need to run the database (and play around with it) without root...
<5> do you have a mysql account?
<5> with CREATE DATABASE privs?
<7> sjrussel: no, probably not
<7> i'm using a server machine which runs red hat AS 4
<5> then you need someone to create a database and user for you
<7> so the mysql came with the initial installation..
<7> oh, i see...
<7> i do have lots of diskspace.. .so i can just install a local copy and then run it on another port?
<5> you can try, but probably would be firewalled unless you use the unix socket
<7> sorry, didnt understand that...
<7> :\
<2> How do I check if autocommit is on?
<5> SHOW VARS i think
<5> avr_ - can't help w/out being there, really. Try it and see
<7> okay... thansk
<7> so it is possible to use a server off a local install, right...
<2> Can I covert **all** tables in a database to InnoDB?
<5> sure
<9> i wnat a char field that's 500 characters big.. do i haevto use BLOB like it says?
<10> js_: if you run mysql 5.0.3 or higher, you can use varchar, else use text or blob
<10> !m string types
<8> string: (How Do I Map Visual Basic Data Types to MySQL Types?) : http://dev.mysql.com/doc/mysql/en/VB-Types.html
<10> arg.
<10> !m js_ string types
<8> js_: (String Types) : http://dev.mysql.com/doc/mysql/en/String_types.html
<9> ok, thanks
<2> Can anyone help me?
<2> i run ALTER TABLE name TYPE=InnoDB;
<2> but when I run SHOW TABLE STATUS;, its still MyISAM ??
<11> not sure if this a php question or mysql. I am insterting a master/detail record pair in php and need to know the primary key value from the master for inserting my detail record. How do I get at that info in mysql?
<12> with mysql_insert_id() or SELECT LAST_INSERT_ID(); iirc
<12> the former wrapping exactly the latter
<2> How do I check if my DB supports InnoDB?
<10> show engines
<2> not working (3.23)
<11> bigfoot- will that work reliably in a multi-user setting?
<13> Frustrated cry for help: 1) Can a BLOB field be as big as you want? 2) Is there a command to show exactly how many characters a field contains ?
<14> yes as long as you get the last insert id in the same connection
<15> Codex: limited by database maximum file size
<11> thanks
<15> also, somewhat by your ability to make a sql query big enough to hold the BLOB :p
<10> inono: http://dev.mysql.com/doc/refman/4.1/en/innodb-in-mysql-3-23.html
<2> ah
<12> Smegzor: Yes.
<2> how can I check if my version has innodb?
<13> Sneaky_Bastard: Okay, I think I can rule out the max filesize thing. But it shouldn't be too hard to hold a typical jpg image in the blob or the query ..? (Please don't start a flamewar over the image-in-mysql thing now..)
<2> I have 3.23.58-15
<16> flamewars usually start when the two sides are somewhat equal
<16> that wouldnt be the case for this one
<17> is mysql 4.1 multithreaded by default, or, if i have only one process, is that running on only one processor?
<10> inono: configure as said and see if it works. If it does not, you don't have it... but I kindly advise you upgrade.
<16> gezick: mysql is threaded
<13> Well, anyway, the problem is when I try to retrieve the images, and display 'em back on a page.. If they reach a given size (Don't know how much), they get cut.. :\ Okay, is there a mysql command to display how large a field is?
<18> hi guys i have a DATETIME field
<18> how do i increment it by 30
<18> days
<19> !m Artnez date_add
<8> Artnez: (Date and Time Functions) : http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
<18> thanks you darien
<19> UPDATE table SET field = DATE_ADD(field, INTERVAL 30 DAYS)
<18> ok worked perfectly thanks gentlement :)
<20> hi, how do i delete all records of a table except the first 10 from (select id from table order by score desc limit 10) i need the rest deleted. How can i do that?
<20> i want 10 records left in the table
<19> Stan1: what version of MySQL?
<13> Sneaky_Bastard: BLOB was not big enough to hold the images.. had to alter it to LONGBLOB, and all is well now.. :)
<14> !tell ^CodeX^ about images
<8> Alrighty.
<20> Darien: latest one
<20> DELETE FROM scores LIMIT 10,
<19> Stan1: be specific
<20> DELETE FROM scores ORDER BY score DESC LIMIT 10,
<20> is that it?
<19> no
<19> first, that's broken SQL
<19> seecond, that will delete the first ten
Return to
#mysql
or
Go to some related
logs:
#osdev
ATW - java.lang.OutOfMemoryError
#osdev
Can't locate object method finsh
#perl
chek wxpython
#kde
#suse
#debian
#css
|
|