List:General Discussion« Previous MessageNext Message »
From:Miguel Cardenas Date:September 19 2005 4:13pm
Subject:Re: mysql_free_result() WITHOUT mysql_fetch_row()
View as plain text  
Hello

> Have you try :
> select count(*) from mytable where id=x and list=something
> if count ==0, it's like fetchrow==NULL from your solution, but without
> all the fuss about use_result();

No, but looks fine, I didn't know this usage of count(*) combined with 
conditions, but now will use it :)

> Second solution :
> ALTER TABLE mytable ADD UNIQUE(id,list)
> which make a unique index on two field. inserting a duplicate value
> would give you back an error and let the table untouched.

Is it possible to do this during the creation of the table? my database is not 
large, it has just some records (by now is being tested only), so I can 
backup all data and build the table again.

Is there a MySQL manual I can download, apart of the one manual-split.tar.gz 
found in mysql.com? so I would be able to find a more generic or advanced 
usage?

Thanks for your patience :-)

Thread
mysql_free_result() WITHOUT mysql_fetch_row()Miguel Cardenas17 Sep
  • Re: mysql_free_result() WITHOUT mysql_fetch_row()Dan Nelson17 Sep
    • Re: mysql_free_result() WITHOUT mysql_fetch_row()Miguel Cardenas18 Sep
      • Re: mysql_free_result() WITHOUT mysql_fetch_row()Pooly18 Sep
        • Re: mysql_free_result() WITHOUT mysql_fetch_row()Miguel Cardenas18 Sep
          • Re: mysql_free_result() WITHOUT mysql_fetch_row()Pooly19 Sep
Re: mysql_free_result() WITHOUT mysql_fetch_row()Pooly19 Sep
  • Re: mysql_free_result() WITHOUT mysql_fetch_row()Miguel Cardenas19 Sep
    • Re: mysql_free_result() WITHOUT mysql_fetch_row()SGreen19 Sep