Help with MySQL

[Anon]

Every time I run a command from the shell
i.e. mysqltest,etc., I receive error command: 'error while loading shared libraries: libmysqlclient.so,10:cannot load shared object file: no such file or directory"

Can someone help.

Thank's ...

[Anon]

MYSQL is not installed properly, install in again

cheers
kalyan

[mrskhris]

Check your enviroment variable LD_LIBRARY_PATH
echo $LD_LIBRARY_PATH
If it is empty, set it to a directory where you have libmysqlclient.so. Sometimes (in case of custom install) these files get placed in some strange directory.
Try:
find / -name libmysqlclient.so
(but you have to be root to search all your directories)

then
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:libmysqlclient_directory_here

P.S. I'm assuming you work under Unix

[Anon]

hello

i am working in mysql i have two table one primary key of one table is going as foreign key in the other table i want to make a outer join here currently i am running this query which is just showing my table records not of the second i want to show records of both table weather the condition full fill or not

as in the master table i have products but their relevents weights are not entered in the other table so they are null currently i am running this query so help me

select plength, pwidth, pheight,sc_products.product_id, product_name from sc_products LEFT JOIN product_dim ON product_dim.product_id= sc_products.product_id

thanks

arif