| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
Comments:
<0> you told me to edit 2 places
<0> I've edited 1 and asked you about where the other one is
<1> yes, 2 places within my.cnf
<0> you are not giving me the needed info
<1> there are 2+ sections in my.cnf
<0> only appears to be 1 place
<0> oh!
<1> either it's called [client] or [mysql] for one, [server] or [mysqld] for the other
<0> nopw THAT makes sense!
<1> ntengineer22: western?
<1> !weather azo
<2> Failed to lookup weather at station AZO
<1> !weather KAZO
<2> Current conditions at Kalamazoo, Kalamazoo / Battle Creek International Airport, MI, United States: It is 0 C (33 F), windspeed is 11.27 km/h, and visibility is 16.09 km. (Information current as of 2006.02.27 1953 UTC).
<3> AND transdate >2006 -2 -20
<3> AND transdate <2006 -2 -27
<3> this is OK syntax in the where clause right
<4> nope
<3> I know B
<3> oh
<3> it isnt?
<3> I cant do that with dates?
<3> I have to escape the dashes?
<4> that's the same as transdate < 2004-27 which is the same as 1977
<3> or put quotes around them
<3> oh
<3> ok
<4> quote it. "2006-02-24"
<3> thank you
<5> !weather EYVI
<2> Current conditions at Vilnius, Lithuania: It is -12 C (9 F), windspeed is 8.05 km/h, and visibility is 6.44 km. (Information current as of 2006.02.27 2020 UTC).
<5> damn!
<6> what's the exact link to download mysql 5.0 all RPM packages ?
<6> like server, bench, client, devel, shared etc ?
<4> Dr-Linux: mysql.com and click on downloads
<6> inviso: :S
<1> !weather LHBP
<2> Current conditions at Budapest / Ferihegy, Hungary: It is -8 C (17 F), windspeed is 0.00 km/h, and visibility is 11.27 km. (Information current as of 2006.02.27 2030 UTC).
<1> kinda glad I'm not there right now :)
<4> 0 windspeed? What kind of freaky place is that?
<1> sits in valley between the alps and carpathians
<4> We had wind yesterday that almost tipped my bike over with me riding it
<1> though there is normally wind :)
<7> inviso, ok, I upgraded bugzilla, wow, the new one is much better looking, heh :)
<7> and it works, thanks :)
<7> people will be happy when they come to work tomorrow morning <if the new bugzilla doesn't have new bugs...>
<3> lovely antwerp
<3> temperature is flirting with that of melting ice :P
<4> shimi: cool
<3> at least i'm not in siberia
<3> those peoples diaries compress really well
<3> the phrase "really cold with lots of snow" comes by a lot
<8> Anyone here?
<4> nope, not a soul
<8> I'm in PHP Admin, in table webreflow_user_count. I have like 20,000 entries and want to delete ID x-x
<8> how do i do that?
<4> use a SQL statement
<4> !m ltR^ delete
<2> ltR^: (DELETE Syntax) : http://dev.mysql.com/doc/mysql/en/DELETE.html
<4> that was exactly 6 seconds of hugging. Hope it was worth it ;)
<7> inviso, re your attitude to perl, you might wanna add: "perl is the only language that looks the same BEFORE and AFTER RSA encryption"
<4> shimi: rofl
<4> shimi: co-workers are staring...
<7> ?
<4> apparently the outburst of laughter was too loud. People are peering at me
<7> ah, ok, you're at work:)
<7> night here...
<4> kibab: How's it going there today?
<4> On a scale of 1-10 where 10 is complete and utter meltdown
<9> 12
<4> archivist: owwww. You might be worse off than us :(
<9> making a prototype "urgent" ***embler coding
<9> supposed to be delivered last wednesday
<10> archivist: and you say making rather than 'finishing'?
<9> yeah solder a few parts on, code, check, rinse repeat .... till done
<11> Can you transfer InnoDB db's from linux to windows and visa versa?
<9> mysqldump hell yes
<9> hmm playing with fire ! I have some thermit welding pouder
<9> powder
<11> /s/db's/tables
<9> com4 with mysqldump, hell yes
<11> Ah
<11> Thanks ;P
<9> powder1man mysqldump
<9> !man mysqldump
<2> (The mysqldump Database Backup Program) : http://dev.mysql.com/doc/mysql/en/mysqldump.html
<11> sweet
<12> does the index need unique values?
<4> if it's a unique or primary key, yes
<12> ok.
<13> how can i insert records into one table, based on records in three other tables? e.g. insert into url values .... select url_key from link as l, img_file as i, pro_desc as p where l.url_key=p.url_key and l.url_image=i.url_image;
<4> dogmeat: and? Did it work?
<13> inviso_, heh, no i was just setting up the question.
<4> dogmeat: ;) Give it a try
<13> inviso_, looks like there's a form of insert that can do this though
<14> will 'order by' use unique index?
<4> !m dogmeat insert select
<2> dogmeat: (INSERT ... SELECT Syntax) : http://dev.mysql.com/doc/mysql/en/INSERT_SELECT.html
<13> inviso_ thanks ;-)
<4> cookoo: if one's available, I believe so
<14> I mean, is it duplicated to create unique index and normal one on the same fields?
<4> yup. If the rows are unique, just use an unique index
<14> invisio_: ok, thx
<15> Hola everyone
<16> update table set @var := one, two = @var; <-- how come this does not work ?
<16> in the mysql client
<4> mod_cure: aww, come on. You should know better. Don't make me !tell doesn't work
<15> im trying to update a mysql database, my problem is that the data base im trying to update is 3.23 and my database is 5.0
<16> I know, don't feel good today
<4> !m ross upgrade
<2> ross: (Upgrading MySQL) : http://dev.mysql.com/doc/mysql/en/Upgrade.html
<4> ross: upgrade to 4.1 and then to 5.0
<15> actually i dont have the ability to update my hosts sql version, but i just figured it out
<15> if you use phpmyadmin you can set the SQL export compatibility to SQL323
<15> thanks
<16> inviso, tell me :)
<4> mod_cure: I have no idea. I don't even know what's wrong
<16> :)
<16> update table set @var := 10, two = @var;
<16> <-- get error for some reason
<16> syntax near '@var := 10'
<17> can I do SOURCE /var/..../..../fooFile.sql INSIDE another .sql file ? I am getting errors. Is there maybe another command instead of the SOURCE?
<9> mod_cure you have := and =
<16> two is a column
<16> @var is a variable
<17> no one?
<17> how long is MySQL going to take to load a 500mb large file ?
<18> not much if you use 'load data infile'
<18> and no indexes
<16> anybody :)
<19> I've got a question...and it regards database optimization...
<19> I'm writing a back-end app and it's gonna hold data for about 3000 users...each user will have about 3000 records...should I make a table for each first letter of the userid or just make a table for each user?
<20> so you can lock a table so other connections can't write to it, but can you lock a row in the same way?
<4> OneFix_Work: just one table. Not even one per user
<19> so should I have a "atable, btable, etc" or a "user1, user2, etc"
Return to
#mysql
or
Go to some related
logs:
kernel commandline runleve
#perl
jmax build dapper
FC5 xdmcp
phoul
archive.ubuntu.com/ubuntu/dists/breezy/universe/binary-i386/Packages.gz
outputtree+java
php rainmkr
#lisp
No extended input devices -wacom
|
|