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

Adding and modifying data in Sybase

Tech Computer Center logo

So, now you have your database, and you have your table. But what about the data? Well, that's the fun part. If you are lucky, there's already some data in place, and you only need to modify some of it. If not, you get to enter each piece of data, by hand, into your tables. Joy!

If you have special characters to enter as values into your tables (that includes % _ , ( ) < > . : = + - * / ' " and the space character) you must quote the value. To do that, enclose the value between single closing quotes.

For instance, to use fifteen percent, you would type '15%'. To get a ' character, you type it twice. For example 'it''s' would enter the contraction for it is as a value.


Next: Searching Sybase databases
See also: Using the Sybase database system
Previous: Indexing Sybase tables
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/23 22:51:43 UT
URL: http://www.nmt.edu/tcc/help/db/sybase/add_data.html
QR two-dimensional bar code