importing binary data

. more than happy to read the docs, just need a pointer to which docs I should be reading :) thanks Nathan -- Nathan Coast Managing Director Codeczar Ltd mob : (852) 9049 5581 tel : (852) 2834 8733 fax : (852) 2834 8755 web : http://www.codeczar.com -- MySQL General Mailing List For list archives

modifying prepared statement parameters

Hi, Is it possible to modify parameters passed to prepared statements? e.g. select ... where username like '%?%' I'd like to put wildcard chars '%' on either end of a parameter. Is this legal? or do I have to modify the parameter before passing it to mysql. thanks Nathan -- Nathan Coast

extracting ddl

Hi, is it possible to extract the ddl for a table or whole db? ie the ddl that would be needed to re-create that table. JBoss automatically creates some tables during ejb deployment and I want to move this to a manual process. cheers Nathan -- Nathan Coast Managing Director codeczar ltd

sub queries

select count(*) as RES from ACL_USER_GROUP_ROLE as UGR where UGR.USER_ID =2 and UGR.ROLE_ID = 3 and select ROLE_ID from ACL_ROLE where ROLE_NAME = 'projectmanager' cheers Nathan -- Nathan Coast Managing Director codeczar ltd mobile: (852) 9049 5581 email: mailto:[EMAIL PROTECTED] web