any idea why modified by is not working?
|jbalint||what is not working|
|burtonator||... so I'm trying to migrate a table to INNODB and during import one of the INSERTs is deadlocking ... no disk or CPU is being used....... any ideas?|
|jbalint||show engine innodb status;|
|cliffclof||what's an undefined index warning?|
dang i thought i got my indexes right?
|seekwill||Where did you get that error msg?|
|burtonator||hm........ I dont' think this is a deadlock.... the statatement would have been aborted otherwise|
how many characters long is a string of , 256? or when you define a string in mysql is it mroe than that
255 usually means, 255.
is there any flag i can set for something so although i allocate a certainlegnth for it, it can accomodate more if need be?
|seekwill||Use a VARCHAR length|
VARCHAR(255) will use up number_of_chars+1
VARCHAR is variable length
|turbolover||yeah, well what im doing is storing an array of 40 form elements that had been serialized into a string from php|
so its quite length
|turbolover||i ran out of space with 255 :P|
|seekwill||Usually it's better to store each form element in a different row|
Use TEXT then
|mugger||is there anyway to pull say all the data out of table1, then join it with table 2 on the condition a row in table 2 = 1(a fixed value)?|
|seekwill||How does table1 relate to table2?|
But yes, you can do: FROM a INNER JOIN b ON a.id = b.id AND b.fixed = 1
(if that's what you mean)
|cliffclof||Is it practical to have a multiple tables with 100,000 entries|
|cliffclof||err does it work okay say I have 3 indexes|
|seekwill||100k entires is "little"|
|cliffclof||sweet thank you|
|seekwill||Depends on your queries|
|cliffclof||they are calling only groups of 1000 at a time|