mysql and leftt outer join

Lets say I have a Database defined as create table Photos ( PhotoIdxVarchar(20), PhotograherIdx varchar(20), PhotoTypeIdxvarchar(20), CameraIdx varchar(20) PhotoDate DateTime ); Create table Photographer ( PhotographerIdx

calc field ?

How do you set up calculated fields in mysql? Thx,Terry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysqldump ?

I have a mysql 3.23 running under win98. I also have a database with a largeblob, which has a jpeg image in it. Now I am trying to upload this to a free server using the following command to export the table: bin/mysqldump -u user --password=mypass mydatabase mytable dumpdir\mytable.sql The

Re: mysqldump ?

For the free web server, the transfer was web based using MyPHPAdmin. To test it on my RedHat 8.0 box(my home network server,) I copied the file to my Samba directory with Windows Explorer Then I switched over and signed on and did the import. On Wed, 15 Oct 2003 11:37:32 -0500, Paul DuBois

RE: mysqldump ?

truncate the text lines containing the blob data which would then create corrupted images. -Original Message- From: Terry Cheryl Haimann [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 15, 2003 11:11 AM To: mysql Subject: mysqldump ? I have a mysql 3.23 running under win98. I also have

mysql scripts

Is there a webpage or something I can read about creating a script that can be ran from mysql prompt with the ./ . My script doesn't seem to work, even though it looks like legal sql to me. I am running this under win98. Terry

Blobs

Is there an easy way to see If and how much data I have written into a blob? sql...tomakefilterhappy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

mysql grant ?

I want to give read access to all users on the localhost for a specific mysql table, I have tried the following: grant select on database.table to %@localhost; grant select on database.table to %@localhost; grant select on database.table to @localhost; None seem to work, what is the correct

Security

I was reading a book at BN yesterday which left me with the impression that in MySQL you can do the following: Define a group with specific security access. Then define a list of users that inherit this groups security settings. Is this correct? If so, will this work under the Windows

mysql kylix

I have a copy of Kylix 1.0, which I put on a recent RH 7.3 install. It is running MySQL 3.23.49. I therefore d/l 3.23 driver for kylix. I then did the following: *Copied the driver to the kylix\bin file *Created the symbolic link(Does it matter what dir this is executed