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]\
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
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
Hi,
...
> 1. COUNT(*) Is there anything wrong with using
> SELECT COUNT(*)
> FROM bleah
> or should I be using
> SELECT COUNT(someField)
> FROM bleah
COUNT(*) might be faster. Its possible that it reads the count from internal
table while COUNT(someField) needs to make a real que
