Example of adding data in Sybase

For example, to insert data into a table called rolodex, type

        insert into rolodex values
            ('John','Jones','308 Main Street','Socorro',
            'NM',87801) go

If you see

        Msg 102, Level 15, State 1
        Server '', Line 1
        Incorrect syntax near '89'.

• You could have entered data that is not the correct type for a column (text in an integer field for example).
• You could have used more values than you have columns.
• You could have used fewer values than columns.
• You could have forgotten the commas.

Take a close look at your insert statement and compare it to your table structure. When you figure out what went wrong, try it again. It's strange, but true, this type of error, which I think is the most likely error to be made, has the least helpful error code in the entire program.

Maintained by John Shipman, john@nmt.edu; original by Steve Anderson Last updated: 1997/06/25 20:12:54 UT URL: http://www.nmt.edu/tcc/help/db/sybase/add_all_ex.html