question

nalq avatar image
nalq asked

beginner question

Beginner here and can’t figure this out.

Can anyone please tell me why am I having an error here? screen-shot-2021-08-31-at-30112-pm.png

parentheses
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
anthony.green avatar image
anthony.green answered

This is a MSSQL answer, unsure if it is the same for MySQL but, you have a trailing , (comma) at the end of emp_bonus int,


The last column shouldn't have a , at the end of it as its expecting more columns.

CREATE TABLE Employee(
ID INT PRIMARY KEY,
EMP_NAME VARCHAR(123),
EMP_SALARY INT,
EMP_BONUS INT
)
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.