facing problem with is null in stored procedure

delimiter // create procedure sample1(in p_item varchar(30), in p_size varchar(6), in p_quantity decimal(10,3), in p_unit varchar(3), in p_autoincrement varchar(30), out v_mess varchar(50) ) begin declare done int default 0; declare v_bhqty decimal(10,3); declare v_bhunit varchar

success return from mysql_query() when error return was expected

Hi everyone -- I'm a MySQL noob. I have MySQL queries in my C code and I was surprised to find I'm getting a success return from: mysql_query(pmysql, "select * from usrs where(usr=\"illegal name\""); In this table called "usrs," "usr" is the primary key and the engine is myisam. I expected

Re: Problem compiling mysql-5.1.33

most likely a missing include it should have at least: #include #include Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem schrieb: > make all-am > Making all in mysql-test > Making all in lib/My/SafeProcess > g++ -DHAVE_CONFIG_H -I. -I../../../../include -O3

Newbie --- JOINS

Picture does not seem to have been carried in the message, posts with attachment did not seem to get through either. So hope the link works. Below is the ER diagram in an exercise I am trying to do. http://www.probowluk.co.uk/images/er_ECA_001.jpg It's been going well so far, and several Col

Re: AMD64

MySQL converts MYSQL_TYPE_LONG to float before storing http://dev.mysql.com/doc/refman/5.1/en/c-api-prepared-statement-datatypes.html ? Where does it say that? All in all, datatypes are datatypes, despite platform. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Dow