hi,
seems to be a temp table (sybase notation).
see max_temp_table_size
Mathias
Selon Emmett Bishop [EMAIL PROTECTED]:
Howdy all, I have a question about a SQL statement
that I'm trying to execute. When I execute the
statement I get the following error: The table
'#sql_bd6_3' is full.
What
Dear mysql supports,
I want to change the font color for database mysql , for example I want to
insert data with red color
when I select this data the font color is the default black.It's possible to
change the font color.
thank you.
--
MySQL General Mailing List
For list archives:
Greetings,
I'm facing a difficult query at the moment. I have tried many different
queries but still not get the desired result.
My case:
Tables:
shipped ( id, shipdate, sn);
undelivered (id, undate, sn);
return (id, redate, sn);
I need the following output:
DATE
Hi,
I think of using AES Encryption for some time now, because it seems to be
the most secure encryption method in MySQL at this moment and table
encryption of some sort is not possible. In the documentation I read BLOB
fields are recommended for storage of data with AES_Encrypt, otherwise you
Hi,
don't you really want to write also in Times new roman your mysql data ?
you forgot the tools, OS ... (client) or it's a big jock.
Mathias
Selon nicolas ghosn [EMAIL PROTECTED]:
Dear mysql supports,
I want to change the font color for database mysql , for example I want to
insert data
Greetings list,
In an analysis I was sent, there is 1 table with a simple set of rules, e.g.
a_table (id, day, max_hours, min_hours, min_days, start_time, stop_time,
max_attendants, ...)
No biggie there.
The problem is the user has to be able to define exceptions to those rules.
These
Is it good practice to have a primary key for a table even though the
table has a foreign key that is the primary key of another table? If so,
why is this the case? I would appreciate if you point me to some resources
that point out the advantages and disadvantages of both approaches. Thank
you.
As a follow up to my question, I did want to mention that the foreign key
I am using is unique.
- Asad
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello Michael!
Michael Gale wrote:
Hello,
I have finished reading something similer on the web, why is there a
2GB limit ?
I assume you are using Linux on an x86 compatible machine (Pentium,
Athlon, ...), so you have 32 bit addresses.
32 bit give you 4 G different values; as each
If your FK really is unique, you don't need two tables. Example
First table Second Table
ID FK
1 1
2 2
3 3
...
So you can make this one table. On other words, it would be a one-to-one
relation. And this would be one table. Only with a
Hello. I appreciate your input. To clarify, I will provide you with an
example:
I have a table called business and another one called food_business. The
field business_id is a primary key of table business and a foreign key of
table food_business. In this case, the foreign key is unique and
Thanks for the reply, but I think you misinterpreted what I'm looking
for here.
For the first query I want to be able to get a row record of (in one
query possibly)
team_name for first team (team_id1)
team_name for second team (team_id2)
and each of these team points
for a list of N games
I've been playing around with stored procedures and I seem to be able to
consistantly crash msqld but I'm unsure wether it's because I'm doing
something I shouldn't (SP newbie :]) or wether the issue's a bug in mysql.
I know I'm 'pushing my luck' with the code below but I was trying it out of
Hi Rob,
I've been playing around with stored procedures and I seem to be able to
consistantly crash msqld but I'm unsure wether it's because I'm doing
something I shouldn't (SP newbie :]) or wether the issue's a bug in mysql.
I know I'm 'pushing my luck' with the code below but I was trying
Hello!
another simpler solution :
...
Thanks, Mathias!
You helped me greatly!
Now my program works as desired.
--
Good luck!
Vladimir
Please avoid sending me Word or PowerPoint attachments.
See http://www.gnu.org/philosophy/no-word-attachments.html
--
MySQL General Mailing List
For list
Hi all,
I would need an oledb provider for MySQL. Do you know where I can found
a good one. Thanks in advance.
Leonardo J. Belén. A-AR
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Wednesday 15 June 2005 15:10, Martijn Tonies wrote:
Hi Rob,
I've been playing around with stored procedures and I seem to be able to
consistantly crash msqld but I'm unsure wether it's because I'm doing
something I shouldn't (SP newbie :]) or wether the issue's a bug in
mysql.
I
Hi all.
I am desperately seeking advice on quite unusual matter with MyISAM tables.
We have application with very large volume of data being posted into
database at once, and in order to speed process up,
an attempt to write MYD files by hand has been attempted. However, MySQL
wont load such
On Tuesday 14 June 2005 11:57 pm, Michael Gale wrote:
Even if I change the value to 2G it still will not load ? Because the
value was 500M before do I not have to remove the ib* files and have
them recreated ?
2g is still to large.. its 2gig for all buffer pools, not just that one..
I
Thank you. I know how to migrate tables using ALTER TABLE - my question has
more to do with *whether* I should migrate. For smaller databases (10mb in
size) is it really beneficial? Details in my original post quoted below.
Thanks again,
Michael
-Original Message-
From: [EMAIL
It is recommended that you upgrade to 4.0.x first from 3.23.xx,
because of any changes to the grant tables in the mysql database, make
sure you read the upgrade notes before upggrading, here's a good link
to upgrade,
http://dev.mysql.com/doc/mysql/en/upgrade.html
I find it very simple to zip all
At 04:32 AM 6/15/2005, you wrote:
Hi,
I think of using AES Encryption for some time now, because it seems to be
the most secure encryption method in MySQL at this moment
and table
encryption of some sort is not possible.
I really wish MySQL would support table wide encryption because more
If the government passes a law to
force this data to be encrypted,
The last thing I want is the Government mandating encryption for anyone. If
you want a law to help here, I'd rather there be a law forcing companies to
disclose which encryption scheme they're using, and which customer
Les Schaffer wrote:
Gordon Bruce wrote:
I just ran the creates on 4.0.20 on LINUX and 5.0.6 on Windows
upgrading to 5.0.6 solved the problem.
do i need to let MySQL developers know about this or do they monitor the
list or once a release is gone, i can assume THIS problem was fixed?
mos wrote:
At 04:32 AM 6/15/2005, you wrote:
Hi,
I think of using AES Encryption for some time now, because it seems
to be
the most secure encryption method in MySQL at this moment
and table
encryption of some sort is not possible.
I really wish MySQL would support table wide
In this case, business_id should be both the primary key and a foreign key.
If you don't set it as a primary key, then the database would allow
duplicate entries into the food_business table.
By implementing this simple rule, you can prevent a whole class of
application bugs from causing
Hello.
documentation available somewhere (except for sources) where one can
find how MYI files are organized?
I don't think other sources except internals.texi (located in the Doc
directory) are publicly available.
Sergei Rodionov [EMAIL PROTECTED] wrote:
Hi all.
I am
Hello.
I suggest you to check your procedure on the latest bk source, and
if the server keeps crashing report a bug.
Rob Hall [EMAIL PROTECTED] wrote:
I've been playing around with stored procedures and I seem to be able to=20
consistantly crash msqld but I'm unsure wether it's
At 14:57 +0100 6/15/05, Rob Hall wrote:
I've been playing around with stored procedures and I seem to be able to
consistantly crash msqld but I'm unsure wether it's because I'm doing
something I shouldn't (SP newbie :]) or wether the issue's a bug in mysql.
I know I'm 'pushing my luck' with the
I just moved my databases to 4.1 from 3.23. It went pretty smoothly.
First I used mysqldump to back up the data. Then installed 4.1. First
thing did was import only the mysql table. Then ran
/mysql_fix_privilege_tables command. After that I was able to login to
mysql with my old root password.
Why not use the .NET provider...
http://dev.mysql.com/downloads/connector/net/1.0.html
- Original Message -
From: Leonardo Javier Belén [EMAIL PROTECTED]
To: Dev - MySQL - MList mysql@lists.mysql.com
Sent: Wednesday, June 15, 2005 7:24 AM
Subject: Visual Basic .NET Oledb Provider
Hi
Hello All,
I am trying to install MySQL 4.1.12 on my Powermac G4. My OS is
10.4.1. I downloaded the binary distribution from the MySQL website.
I uncompressed it and opened the .dmg installer. I ran the installer.
Where it prompted for the Administrator's password, I gave it. The
It depends on what you need out of the database. Unfortunately
fulltext indexes
are still only supported by MyISAM which locks a good deal of the
tables we have
out of innodb. Also, we attempted to migrate some tables to innodb and system
performance got worse! No one ever responded to my
If it works fine currently, the rule usually is: don't mess with it. :) I
would stick with MyISAM if I were you, it should be plenty good enough for
such a small table and usage as you described.
If you are experiencing performance issues, I would recommend looking at
indexes if you haven't
Hi,
I am currently running a large database (around 20Gb) on a 32bit x86
Linux platform. Many of my larger data-crunching queries are disk-bound
due to the limitation described in the innodb configuration documentation:
*Warning:* On 32-bit GNU/Linux x86, you must be careful not to set
Why not go AMD-64? Dual Opteron, with 8/16/32 gig of RAM? Get a 3ware
SATA drive, and run Gentoo for AMD-64. You can increase your innodb
buffer pool to use almost all that space. You can make your buffer pool
as large as the physical RAM in your machine can support. No 2.5 gig per
process,
Danny Stolle wrote:
hi,
i would like to discuss 'user management' in mysql. Working with Oracle
you can assign users to roles giving them privileges provided by that
role. MySql doesn't have Roles. I have read (Managing and Using MySql,
O'Reilly) 3 options on managing users having multiple
http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html
Double check that mysqld is running. I usually find out that it's not
when I get that error.
kgt
Elton Hughes wrote:
Hello All,
I am trying to install MySQL 4.1.12 on my Powermac G4. My OS is
10.4.1. I downloaded the
Hello Kristen,
It looks like I am running mysqld.
- ps xa | grep mysqld
21281 p1- S 0:00.08 /bin/sh ./bin/mysqld_safe --datadir=/usr/
local/mysql/
21323 p1- R 0:00.98 /usr/local/mysql/bin/mysqld --defaults-
extra-file=/us
21324 p1- R 7:11.11 /bin/sh ./bin/mysqld_safe
Hi,
I've recently subscribed using the allow-subscribe method as described here:
Posting from an alternative address when post are allowed only to
subscribers.:
http://www.ezmlm.org/ezman/ezman1.html
But I'm still getting posts to the mysql lists on this address?? ezmlm did not
complain when
Hi,
A new version of MySQL Community Edition 5.0.7-beta Open Source database
management system has been released. This version includes support for
Stored Procedures, Triggers, Views and many other features.
It is now available in source and binary form for a number of platforms
from our
Mathias,
Thanks for the reply. I couldn't find a server
variable named max_temp_table_size but I did find
one named max_heap_table_size. Is that what you
meant? BTW, I forgot to mention that I'm using MySQL
4.0.20. Could it be that this variable that you
mention is only in later versions?
sorri it's tmp_table_size.
mysql show variables like '%table%';
++--+
| Variable_name | Value|
++--+
| innodb_file_per_table | OFF |
| innodb_table_locks | ON |
| lower_case_table_names | 1|
|
Mathias,
Here's the query:
UPDATE customer_indicator INNER JOIN
customer_listing_pref
ON customer_listing_pref.customer_id =
customer_indicator.customer_id
AND customer_listing_pref.store_id =
customer_indicator.store_id
AND customer_listing_pref.store_id = @OLD_STORE_ID
LEFT JOIN contact_log ON
Dear All,
I tried several times to install myodbc 3.51.11 in cygwin (newest, recently
updated version) without any success. ./configure works perfect, including
the optional packages unixodbc and mysql which I have already installed
without any problems. Make fails and make configure too. The
At 04:35 PM 6/15/2005, you wrote:
Mathias,
Here's the query:
UPDATE customer_indicator INNER JOIN
customer_listing_pref
ON customer_listing_pref.customer_id =
customer_indicator.customer_id
AND customer_listing_pref.store_id =
customer_indicator.store_id
AND customer_listing_pref.store_id =
Mike,
Thanks for the insight. The sent table has about 7
million records. The other tables involved have tens
of thousands of records or there abouts. Not your 100
million size but certainly worth exploring.
Thanks again,
Tripp
--- mos [EMAIL PROTECTED] wrote:
Tripp,
This problem
I agree The New AMD's (Can't say just opertron) but the 246 and 248 CPU's
are moving data between cpu and Ram at 6 gig per second versus 2gig for the
Xeon's peak right now.
The New opterons communicate with ram better than any other CPU on the
market and with the right MySql setup that is a huge
48 matches
Mail list logo
