I found the solution by meself in the manual :)
mysql> INSERT INTO snoeien VALUES
mysql> ('Acer palmatum ''Atropurpureum''' , 10);
----- Original Message -----
From: Rudi Van Overloop - Tuinkrant <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 03, 2001 2:49 PM
Subject: newbie - quoute question
> Hi,
> i'm very new working with MYSQL,
> i have a problem with the type VARCHAR for plantnames,
> - MYSQL use single qoutes for a field
> - i have a plantdatabase, to use the correct spelling latin names cultivar names
>are wirting
> between qoutes
>
> Example:
> - For MYSQL i have to use this (I think) for the field Name VARCHAR (150) : 'Acer
>platanoides
> Globosum' ;
>
> - for a good use of plantnames i need this:
> Name VARCHAR (150) : 'Acer platanoides 'Globosum' ' ;
>
> ...it seems that doesn't work quit well for MYSQL:)
>
> Any idea if there is possebility to work arround this?
>
>
> Groetjes,
> Rudi Van Overloop,
> [EMAIL PROTECTED]
> Belgium
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
