Adding and modifying data in Sybase
Adding and modifying data in Sybase |
|
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.