Hi Victor,
You have given space after the comma(shown here: ('Small, Medium, XSmall')).
Take out the space and try, it will work.
Example:
mysql> insert into products(sizes) values ('Small,Medium,small,medium');
Query OK, 1 row affected (0.05 sec)
Regards,
Thiyaghu CK
www.mafiree.com
On Fri, J
OK, guys, I'm totally confused:
mysql> insert into products (SKU, Category, Name, Title, Description, Price,
SortFactor, Availability, OutOfStock, Weight, ShipFlatFee, ShipPercentPrice,
ShipPercentWeight, sizes, colorsShadesNumbersShort) values ("prodSKU1",
"prodCat1", "name1", "title1", "descr",
On Thu, 7 Jan 2010 15:48:24 +0200, "machiel.richards"
wrote:
> Hi All
>
> What the Oracle guys found was that some of the fields were blank even
> though the fields were configured as not nullable.
>
> I found that where this is the case, the users entered a blank space
>
On 1/7/10 3:10 PM, "Matt Neimeyer" wrote:
> I'm trying to select names at random from a table that contains the
> name and the frequency at which it is actually used in society. The
> table is defined as follows:
>
> CREATE TABLE `MaleNames` (
> `Name_ID` int(11) NOT NULL auto_increment,
> `Na
http://www.greggdev.com/web/articles.php?id=6
> -Original Message-
> From: Matt Neimeyer [mailto:m...@neimeyer.org]
> Sent: Thursday, January 07, 2010 12:10 PM
> To: mysql@lists.mysql.com
> Subject: Probability Selects
>
> I've tried Googling till my brain is fried and I'm obviously mis
I've tried Googling till my brain is fried and I'm obviously missing
something because I'm not finding anything useful.
I'm trying to select names at random from a table that contains the
name and the frequency at which it is actually used in society. The
table is defined as follows:
CREATE TABLE
Hi Machiel, all!
machiel.richards wrote:
> Hi All
>
> [[...]]
>
> What the Oracle guys found was that some of the fields were blank even
> though the fields were configured as not nullable.
>
> I found that where this is the case, the users entered a blank space
> which is
Hi All
Well I had some fun writing this cron , easy enough with all the help
you guys gave me...
Just some interesting info I want to share, maybe someone came across
this and can also give some thoughts...
What the Oracle guys found was that some of the fields were bla
- machiel.richards wrote
>
> How can we do this when running in a cron script?
>
Hi!
You can use following command in a shell script running from cron:
echo "select * from into outfile '/path/to/output/file' fields
terminated by '|';" | mysql --user= --password=
;
Bye!
It should be identical select statements which will improve performance and
not the updates.
Go through the below url for more information about optimization and
performance
http://dev.mysql.com/doc/refman/5.0/en/optimizing-the-server.html
On Thu, Jan 7, 2010 at 4:42 PM, F.A.I.Z.A.L wrote:
> h
hi
i can see many 'updates' is going every min. so is it good to increase this
query_cache_size ?..
what are the other action i can take to improve the performance of mysql
server
environment
version : 5.0.22
platform : redhat 5
Cheers
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.
If the queries are identical then Yes. If not it will degrade the query
performance.
Sent from BlackBerry® on Airtel
-Original Message-
From: "F.A.I.Z.A.L"
Date: Thu, 7 Jan 2010 15:51:19
To: Suresh Kuna
Cc:
Subject: Re: Are there any difference between max_connection and
max_
hi suresh
every 1 min nealy 40 to 80 users will hit the database. so, if i increase
query_cache_size it will avoid physical i/o and buffer missing?
Cheers
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com
On Thu, Jan 7, 2010 at 1:23 PM, Suresh Kuna wrote:
> Yes it won't allow exce
13 matches
Mail list logo
