database fields

[Anon]

we have clob and blob as datatypes in all forms of databases.i refer to mysql and the problem i am facing is
1) while creation of the table ,how to mention the datatype size..
i.e. name of the field : movie
datatype :blob

so how do i mention the size.

2)how do i insert into the database a movie file along with other values of respective fields using inser statements.?

[[deleted]]

1) read the myqsl manual
2) you don't. It is extremely bad to insert binary data into a database. Use a normal file insterad, and only store the name of that file in the database.