You need ADD COLUMN clauses for those other two columns. Perhaps this ALTER TABLE statement was edited from a CREATE TABLE statement incorrectly?
On Apr 17, 2017 2:48 PM, "Justin Swanhart" <greenl...@gmail.com> wrote: > I believe there is a missing right parenthesis after the 11. has_children > is a third Boolean column. > > On Apr 17, 2017 2:29 PM, "David Karr" <davidmichaelk...@gmail.com> wrote: > >> I've used Mariadb for a couple of small projects. I prefer to >> automate as much of the initial creation and config as possible, using >> SQL scripts executed from JDBC. I can at least do this for the table >> creation and population. >> >> I'm taking over an existing small project that is organized somewhat >> funky. There are some scripts that are apparently intended to >> initialize the database, but I'm seeing one line in one of those >> scripts that I don't understand, and I don't think is valid. >> >> I would appreciate some help explaining what you think this line MIGHT >> be intending to do: >> ----------------- >> ALTER TABLE `project` add column (proj_typ_id TINYINT(2) NOT NULL >> DEFAULT 1, parent_proj_id int(11, has_children BOOLEAN); >> ----------------- >> >> The first problem is that first paren. There's no matching right >> paren, so I can't imagine this can succeed. >> >> Second, I don't understand much past that first comma. Is this >> intending to add TWO columns, the second being "parent_proj_id"? >> Assuming that's the case, what exactly does "int(11, has_children >> BOOLEAN)" mean? I can see that it's declaring an 11-digit int, but I >> don't understand the "has_children" part. >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~maria-discuss >> Post to : maria-discuss@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~maria-discuss >> More help : https://help.launchpad.net/ListHelp >> >
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
