Thanks if in case if we dont have the Item field in the Table B. wat to do..I
know the primary key to connect both the tables/
- Original Message -
From: ViSolve DB Team
To: Renish ; mysql@lists.mysql.com
Sent: Monday, November 27, 2006 12:48 PM
Subject: Re: MySql doubt.
Hi
Hi,
Obviously True.
Try mysql> show table status like 'tablename';
Check for Data_length & Max_Data_Length values which speaks about the used
memory size and allowed maximum size.
The max_heap_table_size system global variable impose the maximum size of the
memory table.
Try with
mysql > se
Hi,
Hope, a string constant can be searched against a column; Most of the
string function including find_in_set, allows us to display only the table
values and not the string constants passed.
Try it with 2 tables; or some userdefined functions.
Thanks
ViSolve DB Team.
- Original Message
Hi Renish,
Here's the answer for your query.
mysql> select * from a;
++
| item |
++
| book |
| pencil |
| table |
| chair |
++
mysql> select * from b;
++---+
| item | price |
++---+
| pencil | 11 dollar |
| book | 12 dollar |
At 08:31 PM 11/26/2006, John Kopanas wrote:
When I did a:
SELECT * FROM purchased_services WHERE company_id = 1000;
It took me 7 seconds. This is driving me crazy!
I am going to have to try this on another computer and see if I am
going to get the same results on another system. Argh...
T
Hi Guys,
I have an easy doubt..
Table A consist of field Item and Table B consist of field Price. Table A
consists of Items which has price aswell the items which doesnt have
price. But In Table B,I have kept only the item which has price . Now, I
want to subtract the total items in Tabl
Hi Guys,
I have an easy doubt..
Table A consist of field Item and Table B consist of field Price. Table A
consists of Items which has price aswell the items which doesnt have price.
But In Table B,I have kept only the item which has price . Now, I want to
subtract the total items in Table A
Yes... with FORCE INDEX it still takes 7 seconds.
On 11/26/06, Dan Nelson <[EMAIL PROTECTED]> wrote:
In the last episode (Nov 26), John Kopanas said:
> On 11/26/06, Dan Nelson <[EMAIL PROTECTED]> wrote:
> >In the last episode (Nov 26), John Kopanas said:
> >> Thanks a lot for your help.
> >>
> >
In the last episode (Nov 26), John Kopanas said:
> On 11/26/06, Dan Nelson <[EMAIL PROTECTED]> wrote:
> >In the last episode (Nov 26), John Kopanas said:
> >> Thanks a lot for your help.
> >>
> >> The query should and only does return 1-6 rows depending on the id.
> >> Never more then that. Here a
When I did a:
SELECT * FROM purchased_services WHERE company_id = 1000;
It took me 7 seconds. This is driving me crazy!
I am going to have to try this on another computer and see if I am
going to get the same results on another system. Argh...
On 11/26/06, Dan Nelson <[EMAIL PROTECTED]> wro
In the last episode (Nov 26), John Kopanas said:
> Thanks a lot for your help.
>
> The query should and only does return 1-6 rows depending on the id.
> Never more then that. Here are the comperative EXPLAINs:
>
> mysql> EXPLAIN SELECT * FROM purchased_services WHERE id = 1000;
> ++-
The application is not in production yet but when it will go in
production the server will be considerably faster and have much more
RAM. But before I put the app in production I want to make sure it is
working properly. 500K rows does not sounds like that much in this
day in age. If I understa
Thanks a lot for your help.
The query should and only does return 1-6 rows depending on the id.
Never more then that. Here are the comperative EXPLAINs:
mysql> EXPLAIN SELECT * FROM purchased_services WHERE id = 1000;
++-++---+---+-+--
In the last episode (Nov 26), Amit Dor-Shifer said:
> Hi,
> I tried setting 'bind-address' as an option from ~/.my.cnf:
>
> (amit0:~) # cat ~/.my.cnf
> [mysqld]
> bind-address 127.0.0.1
> (amit0:~) # mysqld
> 061126 16:08:54 [ERROR] mysqld: unknown option '--bind-address 127.0.0.1'
Try "bind-addr
Hi,
I tried setting 'bind-address' as an option from ~/.my.cnf:
(amit0:~) # cat ~/.my.cnf
[mysqld]
bind-address 127.0.0.1
(amit0:~) # mysqld
061126 16:08:54 [ERROR] mysqld: unknown option '--bind-address 127.0.0.1'
1. Is 'bind-address' then not an 'option'?
2. As 'bind-address' IS settable
15 matches
Mail list logo
