| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Comments:
<0> conexion2000: looks like you'd better hire a consultant if you can't do your job.
<1> :)
<2> !perror 139
<3> MySQL error: 139 = Too big row
<4> or read the link I gave you
<4> hehe Leithal breaks another db
<2> heh
<5> no infi its for private purpose only, but I have to little time to read the doc, and today is my first day withy mysql, so please help me...
<0> delete from computer where application = 'mysql'; insert into computer values ('Access');
<4> infi that would be to hard for him, he could try notepad
<5> nice thanks :P, and back to Your bed now
<0> time's a wastin'
<0> better read that document in the next 4 minutes
<0> here's another one: http://www.catb.org/~esr/faqs/smart-questions.html
<6> Hi guys... create sequence is only supported by MaxDB ???
<0> oh oh, time's up! conexion2000's world just exploded.
<1> hwoarang, other engines use auto_increment
<7> maxdb is not an "engine"
<7> mysql doesn't support sequences
<8> haha, I forgot all about that guy I was supposed to be helping with his code
<8> he's just been waiting here patiently
<0> migs, you also forgot to tell me what country you're in that bans "Jokes, ***, Nudity"
<8> U.S.
<0> especially the "jokes" part
<0> hmm, you guys have gotten even worse since I expatriated, I guess ;)
<6> BartVB, I'm trying to use it with MySql 4.0.18... do not work
<8> yeah. Nice of you to make huge sweeping ***umptions, push stereotypes on an entire country and ***ume that somehow my inability to view one measly site is a problem with the entire country.
<1> nah
<0> uh, I'm american.
<1> it's the other way around :D
<8> I thought you said you expatriated
<1> we know that there are problems in the US and this is just a tiny demonstration :P
<1> hehe
<0> I guess they banned jokes because noone you ***ociate with has a sense of humor...
<0> jesus.
<8> yeah, that must be it
<1> ah well. but which country doesn't have it's problem
<8> it CERTAINLY couldn't be just a firewall my company put up
<1> I know .nl has problems :\
<8> the problem is much more m***ive than that. It goes ALL THE WAY TO THE TOP!
<0> after you mentioned the US, I figured as much, but freaking lighten up dude
<8> haha
<1> infi, where are you now?
<8> I just found it funny you ***umed so much and were so willing to apply such negative stereotypes.
<0> Japan
<1> :) talking about changes :D
<8> I guess disliking America is the "cool thing" to do nowadays
<0> I didn't ***ume anything, I lived there for 27 years :b
<8> non sequitur. <0> migs, you also forgot to tell me what country you're in that bans "Jokes, ***, Nudity"
<8> <0> hmm, you guys have gotten even worse since I expatriated, I guess ;)
<1> ^Migs^, nah. the US just did too many weird things in the last couple of years. I know my opinion about the US has changed quite a bit over the last couple of years.
<8> meh. Without America the world would be screwed down the road.
<1> ^Migs^, :) That's exactly what I'm talking about :D
<1> this superiority thing
<8> the "weird things" will prove the right course of action in the long run
<1> and the religion thing
<8> religion thing?
<1> and the 'war against terror no matter what'
<1> etc
<8> superiority I've heard constantly, but religion?
<1> religion has become a much bigger issue in US politics in the last couple of years
<8> yeah, we should just let terrorists roam freely around the world, killing people as they wish
<1> (read: Bush Jr)
<8> survival of the fittest, after all
<1> but discussions about this with americans tend to be rather pointless :)
<8> since Americans are such a single-minded uncompromising entity, right?
<8> sounds a bit racist
<8> we Americans can even read other Americans' thoughts! Betcha didn't know that!
<1> nope, not americans. Bush is :) And some other americans are. But certainly not all americans
<1> I know quite a few americans and most of them are intelligent and social beings :)
<0> phew, look at the Pandora's box I unravelled with a simple question about network policy.
<8> I think Bush is just doing the best job he can do given the circumstances. America didn't ask to be bombed.
<1> hehe :)
<1> Bush is doing the best he can do. I can agree with that :D
<8> no one said he was infallible
<1> but IMO that says quite a bit about his capacities :)
<1> but
<1> as I said
<8> and he only has a couple more years in office
<8> I don't think he's running again
<1> IIRC he's not allowed to
<8> Few people in the world could do a better job
<8> oh you're right, he's not
<8> no more than two terms
<1> these discussions tend to be rather pointless. You have your views, I have mine and I don't have the illusion that we're going to come to a common understanding here :)
<9> Quick question. I'm trying to create a query with a CONCAT in the select statement, but some values inside would be NULL making the whole entry null. I have used IFNULL to replace the null value, but this won't work inside a CONCAT statement. Is there a way around this?
<8> I think it's an interesting discussion, though
<1> and duty calls. I'm going to chop up some onions :)
<1> it is. But our worlds seem to be a bit too far apart :)
<8> I may not agree with some of the tactics the government has used, but other countries aren't doing too much to help resolve the situation
<8> that's why I said in the long run...
<9> example: SELECT CONCAT(value1, ', ', IFNULL(value2,0)) from db;
<9> nevermind
<9> it does work.i was leaving off a )
<1> last comment: trying to kill everyone that looks dangerous and is a muslim is not resolving the situation. Bush hasn't even _though_ about the reasons why people try to wipe the US off the earth. IMO that's fairly shortsighted. But now I'm really going to cook otherwise my GF is going to spank me :)
<9> man i'm tired
<10> Can someone help me to recover my mysql database from the binary(.frm, .MYD and .MYI) files. When I just put the database folder in my mysql database folder it only seems to recognise the database but not the tables and the content.
<8> I really don't think that's what America is doing. Although that's how it's caricaturized in other countries' media.
<8> and often in the U.S. media, too
<11> is this still the mysql channel?
<8> and you think we should entertain the reasons people seek to exterminate others? I actually agree. However, with the current enemy, there's really no compromising. History has told us that.
<0> somebody has got some serious sand in their vagina
<8> if there was a peaceful resolution, the government would seek it. There isn't at the moment, though.
<11> hella lame
<12> i was forced to leave after posting before.. so i'm going to repost, hopefully someone can help with this question
<12> given a table structure w/ four columns... location_id int, variable_id int, record_date datetime, value int ... is there a way to return the most recent variable_id/value pairs for each location_id w/o using some weird concat tricks?
<13> can I switch from myISAM to InnoDb without messing up any data?
<14> Greetings. Having trouble if I run "mysql -e show databases" ... comes back with "unknown database 'databases'". Works fine in interactive mode. Any ideas? v3.23
<4> jesusfish yes except for fulltext indexes
<10> Is there a way to restore raw database files after a server crash? I still have the files, but I cant get the server to boot the old OS.
<12> i cant seem to think of a way to do it with subqueries.. i'd like to avoid programming and/or concat tricks to get it done...
<14> Nevermind, double quotes to the rescue. Sorry!
<15> floort: innodb or myisam?
<10> I think myisam
<15> floort: should work both, though, if you got the configuration and the mysql version
<15> floort: with myisam your changes are pretty high
<15> chances
<15> not changes :-9
<10> I still have all the files, but the server just wont boot
<13> archivist: can I just rebuild those then?
<10> How do I recover the database? I have tried to put the folder in the mysql folder from my laptop. This just results in a new empty database
<15> floort: actually, if you use the same version of mysql, this should work
<4> floort if myisam it should work (innodb dont dorget the ibdata etc files from the mysql dir)
<4> dorget=forget
<10> Ok, thanks alot! I wil try.
<4> !m jesusfish alter table
<3> jesusfish: (ALTER TABLE Syntax) : http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html
<8> man, I still forgot about that guy I was supposed to help
<8> meh
<16> man i wish mysql cli had psql's help
<17> if I wanted to change my fields to take AES_ENCRYPT values..... and select them back out with the decrypt function .... is there a chance my code could break? or should it all just happen correctly
<18> Tac_Work, as long as you have the proper size on the field you shoudl be fine
<10> I just loaded the database files in my directory but I get this error when i use mysqldump:
<10> mysqldump: Got error: 1017: Can't find file: './stmichae_reunie/reunie_foto.frm' (errno: 13) when using LOCK TABLES
<19> does anyone know the command that you can issue in mysql that does an UPDATE, but if the row doesn't exist it will cause an insert
<18> floort, does that file exist?
<10> But this file exists
<19> ?
<18> nekoflux, reverse your logic
<20> !perror 13
<3> System error: 13 = Permission denied
<18> INSERT ON DUPLICATE UPDATE
<19> ahhh
<19> ***iness
<10> I will try chmod
<19> thanks!
Return to
#mysql
or
Go to some related
logs:
Solaris unkillable zfs
#fedora
#sed
usb_host only one interface supported gentoo
#php
debian lmsensor presario
#oe
lotheac
#linux
brianetta
|
|