help with SELECT

hi, i have the following table username | permission admin | view testuser | view user2 | write admin| write admin| change ... | ... i want to select all the permissions from admin. the normal query will output the following: admin - vie

how to make a column of a table unique

hi, i want a column only holding unique rows. do i have to declare this column as a primary key, or is there another possibility? thx bastian -- Externe Mail[EMAIL PROTECTED]31.07.200113:01

Antwort: Re: howto insert an image as blob?

first i would like to do it as you said. store the pictures outside the database. i develop jsp sites and my problem is that i dont know how to upload a file per jsp. i thought storing the pictures in mysql is the easier way to solve my problem. but if its not good to store binary data in the dat

howto insert an image as blob?

hello, plz can someone tell me howto insert an image as blob into a table. i have created a table with a blob column, but i dont know how to fill it with binary data like pictures e.g.. thx bastian - Before posting, please

howto insert an image as blob?

hello, plz can someone tell me howto insert an image as blob into a table. i have created a table with a blob column, but i dont know how to fill it with binary data like pictures e.g.. thx bastian - Before posting, please ch