Can anybody in the house help me out with the SQL syntax for inserting an already existing pdf document into a MySQL DB. I tried this out
/* INSERT INTO new_book VALUES(1,"C:\Documents and Settings\OBl OKOYE\My Documents\pdfs\ajax in action";*/
but it never works.
N.B:I set the column type to be a BLOB

Provide the table Create statement

create table new_book
>ID INTEGER not null autoincrement PRIMARY KEY,
>NAME VARCHAR(45) not null,
>ISBN INTEGER NULL,
>BOOK BLOB NOT NULL;
Do bear with my syntactical errors because i used a GUI tool when i created the table.It's been a while i did this the hard way.Thanks

you are inserting values into the ID column and Name column however, The NAME column is a varchar(45) and the value you're inserting is way more than 45 characters, but really u want that information to go into the BOOK column. so that is not going to work because your ID, NAME, BOOK, columns are not null, and u are only passing values into two columns making one not null column empty.
you don't have to pass a value into the autoincrement field since the db takes care of that

this is the fix you have to pass a value into a NOT NULL column if you don't, it is not going to work

INSERT INTO new_book (NAME,BOOK) VALUES('name of book','C:\Documents and Settings\OBl OKOYE\My Documents\pdfs\ajax in action' )

Always remember to check your table structures before writing your statements

why not paste the error message you receive so that we can know what went wrong

look at the table structure and look at the insert statement, you should be able to figure out what is wrong.

incompatible data types, field mismatch, error in syntax.

you dont need error message to see what is wrong

i redid the INSERT this time it worked. One thing though, the file size in the DB (88 bytes)is different from the file size in my filesystem(34mb). I don't know if this is wrong.Thanks for all the help anyways.

provide detailed description of the file size, which file or if u can provide screenshot that will be helpful

i am glad the statement is working now GL.


r u refering to the blob size of the pdf compared to the actual pdf file itself?

I actually was talking about the pdf's blob size in the DB being 88bytes while the pdf in my filesystem is 34.8mb. i actually expected that both of them be the same size. Pardon me i've only been toying around with varchars and integers.Appreciate the help

u r storing the file path (C:\Documents and Settings\OBl OKOYE\My Documents\pdfs\ajax in action) as a blob that is in my opinion that is where the 88bytes come from. If u r only storing the path file well maybe the blob data type may not be the best to use. u can look into text, or varchar(255).

I am not really familiar with blobs and how it works

As already mentioned, you are just storing the file path, and not the pdf itself. I am thinking you wanted to store the pdf and that's why the column is defined to hold a BLOB. Verify your requirements and define the columns appropriately or change your insert statement. No need to define a column as BLOB if it's only going to store a string as you are doing.

You can also use the describe statement to verify your table's structure. As in DESCRIBE yourTableName

i've attached a description of the table. how exactly do i insert the pdf into the DB. all the texts i've read refer to BLOBs as the means by which such info is inserted.

look at this link

http://www.devarticles.com/c/a/MySQL/MySQL-and-BLOBs/3/

good luck blobbing


Do you want to store the pdf in a folder or u want to store it in the database?

I want to store pdfs in a Database

Dont know how that will work look at the link in my previous post that should give u an idea.

good luck

if u have problems next time, post detailed descripitions of everything, someone may know all the solutions or some of the solutions, post pictures if possible, post codes whenever applicable

that will make things faster. because someone that saw your previous post only asking about insert statement and the person knows the solution to the inserting the pdf in database may not even bother about looking at this thread again. so to get the most post all your questions.

Thanks for all the help.Ciao