tag:blogger.com,1999:blog-7663029716914672257.post2596072972017889563..comments2023-04-01T09:17:05.512-04:00Comments on Chase Seibert | Blog: MySQL drop column if existsChase Seiberthttp://www.blogger.com/profile/01426857605067814174noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-7663029716914672257.post-27276133294090560902012-02-25T13:22:52.798-05:002012-02-25T13:22:52.798-05:00thanks
made these changes to get working on my sy...thanks <br />made these changes to get working on my system<br />delimiter ;;<br />delimiter ;<br /><br />no ' around delimiter and tadapcKrishttps://www.blogger.com/profile/01007643999734592477noreply@blogger.comtag:blogger.com,1999:blog-7663029716914672257.post-38465316515110512172011-01-12T20:16:31.061-05:002011-01-12T20:16:31.061-05:00It's also wise to add " where table_schem...It's also wise to add " where table_schema = 'database1' " in the case where you have multiple databases using the same tables and columnsUnknownhttps://www.blogger.com/profile/13441977977521140443noreply@blogger.comtag:blogger.com,1999:blog-7663029716914672257.post-15766632870942846192010-06-22T13:13:21.627-04:002010-06-22T13:13:21.627-04:00i had an error trying to execute such script like ...i had an error trying to execute such script like in your example.<br /><br />"Error Code : 1064<br />You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';<br />DELIMITER ';'' at line 10"<br /><br />it works after i deleted quote symbols ' near ; and ;; where delimiter is defined.ta2-1https://www.blogger.com/profile/00789417053221844627noreply@blogger.com