Hi!
Pag wrote:
If i was too confusing, maybe this helps: How can i delete the
records whose "num" field is 4,78,34 and 23, all in one command?
Something along "delete * in 'table' where num=1 and num=13 and num=34"
etc.
"DELETE FROM table WHERE num=1 OR num=13 OR num=34"
or better:
http:/
Doug Beyer wrote:
create table t1 ( id varchar(5) not null, name varchar(5) not null );
insert into t1 ( id ) values ( "1234" );
select count(*) from t1 where name is null; --> Result = 0
select count(*) from t1 where name = ""; --> Result = 1
Questions:
1) Why did the insert succeed sinc
Hi!
I've got the following problem with Version 4.0.9 of Mysql:
The page
http://www.mysql.com/doc/en/COMMIT.html
says:
'If you do a ROLLBACK when you have updated a non-transactional table
you will get an error (ER_WARNING_NOT_COMPLETE_ROLLBACK) as a warning.
All transactional safe tables will be
