Yes, I've hit this at work. In order to use some of the functionality limited to stored procedures in MySQL, I've had to create procedures to run once, and then drop them. Not a day that goes by that I don't dream of Postgres.
Hey, I've also noticed that some of my old posts don't have the correct sig. Looks an encoding problem. My old sig was '-- ∇×V ' and it got replaced with '-- ∇×V '. Think you can run:?
Not that I looked up the names of the tables or columns.
Hey, I've also noticed that some of my old posts don't have the correct sig. Looks an encoding problem. My old sig was '-- ∇×V ' and it got replaced with '-- ∇×V '. Think you can run:?
Code:
UPDATE my_bb_posts
SET content = REPLACE(content, '-- ∇×V', '-- ∇×V')
WHERE author = 'Labster' AND content LIKE '%-- ∇×V%'Not that I looked up the names of the tables or columns.
"Kitto daijoubu da yo." - Sakura Kinomoto