| |
| |
| |
|
Page: 1 2 3 4
Comments:
<0> what syntax can i use if i want to update a table, and create a row if the instance doesn't exist?
<1> http://dev.mysql.com/doc/refman/4.1/en/alter-table.html
<2> REPLACE
<1> mogbit, have you tried ENGINE=INNODB instead of TYPE=INNODB
<3> do you even _have_ innodb?
<1> ah, forgot about all that table space and what not
<4> beebum engine does nothing either
<4> how can i figure out if my host has innodb K_F ?
<3> ask it
<4> their page doesn't say any specifics about mysql except i'm alootted unlimited space
<4> mer
<4> there isnt a sql command?
<3> well, sql - structured query language
<3> 1. A question; an inquiry to be answered or solved.
<3> [1913 Webster]
<3> so query ~ question
<3> hence .... ask it
<3> now bugger off and rtfm
<1> mogbit, search the variables
<3> for crying out loud SHOW VARIABLES LIKE 'have_innodb';
<5> morning
<3> hi
<1> sup
<1> oops, forgot what channel i was in ;)
<4> gg disabled and my earlier sql commands to alter the table gave no errors despite warnings being on
<4> time to go after the host
<1> ?
<3> I didn't get it either
<1> heh, i think it ammounted to "i don't have a clue so i'm going to blame it on the host" ;D
<3> beebum: something like that
<1> i don't realy know much myself but by facing up to that i am learning
<6> hy
<6> in a table i have a string, that string actualy is a regexp pattern can i get the rows that contain the regexp that matches a string? as fast as it can
<1> yes, wait no, uh maybe. what?
<6> D:
<2> why are you storeing the regex patten in the db?
<6> well.. i have a *!*@* host
<6> and a have users in a db
<6> and i want to get the user that has x!y@z
<6> i could do this with a while but it takes time
<2> WHERE
<6> Eldritch, and after that? :D
<1> http://dev.mysql.com/doc/refman/5.0/en/select.html
<2> if you want me to write the actull code it will cost.
<6> hmm...
<6> why will it cost? :D
<6> isnt this a help chennel? :D
<2> where does it say it is?
<7> but it is on mIRC, it must be
<2> lol
<6> Eldritch
<6> i beg you :P
<1> niGhTm4r3, getting pointed in the right direction is one thing having someone do it for you is another
<6> or at lest give me a link to a doc or something
<2> beebum did
<6> i dont need someone to do my work
<6> could i at least have a link? :D
<2> [08:39] <1> http://dev.mysql.com/doc/refman/5.0/en/select.html
<6> hmm..
<6> let me look again
<6> damn isp
<6> beebum, couldn't find anything about regexp on that site :(
<1> search for regex
<6> i searched
<6> i didnt found what i was looking like
<6> for*
<6> sry
<6> i have a string a a regexp pattern in a db in a specific field, i want the row that has the regexp that matches that string
<1> did you search for regex and not regexp
<6> no
<6> i searched for regexp
<1> 14:02 <1> search for regex
<6> oops.. sorry
<1> computers are like that unless you specify wildcards
<6> http://www.mysql.com/search/?q=regex&charset=
<6> nothing usefull found
<3> http://dev.mysql.com/doc/refman/5.0/en/regexp.html
<3> ?
<6> i have a string and a regexp pattern in a db in a specific field, i want the row that has the regexp that matches that string
<6> i could do this verry simple
<6> with a while loop, but i have many rows so it will take a while
<1> http://dev.mysql.com/doc/refman/5.0/en/tutorial.html
<8> I have a table with artist names, Several artists are listed twice or more, I want to remove these duplicates, but the problem is taht I have a song table which use these ids. What would be the best way of finding the duplicates, and at the same time update the artist id in the songs table to match the one of the artist still remaining in artists table?
<3> beebum: and yes, you do :)
<3> beebum: did you see the NerdTV episode on the founder?
<3> http://www.pbs.org/cringely/nerdtv/shows/
<3> #2
<1> hrm, i don't have anything here to play that format
<1> i'll try to check it out tonight
<3> windows?
<1> at work yes :(
<1> i'm windows free at home :)
<3> hehe, it is MPEG-4 anyways, so XviD or something
<3> if you have mplayer in the box back home you can probably play it without any problem
<1> yes, i'll try that tonight if i get to the computer
<3> no rush, it probably doesn't dissapear, and if it does I have a copy :)
<1> cool
<3> he has spent 3 all-nighters the past week for one thing
<3> talking about the thrill of development
<1> bet he's pulling down the bucks ;)
<3> hehe
<3> no ide how much he is good for
<3> idea*
<3> it is demaging for my health
<1> lol
<3> damaging*
<3> International Data Encryption Algorithm
<1> heh
<3> so every time I say "idea" I think of that algorigthm
<3> which is proprietary and licensed in the US till 2007
<3> see, I shouldn't know that
<1> hehehe
<3> **** mysql died
<9> dang it
<9> stupid mysql
<10> 'ello everybody
<10> is there anyone on ?
<9> howdy dr. nick
<10> i have a question
<11> on what?
<11> JC^Omega's mom?
<10> mysql :)
<3> Threads: 143 Questions: 3620 Slow queries: 0 Opens: 0 Flush tables: 1 Open tables: 34 Queries per second avg: 20.925
<3> think it was the connection limit actually
<3> boosted it
<10> i want the command for importing a database from a txt file
<9> damn strait
<9> dude I almost said it, but decided not to
<10> >>
<10> ??
<1> load data infile
<1> or something like that
<1> http://tyson.homeunix.org/notes/mysql.html
<3> Threads: 147 Questions: 9595 Slow queries: 0 Opens: 0 Flush tables: 1 Open tables: 37 Queries per second avg: 22.737
<12> hi there, what is the correct manner of comparing a mySQL datetime field.
<12> i use the (mysql) unix_timestamp(), compared it with the value of (php) time()
<12> and i realized that unix_timestamp() always returned 0
<12> is there a reason for this ?
<1> http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
<3> Threads: 160 Questions: 24749 Slow queries: 0 Opens: 0 Flush tables: 1 Open tables: 47 Queries per second avg: 25.151
<13> hi
<14> Hi i'm having a little problem on my server, was wondering if anyone could help me, I can create databases, i just cant create tables in these databases.
<15> oh Dannyboy- the pipes the pipes
<13> is there a way to have 2 mysql servers synchronized all the time? like if I insert delete or modify someting on Server(A) it instantly syncrhonize with Server(B)?
<13> and vise versa
<14> LanShark, yesterday it wasnt the system backup problem
Return to
#mysql
or
Go to some related
logs:
#linux
HOW-install-squid Solaris 8
^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$
he likes me chubby
gentoo silc-client blocking irssi
#AllNiteCafe
xgl interferes with amarok
#MissKitten
#linux
object expected error declaring javascript constant
|
|