Gaspar Bakos <[EMAIL PROTECTED]> wrote:
>
> I am trying to duplicate a row of a table in the following way:
>
> insert into Observer select * from Observer where OBid = 4;
> ERROR 1066: Not unique table/alias: 'Observer'
>
> It is a unique table; I mean there can't be another table named in the
David,
- Original Message -
From: ""David Griffiths"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Friday, May 14, 2004 8:05 PM
Subject: Re: InnodB Hot Backup Questions
> Sorry - haven't had a chance to respond till now.
>
> > > So "restore" == "apply-log", but one work
Matt,
InnoDB only supports multiple charsets and collations in the same
installation starting from 4.1.2. That might be associated with the problem.
Please wait that 4.1.2 is released.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot B
Rich,
I tested this with 4.0.12 on Linux, and it worked ok.
What has probably happened is that you have somehow managed to make the
foreign key definition in the child table not to match the column types or
names in the parent table. Maybe through DROP TABLE and recreating the
parent table. That
From http://dev.mysql.com/doc/mysql/en/Replication_Options.html
--log-slave-updates
Normally, updates received from a master server by a slave are not
logged to its binary log. This option tells the slave to log the updates
performed by its SQL thread to the slave's own binary log. For this
Hi, newbie here,
I have many tables to upload, but each time I try I get a syntax error
1064.
What format should my table be in?
I've been attempting to upload tab delimited text, but I can't get
past an error in line 1.
I can't see any errors.
thanks for any assistance
sfb
sbraun12twcny.rr.com
At 01:22 PM 5/18/2004, you wrote:
Here's my table:
CREATE TABLE 'data' (
'junk' char(10) NOT NULL default '',
PRIMARY KEY ('junk')
) TYPE=MyISAM;
There are about 1.7 million 10-character long strings. A query like this one
takes about 5 seconds:
SELECT junk FROM data WHERE junk='xx';
S
Hello all:
I have set the repliaction between A and B server successfully.
While the B server replicate the data from A server,we fould the relay log
refreshing.But the master log has no change.
Since we want to add a Server C to replicate the Server B, the master log must
existing a
Hi,
I am trying to duplicate a row of a table in the following way:
insert into Observer select * from Observer where OBid = 4;
ERROR 1066: Not unique table/alias: 'Observer'
It is a unique table; I mean there can't be another table named in the
same way.
Any pointer would be welcome. Probably
I asked a question earlier about how to handle lookup tables, I think this
is a little more clear as to what I was trying to ask.
if I want to relate a contact to an organization, I know I can create a
table that contains contact_ids and org_ids.
But, how do I enter that information gracefully, i
Sid Taleb wrote:
When I query I don’t see the value of some primary key, I don’t
understand why, Can you tell me?
Yes. There is a problem somewhere.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 99
Sonj McCoy wrote:
Hello Everyone,
I am having problems with foreign keys in MySQL InnoDB type databases.
For some reason, when adding a new record within an MS Access subform
(based on a query of two tables (parent table and child table), the
corresponding foreign key column in the child table not
On Tue, May 18, 2004 at 10:56:14PM +0200, Mark wrote:
> Mihail Manolov wrote:
>
> >>> Release 4.0.20 is mainly a bugfix release, but there are also some
> >>> important functional changes. Release 4.0.19 was completely skipped
> >>> over because Bug #3596 might have caused segmentation faults on s
It would be easier to help you if you did the following:
1. Tell us which version of MySQL you are using and on what operating system.
2. Supply the definitions of the tables.
3. Give a small sample of the data - just a few rows should be plenty.
4. Show us the query you are running which doesn't p
Let's see if I can give you some ideas.
> -Original Message-
> From: RV Tec [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 18, 2004 8:28 AM
> To: [EMAIL PROTECTED]
> Subject: MySQL limits.
>
> We have a database with approximately 135 tables (MyISAM).
> Most of them are small, but we
Hello Everyone,
I am having problems with foreign keys in MySQL InnoDB type databases.
For some reason, when adding a new record within an MS Access subform
(based on a query of two tables (parent table and child table), the
corresponding foreign key column in the child table not getting
popula
> I checked The Manual, which confirmed that 255
> characters is indeed the limit for text entries. But I
> wondered if there might be some workaround. If not,
> I'll just limit myself to smaller bytes!
At http://dev.mysql.com/doc/mysql/en/BLOB.html you can read about the BLOB
and TEXT column type
Use the blob/text, mediumblob/mediumtext or longblob/longtext types.
Since you are just storing text, use the text versions.
It sounds like when you say "text" what you really mean is the varchar()
type. If you declare a field as a text type, you can store 2^16
characters, or 65,536 characte
> I hear what you're saying about memory, but I really don't understand why
a
> btree lookup would be so dramatically slow compared to a linear search
with
> grep. Would something other than MyISAM be more appropriate here?
If you feel that a linear search is faster, why not try to let MySQL IGNOR
I was hoping to store some fairly large blocks of text
in a MySQL table, like brief accounts for all 50
states, such as this:
"South Dakota was long known as the Sunshine
State because it’s state motto, which was
depicted on the state flag, was “Sunshine
State.” In 1980, the motto, flag, and nickn
Hi, I need some help with an insert issue.
I have two tables, organizations and contacts.
Every contact relates back to an organization
Organizations has org_id, org_name, and org_address, etc
Contacts has contact_id, contact_name, contact_address and a foreign key
called c_org_id.
contact_id an
Dear List:
I wonder if there exist a type of table which can allow for unlimited or at
least more than 1024 columns? I know MaxDB has 1024 max columns.
Please give me a hint if you could. Thanks in advance!
Hongyu
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
T
We have one query which takes approximately 2 minutes. MySql seems to be
unresponsive to any other threads until this query has completed.
Are there some settings that aid with this kind of problem?
TIA
Dan
When I query I don’t see the value of some primary
key, I don’t understand why, Can you tell me?
Thank You
Sid Taleb
Information
Technology Manager
Credico Marketing
100 Alexis-Nihon, Suite
650
Montréal, Québec
H4M 2P2, CANADA
Tel: 1-866-CREDICO
(1-866-273-3426) ext. 252
Local: (51
Ben Ricker wrote:
I believe all the tables are MyISAM...the DB is 3.2.x.
I know there will be an inconsistency as we only do nightly backups; any
transactions that occur before the scp will not be there. If we failover
before the backup, we can have up to 24 hours of data missing.
I am concerned
I think I've got most of the basics of MySQL under
control now, and I'd like to ask a question about
formatting table data. I've learned to insert html in
my tables. For example, the following cell includes
the code for proper apostrophes and quotation marks:
Land of the Midnight Sun, The Last
Fro
On Tue 18 May 02004 at 04:53:52PM -0400, [EMAIL PROTECTED] wrote:
>
> Jacob,
>
> Don't worry about storing the leading the zeroes. Just left pad the
> subscriber column to be 4 digits on output and you should be golden. MySQL
> has a function just to generate left-padded numbers:
>
> LPAD(subscr
We have a MySQL server that is a backend processing server that in about 60
days will probably run out of disk space. The data cannot be archived off,
because it is always used and changed many times a day. The server
currently has 6 72 gig SCSI 15k drives in it. We have it raided with 2
drives
Mihail Manolov wrote:
>>> Release 4.0.20 is mainly a bugfix release, but there are also some
>>> important functional changes. Release 4.0.19 was completely skipped
>>> over because Bug #3596 might have caused segmentation faults on some
>>> platforms. The changelog below lists all the changes sin
Jacob,
Don't worry about storing the leading the zeroes. Just left pad the
subscriber column to be 4 digits on output and you should be golden. MySQL
has a function just to generate left-padded numbers:
LPAD(subscriber,4,'0')
Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce
Sorry, the variable is actually "key_buffer_size" (I don't use MyISAM);
I'm not sure what it defaults to, but the typical recommendation is 25%
of your memory.
You can tell if your cache is effective by looking at the key_reads and
key_read_requests (from the MySQL window, type "SHOW STATUS" wi
If I am correct, the NUMERIC data type is a string representation and will
contain leading zeroes if input as a string.
...
CREATE TABLE numbersTest (numCol NUMERIC(3));
INSERT INTO numbersTest VALUES('212'), ('069'), ('070');
...
The values with leading zeroes should be returned.
...
Create an ind
Hmm... I didn't have to upgrade our DBD drivers when we moved from
3.23.57 to 4.0.18. Strange you had to. Do you remember your old DBD
driver's version? Or was that only Win32 problem?
- Original Message -
From: "Mark" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>;
<[EMAIL P
I just did an upgrade from 3.23.54a to 4.0.18 for 4 DB servers. It was a
piece of cake. Some hints:
1) Run through the docs on changes from previous versions. Someone who
understands the DBs you will be moving would be helpful to look at it as
well.
2) that stuff about "security settings" i
At 15:46 -0400 5/18/04, Robert A. Rosenberg wrote:
I have a site that is being hosted by an ISP which is running
version 3.23.52. When I questioned why that downlevel version and
not a 4.0 version (such as 4.0.18 or the just released 4.0.20), I
was told "Unfortunately, when versions change on My
I believe all the tables are MyISAM...the DB is 3.2.x.
I know there will be an inconsistency as we only do nightly backups; any
transactions that occur before the scp will not be there. If we failover
before the backup, we can have up to 24 hours of data missing.
I am concerned that we will
On Tue 18 May 02004 at 02:48:45PM -0500, Victor Pendleton wrote:
> In this case creating separate columns and making the values integers as
> oppesed to varchar will increase your query speed.
Okay, I'll give that a try. How do I set up my column types so that a
leading 0 won't be stripped off?
On Tue 18 May 02004 at 12:26:41PM -0700, David Griffiths wrote:
>
> Is that the only table in your MySQL installation?
Yes, and no one has access to it yet but me.
>
> MyISAM primary keys are put in a b-tree index, which is cached by MySQL
> in memory in the key_buffer_size parameter. What is
Are you using only MyISAM or InnoDB tables? With the InnoDB tables you have
the possibility of data not yet being committed. Either way, unless you can
flush, lock and perform the dump and transfer all in one swoop you risk
incosistency using this method.
-Original Message-
From: Ben Rick
Can you mysqldump the table then rebuild the table from the dump file?
-Original Message-
From: Rich Schramm
To: 'Victor Pendleton'; [EMAIL PROTECTED]
Sent: 5/18/04 2:04 PM
Subject: RE: Alter table primary key and foreign keys
The error log shows nothing when the binary dies. I can't reb
In this case creating separate columns and making the values integers as
oppesed to varchar will increase your query speed.
-Original Message-
From: Jacob Elder
To: Victor Pendleton
Cc: '[EMAIL PROTECTED] '; ''[EMAIL PROTECTED] ' '
Sent: 5/18/04 2:11 PM
Subject: Re: Simple table, 1.7 mill
I have a site that is being hosted by an ISP which is running version
3.23.52. When I questioned why that downlevel version and not a 4.0
version (such as 4.0.18 or the just released 4.0.20), I was told
"Unfortunately, when versions change on MySQL, they also drop
features and change security s
At 12:30 -0700 5/18/04, Trevor Price wrote:
Mysqlians,
I just discovered that a server has ft_min_word_len=4 when I
want ft_min_word_len=3 . Do I have to rebuild all the fulltext
indicies so that searches on three-letter words will work correctly?
Yes.
Question:
Did you find some place in
Mysqlians,
I just discovered that a server has ft_min_word_len=4 when I want
ft_min_word_len=3 . Do I have to rebuild all the fulltext indicies so
that searches on three-letter words will work correctly?
Trevor
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Is that the only table in your MySQL installation?
MyISAM primary keys are put in a b-tree index, which is cached by MySQL
in memory in the key_buffer_size parameter. What is it set to on your
system (the my.cnf file, probably in /etc or /var)?
The second time you run it, the index is definately
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Mark wrote:
| Heikki Tuuri wrote:
|
|
|>Release 4.0.20 is mainly a bugfix release, but there are also some
|>important functional changes. Release 4.0.19 was completely skipped
|>over because Bug #3596 might have caused segmentation faults on some
|>pla
I am working on doing backups of a MySQl server that is running approx 20
databases. Our failover is to do a nightly scp of all /data directory from
one server to the backup. I know that replication or mysqldump would be
best, but I do not want to get into that.
My question is what is the bes
On Tue 18 May 02004 at 02:03:55PM -0500, Victor Pendleton wrote:
> From this explain plan it appears a full table scan will be done. What is
> the cardinality of this index?
>
Actually, they are phone numbers. I wasn't sure how this list would feel
about this but I am wring a National Do-Not-Call
The error log shows nothing when the binary dies. I can't rebuild the
child table - anything that touches the child table after the alter
stops the binary.
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 18, 2004 2:07 PM
To: 'Rich Schramm '; '[EMAIL
Any particular reason to use 2.4.x vs 2.6.x from kernel for base?
2.6 has not been around long enough to prove itself, in my opinion. I know 2.4
will work well, but I cannot say the same about 2.6 with the same degree of
confidence.
--
Sasha Pachev
Create online surveys at http://www.surveyz.co
>From this explain plan it appears a full table scan will be done. What is
the cardinality of this index?
-Original Message-
From: [EMAIL PROTECTED]
To: Victor Pendleton
Cc: '[EMAIL PROTECTED] '
Sent: 5/18/04 1:54 PM
Subject: Re: Simple table, 1.7 million rows, very slow SELECTs
On Tue 18
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Mark wrote:
| Heikki Tuuri wrote:
|
|
|>Release 4.0.20 is mainly a bugfix release, but there are also some
|>important functional changes. Release 4.0.19 was completely skipped
|>over because Bug #3596 might have caused segmentation faults on some
|>pla
On Tue 18 May 02004 at 01:47:25PM -0500, Victor Pendleton wrote:
> What is the cardinality of the `junk` column? What does an EXPLAIN Plan
> show?
>
mysql> explain select junk from data where junk='xx';
+-+---+---+-+-+--+-+
On Tue 18 May 02004 at 08:49:05PM +0200, Jigal van Hemert wrote:
> > There are about 1.7 million 10-character long strings. A query like this
> one
> > takes about 5 seconds:
> >
> > SELECT junk FROM data WHERE junk='xx';
> >
> > Subsequent queries for the same string return right away.
>
> There are about 1.7 million 10-character long strings. A query like this
one
> takes about 5 seconds:
>
> SELECT junk FROM data WHERE junk='xx';
>
> Subsequent queries for the same string return right away.
That's because you have the mysql query cache enabled and mysql can return
the an
What is the cardinality of the `junk` column? What does an EXPLAIN Plan
show?
-Original Message-
From: Jacob Elder
To: [EMAIL PROTECTED]
Sent: 5/18/04 1:22 PM
Subject: Simple table, 1.7 million rows, very slow SELECTs
Here's my table:
CREATE TABLE 'data' (
'junk' char(10) NOT NULL de
Can you use the actual IP address and get it to work? If so, then ping
localhost and ping tux and make sure the IP that you believe it should be is
actually being returned.
Lou
- Original Message -
From: "Timothy Waters" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 18,
Here's my table:
CREATE TABLE 'data' (
'junk' char(10) NOT NULL default '',
PRIMARY KEY ('junk')
) TYPE=MyISAM;
There are about 1.7 million 10-character long strings. A query like this one
takes about 5 seconds:
SELECT junk FROM data WHERE junk='xx';
Subsequent queries for the same
Heikki Tuuri wrote:
> Release 4.0.20 is mainly a bugfix release, but there are also some
> important functional changes. Release 4.0.19 was completely skipped
> over because Bug #3596 might have caused segmentation faults on some
> platforms. The changelog below lists all the changes since 4.0.18.
Sasha Pachev said:
> Steve Meyers wrote:
>> Has anyone else experienced this bug?
>>
>> http://bugs.mysql.com/bug.php?id=868
>>
>> We've been seeing this problem on several of our servers (see the last
>> comment to the bug). MySQL just hangs occasionally, it happens about
>> 3-4 times per month
Steve,
I have had this same problem exept the entire server does not hang, only
one thread which experiences a signficiat slowdown. This happens a
couple times a week for our 4 servers. I believe this is a thread
scheduling issue. The mysql support team suggests against using NPTL.
However, I u
MySQL manual Chapter 13 Section 5
-Original Message-
From: Charles King
To: [EMAIL PROTECTED]
Sent: 5/18/04 12:32 PM
Subject: Help with date queries
I'm looking for some queries or resources to help me create queries with
these date ranges. IE, I have a DB that I want to pull things out
I would first see if an upgrade to a later version of InnoDB tables is
possible.
What is being written to the error log?
The ALTER TABLE statement subtly creates a new table, with new contraint
names that the child table is unaware of, and drops the original table. Have
you tried rebuilding the chi
I do a small web hosting company and one of the ongoing issues we have is
keeping mysql user's passwords in sync with ldap/local passwords. Right
now I have a script in place to try and keep things in sync when they
change their local ldap password but it doesn't always work and it feels
like
Steve Meyers wrote:
Has anyone else experienced this bug?
http://bugs.mysql.com/bug.php?id=868
We've been seeing this problem on several of our servers (see the last
comment to the bug). MySQL just hangs occasionally, it happens about
3-4 times per month. We have 13 database servers, so that un
Folks, Tim,
Oops! Forgot to mention that... we are running MySQL 4.0.18.
Thanks a lot!
Best regards,
RV Tec
On Tue, 18 May 2004, Tim Cutts wrote:
>
> On 18 May 2004, at 2:28 pm, RV Tec wrote:
>
> >
> > Is MySQL able to handle such load with no problems/turbulences
> > at all? If so, what
I am using mysql 4.0.12 max-nt on Windows XP.
I have a master table with an int column as a primary key (bom_id) and a
second table that has a foreign key reference to the master column and
uses it as part of a composite key (bom_id, fc_date). Example:
**
bom_mstr
p
Hi,
I am installing MySQL to a single board computer with the ARM7 processor
and 32M of RAM, running Linux.
I was able to successfully cross compile and now run the MySQL server,
but even with my-small.cnf and tweaking values down it consumes all but
a few megs of my RAM, and I need at least 15M
At 18:07 +0100 5/18/04, James Tusini wrote:
I was wondering if there's a way to set a field to be a pattern of another
field in the same table, ie:
numberfile
1 xyz_1.jpg
2 xyz_2.jpg
3 xyz_3.jpg
.
.
nxyz_n.jpg
I'm achieving this through php but wa
I'm looking for some queries or resources to help me create queries with
these date ranges. IE, I have a DB that I want to pull things out of if
they fall within this range.
Since the beginning of this week
Since the beginning of this business week
7 days from today
This month to date
Last Mont
James Tusini <[EMAIL PROTECTED]> wrote:
> I was wondering if there's a way to set a field to be a pattern of another
> field in the same table, ie:
>
> numberfile
> 1 xyz_1.jpg
> 2 xyz_2.jpg
> 3 xyz_3.jpg
> .
> .
> nxyz_n.jpg
>
>
> I'm ach
I was wondering if there's a way to set a field to be a pattern of another
field in the same table, ie:
numberfile
1 xyz_1.jpg
2 xyz_2.jpg
3 xyz_3.jpg
.
.
nxyz_n.jpg
I'm achieving this through php but was curious to know if you could do it
At 11:53 -0400 5/18/04, Matt Mastrangelo wrote:
I'm running version 4.1.1-alpha. The 3 select statements below on
the following test table produce inconsitent results:
create table test (test varchar(20)) charset latin1 collate latin1_general_cs;
insert into test values ('abcField1');
insert into
At 09:15 AM 5/18/2004 -0700, you wrote:
does the myslqd user (probably mysql) have permissions to read the
/var/smack-data directory?
Cheers,
Trevor
JG wrote:
Trevor,
Yes & No.
I am doing a remote smack and super-smack is not installed on the remote
server.
(Should it be?)
On the local server,
Gabe,
There are actually some problems caused by how auto increments are tracked
in the database. We do our backups by using mysqldump at night and
preserving all of the log files that were created during the day. The
problem occurs during recovery where auto increment values can be
incremented
Hello
I am using MySQL v4.0.18. I am using the mysqldump program to do backups. I was
wondering how, if at all, does mysqldump preserver the auto_increment value?
When using phpmyadmin, there is an option to preserve the auto_increment value and the
resulting file has something like:
Mysql AB,
What is the roadmap for fully compliant GIS?
" The OpenGIS specification defines the following functions, which MySQL
does not yet implement. They should appear in future releases. When
implemented, they will provide full support for spatial analysis, not
just MBR-based support."
Tha
I'm running version 4.1.1-alpha. The 3 select statements below on the
following test table produce inconsitent results:
create table test (test varchar(20)) charset latin1 collate
latin1_general_cs;
insert into test values ('abcField1');
insert into test values ('abcField2');
insert into test va
Has anyone else experienced this bug?
http://bugs.mysql.com/bug.php?id=868
We've been seeing this problem on several of our servers (see the last
comment to the bug). MySQL just hangs occasionally, it happens about
3-4 times per month. We have 13 database servers, so that unfortunately
increas
On 18 May 2004, at 2:28 pm, RV Tec wrote:
Is MySQL able to handle such load with no problems/turbulences
at all? If so, what would be the best hardware/OS
configuration?
What is the largest DB known to MySQL community?
We regularly run databases with around 200 GB of data per instance,
On Tue, 18 May 2004 10:38:25 -0400
Thomas Trutt <[EMAIL PROTECTED]> wrote:
> Hello everyone,
>
> Is there a way to have the data in a table encrypted so that
> the MYD file
> can't be opened with a text editor and read??? I need to encrypt or
> some how make illegible numeric, date,
Hi!
InnoDB is a MySQL table type that provides FOREIGN KEY constraints,
transactions, row level locking and multiversioned concurrency control to
MySQL, as well as a commercial hot backup tool.
Release 4.0.20 is mainly a bugfix release, but there are also some important
functional changes. Releas
I have set all privileges in the user table to yes, as follows:
Select_priv enum --Y
Insert_priv enum --Y
Update_priv enum --Y
Delete_priv enum --Y
Create_priv enum -- Y
Drop_priv enum --Y
Reload_priv enum --Y
Shutdown_priv
I've been to that page (http://dev.mysql.com/doc/mysql/en/SHOW_WARNINGS.html) and as
you said, there are supposed to be warnings now. Do you have any ideas why I can't
view them?
Kathy
>>> Renato Cramer <[EMAIL PROTECTED]> 05/18/04 9:30 AM >>>
Hi Kathy,
Excuse me for duplicity.
Renato.
Hello everyone,
Is there a way to have the data in a table encrypted so that the MYD file
can't be opened with a text editor and read??? I need to encrypt or some
how make illegible numeric, date, text, and vchar fields.. Any idea???
Thanks for the help,
Tom T
--
MySQL General Mailing List
For
"Zachary Agatstein" <[EMAIL PROTECTED]> wrote:
> Well, in order to enforce referential integrity, I converted the tables to
> InnoDB. But referential integrity is still not being enforced. I use
> mysql version 3-23-54-nt, and the tables are generated through the use of
> dbdesigner (ver. 4.0
"Ronnie Regev" <[EMAIL PROTECTED]> wrote:
> Hi,
> Before I go on, I know nothing about mysql, but my db admin is out of town
> and I need to be pointed in the right direction please.
> Running red hat 7.3, mysql-3.23.58-1.73, phpMyAdmin 2.5.0-rc2, in a virtual
> hosting environment on Ensim webppli
I'm using version 4.1.1-alpha, running on RedHat Linux 9.
Victoria Reznichenko wrote:
Matt Mastrangelo <[EMAIL PROTECTED]> wrote:
How can an InnoDB table be created with case sensitive collation? The
example below creates two identical tables, one MyISAM and the other
InnoDB. The InnoDB fails
Hi,
Before I go on, I know nothing about mysql, but my db admin is out of town
and I need to be pointed in the right direction please.
Running red hat 7.3, mysql-3.23.58-1.73, phpMyAdmin 2.5.0-rc2, in a virtual
hosting environment on Ensim webppliance-3.5.20-7.
When using phpMyAdmin and attempting
The (+) indicates an OUTER JOIN.
This should work:
SELECT A1.store_name, SUM(A2.Sales) SALES
FROM Georgraphy A1 LEFT JOIN Store_Information A2
ON A1.store_name = A2.store_name
GROUP BY A1.store_name;
Scott Purcell wrote:
Hello,
I am working through a sql tutorial, and would like to perform this (wr
On Mon, May 17, 2004 at 04:07:53PM -0400, [EMAIL PROTECTED] wrote:
>
> SORRY
>
> My typo--- it is NOT ready for any kind of testing. At least I have not
> heard of anything
Heh :)
But do you know if anyone is already working on it?
Luis
I don't know of anyone yet. I don'
Hello,
I am working through a sql tutorial, and would like to perform this (written for
oracle) outer join using mysql.
SELECT A1.store_name, SUM(A2.Sales) SALES
FROM Georgraphy A1, Store_Information A2
WHERE A1.store_name = A2.store_name (+)
GROUP BY A1.store_name
I am reading the docs, bu
Philipp,
this is probably the bug that I fixed last night. It is present in all 3.23,
4.0 and 4.1 versions.
"
[EMAIL PROTECTED], 2004-05-18 01:53:06+03:00, [EMAIL PROTECTED]
mem0pool.c:
Fix a memory corruption bug: in 32-bit computers, every 4 billionth
malloc
outside innodb_additional_mem_
Folks,
I have a couple of questions that I could not find the answer
at the MySQL docs or list archives. Hope you guys can help me.
We have a database with approximately 135 tables (MyISAM).
Most of them are small, but we have 5 tables, with 8.000.000
records. And that number is to incr
Hi Katherine,
Sometimes happens, unfortunately, things as this:
http://dev.mysql.com/doc/mysql/en/SHOW_WARNINGS.html:
Note that the framework for warnings was added in MySQL 4.1.0, at which
point many statements did not generate warnings. In 4.1.1, the situation is
much improved, with warnings g
I have to re-create a table every month with a section of data from the
main table. I suppose this would be an excellent situation to use views
for but being as how MySQL doesn't have view capability yet I'm stuck
with this. It's not a big deal but I just want to make sure that
Creating, populati
I appologize if this is redundant for anyone who follows google
groups... Here's my post:
Via the tutorial at
http://www.analysisandsolutions.com/code/mybasic.htm,
I downloaded mySQL and have been running most things with sucess. In
case it is pertinent, I used the mysqld-max-nt --install command
Well, in order to enforce referential integrity, I converted the tables to
InnoDB. But referential integrity is still not being enforced. I use
mysql version 3-23-54-nt, and the tables are generated through the use of
dbdesigner (ver. 4.0.5.6 beta).
Here is a snippet of a "create" script:
==
Matt Mastrangelo <[EMAIL PROTECTED]> wrote:
> How can an InnoDB table be created with case sensitive collation? The
> example below creates two identical tables, one MyISAM and the other
> InnoDB. The InnoDB fails when inserting primary keys that differ in case
> only. What am I doing wrong?
Wh
On Tue, May 18, 2004 at 03:46:46AM -0700, JG wrote:
> At 11:31 AM 5/18/2004 +0100, you wrote:
> >On Mon, May 17, 2004 at 08:43:44PM -0700, JG wrote:
> >>
> >> Has ANYONE been able to get super-smack-1.2 to compile as-is on FreeBSD?
> >>
> >> ./configure --with-mysql
> >> make
> >> make install
> >>
1 - 100 of 116 matches
Mail list logo
