35 reputation
14
bio website
location Euless, TX
age
visits member for 2 years, 6 months
seen Jul 13 at 2:10

May
25
awarded  Notable Question
Aug
25
comment MYSQL 5.6.12 Lock wait timeout exceeded, yet no transactions\locks currently taking place?
the "lock wait timeout" is pretty much instantaneous, not sure how catch it between the alter and error message. Did another alter this morning to add a column and all was fine, but yesterday had to restart the service again. Thanks for following up though, appreciate it.
Aug
24
comment MYSQL 5.6.12 Lock wait timeout exceeded, yet no transactions\locks currently taking place?
nothing in the error log since startup. SHOW FULL PROCESSLIST just says 173|david|localhost:54978|office|Sleep|1
Aug
18
asked MYSQL 5.6.12 Lock wait timeout exceeded, yet no transactions\locks currently taking place?
Mar
20
awarded  Popular Question
Jun
13
accepted MYSQL only Show columns which allow null
Jun
12
asked MYSQL only Show columns which allow null
Jun
12
comment MySQL get next unique value without auto increment
Thanks for your help! I'll mull this over and see where I go from here and make a new post with any new questions I come up with.
Jun
12
comment MySQL get next unique value without auto increment
One more question (might be a little out of the scope of this post), since MyISAM doesn't support transactions, if I start a transaction, insert into an MyISAM table and continue my operations on the other tables, will the insert into the MyISAM table cause the transaction to commit early?
Jun
12
awarded  Supporter
Jun
12
comment MySQL get next unique value without auto increment
What if I wanted an additional auto increment column to use as a primary key for all of the work orders? (in the site_workorder_seq table). I'm guessing that isn't possible since I've already assigned an auto increment column.
Jun
10
awarded  Scholar
Jun
10
accepted MySQL get next unique value without auto increment
Jun
10
awarded  Student
Jun
9
asked MySQL get next unique value without auto increment