Importing manually into a table

Database

Importing manually into a table

Hi, 

I am importing manually data into a table and I get an error.

This is my query: insert into table_name (member_primary_email) values (example@yahoo.fr)

And this is what I get: [Error] Script lines: 1-1 --------------------------

 [Teradata Database] [TeraJDBC 13.10.00.31] [Error 3707] [SQLState 42000] Syntax error, expected something like ',' or ')' between the word 'example' and '@'. 

Is it because an email address is not considered as "values"? What should I put instead?

Thanks a mill!

2 REPLIES
Senior Apprentice

Re: Importing manually into a table

An email address is a string, and SQL requests quoted strings: 'example@yahoo.fr'

Dieter

Re: Importing manually into a table

Thanks a million, that works!

Lucía