question

Michael 4 avatar image
Michael 4 asked

Is this how I would add someone's information to a table

Select C_ID,C_Last,C_First,C_City,C_State,C_phone,C_email

Insert into consultant
values
106,Abdelrazek,Maged,Lexington,KY,4079520220,Prof.mAbdelrazek@yahoo.com
queryhomework
10 |1200

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

CirqueDeSQLeil avatar image
CirqueDeSQLeil answered

You have provided nothing more than a query. You need to provide some detail and what your actual question is.

10 |1200

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

Ian Roke avatar image
Ian Roke answered

The answer is yes.

1 comment
10 |1200

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

TimothyAWiseman avatar image TimothyAWiseman commented ·
Well, he is close this time. He needs the parenthesis and the single quotes around the character strings. Its easier to see that with the code formatted though.
0 Likes 0 ·
Fatherjack avatar image
Fatherjack answered

it depends . . .

10 |1200

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

Fatherjack avatar image
Fatherjack answered

This is likely to work but we still need more information from you

Insert into consultant 
(C_ID,
C_Last,
C_First,
C_City,
C_State,
C_phone,
C_email)
values
(106,
'Abdelrazek',
'Maged',
'Lexington',
'KY',
4079520220,
'Prof.mAbdelrazek@yahoo.com')
10 |1200

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.