About Borland

2001-04-08 Thread Jarmo Paavilainen
Hi, Im not sure but: Is it safe to assume that row[0] and row[1] are valid (ie not NULL and not garbage)!(?) ... row = mysql_fetch_row(res); printf("[%s:%s]\n", row[0], row[1]); ... mysql_data_seek(res, 0); ... row = mysql_fetch_row(res); printf("[%s:%s]\n",

SV: _

2001-03-23 Thread Jarmo Paavilainen
Hi, ... I'm still a newbie in mysql and also sql statements. I was wondering if some one can help me with this problem. I'm trying to select 5 of the highest values from a table. But i can't seem to find any help from the manual and also some other books. In the manual, there is

SV: Spaces

2001-02-18 Thread Jarmo Paavilainen
Hi, ... Is there a way to create column names with spaces ? Yes you can use backquotes for this: create table `a b` ( `x y` int ); Doesnt the normal (SQL9?) double quote do the trick? : create table "a b" ( "x y" int ); // Jarmo