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

Question

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

Answer 1

0

it depends . . .

answered Mar 27 '10 at 07:29 AM

Fatherjack ♦♦
38.8k ● 55 ● 69 ● 104

(comments are locked)

Answer 2

0

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

answered Mar 26 '10 at 02:54 PM

CirqueDeSQLeil
3.9k ● 6 ● 11 ● 15

(comments are locked)

Answer 3

0

The answer is yes.

answered Mar 26 '10 at 03:16 PM

Ian Roke
1.7k ● 24 ● 29 ● 31

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.

Mar 26 '10 at 04:38 PM TimothyAWiseman

(comments are locked)

Answer 4

0

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')

answered Apr 10 '10 at 09:11 AM

Fatherjack ♦♦
38.8k ● 55 ● 69 ● 104

(comments are locked)

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

Follow this question

Related Questions