Next / Previous / Index / ITC Help System / Publications / Site map / NM Tech homepage

Example of adding data in Sybase

Tech Computer Center logo

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 done a lot of things wrong:

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.


Next: Inserting data in specific Sybase columns
See also: Adding and modifying data in Sybase
Previous: Adding data to all columns in Sybase
Site map
Index: Keyword index to help pages
Help: New Mexico Tech Information Technology and Communications: Help System
ITC Publications
To report a problem: File a ticket
Send mail to the User consultant on duty or call them at 575-835-5437
Home: About New Mexico Tech

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
QR two-dimensional bar code