On Monday, June 07, 2004 19:09, Michael Stassen wrote;
> This doesn't quite make sense. You seem to say that several rows
> will match
> but then you say only one will. It must be one or the other.
> Perhaps I've
> misunderstood you.
Firstly, Micheal thank you for your assistance; I'll elaborat
Russ,
We use #2 currently, and we are actually about to switch back to the
inserting them one at a time. The reason is very simple. In our case we
have a insert statement that will insert a maximum of 600 entries at a time.
But we could have up to 25 different programs running that could possibly
Hi,
I am really pleased with the new unicode features of MySQL4.1.2 alpha release. I am
just a little surprised that there is still only one API call which returns the
character set??? (And it returns the collating encoding instead of the real character
set?)
I was wondering if there is a way
Boyd,
First off, I should note that I haven't actually used EJB since about 1.1 or
so and have only been casually keeping up with some of the specs.
Therefore, some of what I say may be a bit out of date. Please ingest large
granules of salt while reading this.
What you're referring to is actual
All:
First let me say I know only the most basic of Java stuff.
I am working with a Java colleague on the development of a data model
(MySQL of course :-) and we seem to run into the problem an Entity Beans
cannot support joins. Can anyone tell me if this is true (If so, what
use are they for an
Never mind...I've fixed it.
Thanks
Michael
> -Original Message-
> From: DePhillips, Michael P
> Sent: Wednesday, June 09, 2004 4:17 PM
> To: '[EMAIL PROTECTED]'
> Subject: Replication died
>
> Hello -
>
> I just upgraded my master to 4.0.20 from 3.23.54 (ran the
> mysql_fix_privileges
I am having the same problem that someone else posted about back in
December and I didn't see any responses for:
http://lists.mysql.com/mysql/156346
Specifically, I am trying to link with libmysqld.a on Mac OS X and am
getting 16 undefined link errors such as fixsfdi, floatdisf, udivdi3,
moddi3,
J S said:
>
>
>> > Hi,
>> >
>> > I need some help please! I have 60GB of proxy logs to parse and load
>> into a mysql database. I've written a parsing script but I'm stuck
>> now on how to load the data in.
>> >
>> > I have a database called PROXY_LOG with 2 tables:
>> >
>> > USER_TABLE
>> > user
> Hi,
>
> I need some help please! I have 60GB of proxy logs to parse and load
> into a mysql database. I've written a parsing script but I'm stuck now
> on how to load the data in.
>
> I have a database called PROXY_LOG with 2 tables:
>
> USER_TABLE
> user_id date_time url_id size
>
> and
TIMESTAMP has a resolution of only 1 second. Not good enough as a primary
key for most applications. You may want an auto_incrementing int field (or
bigint depending on the size of your data) and make that your primary key.
Only the first TIMESTAMP column is automatically updated with the update
At 02:34 PM 6/9/2004, you wrote:
Hi,
I need some help please! I have 60GB of proxy logs to parse and load into
a mysql database. I've written a parsing script but I'm stuck now on how
to load the data in.
I have a database called PROXY_LOG with 2 tables:
USER_TABLE
user_id date_time url_id
At 15:53 +1000 on 06/07/2004, Ligaya Turmelle wrote about Re: Advice
on Database Schema Design:
I think I get what you are trying to do and it sounds good (though I am
still a beginner). The only thing I can think that might cause a problem is
since you have more then a couple of tables you MAY
Scott Fletcher wrote:
I read some articles that the use of SQL's TIMESTAMP in a table is use
for recording the actual date/time that the row was inserted and for
row(s) that is/are updated. I'm a little troubled by that because I
want a table with a timestamp in the first column to be the transac
Does anyone know of a way to use a SELECT statement to get the default value
for a column?
A DESCRIBE tabl_name col_name gives the values, but I need it inside a
SELECT.
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.my
Hi,
I am using MySQL 4.0.17. When I try to create a foreign key on a field of
the type text, I get this error:
040609 15:02:31 Error in foreign key constraint of table db_name/tb_name:
There is no index in the table db_name/tb_name where the columns appear
as the first columns. Constraint:
FOREIG
I read some articles that the use of SQL's TIMESTAMP in a table is use
for recording the actual date/time that the row was inserted and for
row(s) that is/are updated. I'm a little troubled by that because I
want a table with a timestamp in the first column to be the transaction
date which can be
Hello -
I just upgraded my master to 4.0.20 from 3.23.54 (ran the
mysql_fix_privileges script)
My slaves are all 4.0.[16,17,18]
All seems well EXCEPT the Slave_IO_Running will NOT start.
All my slave a stuck at the point prior to the upgrade.
Error logs reveal nothing out
Hello,
I have had a few systems that began to generate max connection errors. When I
run a processlist, there are a lot of the following entries:
5899 | unauthenticated user | xx.xx.xx.xx | NULL | Connect | NULL |
Reading from net | NULL |
When I restart mysql the entries are t
J S said:
> Hi,
>
> I need some help please! I have 60GB of proxy logs to parse and load
> into a mysql database. I've written a parsing script but I'm stuck now
> on how to load the data in.
>
> I have a database called PROXY_LOG with 2 tables:
>
> USER_TABLE
> user_id date_time url_id siz
Hi Markus,
You cannot use sub-query in mysql 3.23.49
Regards,
Laercio Cavalcanti.
-Original Message-
From: Markus Källander [mailto:[EMAIL PROTECTED]
Sent: quarta-feira, 9 de junho de 2004 13:25
To: [EMAIL PROTECTED]
Subject: UPDATE...WHERE ... IN (SELECT...)
Hi all,
Can someone te
Hello,
I was wondering what happens when you change table types. Does MySQL
automatically get rid of the old table files? I'm looking into changing
out some tables from MyISAM to InnoDB. I'm not tight on space, but I
wasn't sure how it handled the conversion, since the storage location
changes wit
Hi,
I need some help please! I have 60GB of proxy logs to parse and load into a
mysql database. I've written a parsing script but I'm stuck now on how to
load the data in.
I have a database called PROXY_LOG with 2 tables:
USER_TABLE
user_id date_time url_id size
and
URL_TABLE
url_id url
Dan
Great suggestion also.
-Blake
Dan Nelson wrote:
In the last episode (Jun 09), Blake Schroeder said:
Query
UPDATE table SET 1 = '1' WHERE id = '1'
|#1064 - You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near
Paul
Thanks alot that help out alot.
-Blake
Paul McNeil wrote:
You have to use
UPDATE MyTABLE set MyTABLE.1 = myValue.
Otherwise you are saying that the numeric value 1 = some other numeric
value.
God Bless
GOD BLESS AMERICA!
To God Be The Glory!
--
MySQL General Mailing List
For list arc
In the last episode (Jun 09), Blake Schroeder said:
> Query
> UPDATE table SET 1 = '1' WHERE id = '1'
>
> |#1064 - You have an error in your SQL syntax. Check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near '1 = '1' WHERE id = '1'' at line 1
Mys
You have to use
UPDATE MyTABLE set MyTABLE.1 = myValue.
Otherwise you are saying that the numeric value 1 = some other numeric
value.
God Bless
GOD BLESS AMERICA!
To God Be The Glory!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
The type is a varchar.
-Blake
Ronan Lucio wrote:
Blake,
Query
UPDATE table SET 1 = '1' WHERE id = '1'
|#1064 - You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near '1 = '1' WHERE id = '1'' at line 1
Is the
Blake,
> Query
> UPDATE table SET 1 = '1' WHERE id = '1'
>
> |#1064 - You have an error in your SQL syntax. Check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near '1 = '1' WHERE id = '1'' at line 1
Is the column 1 string type?
If it´s numec type. Y
> I am having a update problem, I have a table that has 28 columns they
> are name 1-28. I am able to insert data into the table. When I try to
> update info into the table it does not work. Any ideas?
1) What are the QUERY you´re using to UPDATE datas?
2) What is the error message?
3) What are t
Sorry
Query
UPDATE table SET 1 = '1' WHERE id = '1'
|#1064 - You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near '1 = '1' WHERE id = '1'' at line 1
-Blake
|
Dan Nelson wrote:
In the last episode (Jun 09), Blake
Has anyone seen a post on this issue? If not, can anyone offer any advice?
I have a TBL of users and I have created a search screen where you can type
in first or last name and it will retrieve the appropriate records. Here is
the statement:
"Select * from STUDENTS WHERE FName LIKE '%" .$_R
In the last episode (Jun 09), Blake Schroeder said:
> I am having a update problem, I have a table that has 28 columns they
> are name 1-28. I am able to insert data into the table. When I try to
> update info into the table it does not work. Any ideas?
Not until you tell us the error message.
I am having a update problem, I have a table that has 28 columns they
are name 1-28. I am able to insert data into the table. When I try to
update info into the table it does not work. Any ideas?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:ht
How do I turn on the General log file in version 3.23.52? Can I put an entry in the
my.cnf file and reboot?
Thanks,
Don
Webyog has released SQLyog 3.71 & SQLyog Job Agent (
SJA ) v2.0
Some of the major features added in SQLyog 3.71 are -
-- SQLyog Notification Services - This new feature
allows delivery of formatted resultset(s) over email
at scheduled intervals.
-- SQLyog Database Synchronization Tool now suppor
On Wed, 9 Jun 2004 18:25:11 +0200
Markus Källander <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> Can someone tell me what is wrong with this statement?
>
> UPDATE nummer SET gold = '1' WHERE anr IN (SELECT no FROM gull);
>
> I use MySQL 3.23.49.
^^^
4.1 or higher is required f
> -Original Message-
> From: Markus Källander
> [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 09, 2004 10:25 AM
> To: [EMAIL PROTECTED]
> Subject: UPDATE...WHERE ... IN (SELECT...)
>
>
> Hi all,
>
> Can someone tell me what is wrong with this statement?
>
> UPDATE nummer SET gol
Sub-select not supported in version you are using.
-Original Message-
From: Markus Källander
To: [EMAIL PROTECTED]
Sent: 6/9/04 11:25 AM
Subject: UPDATE...WHERE ... IN (SELECT...)
Hi all,
Can someone tell me what is wrong with this statement?
UPDATE nummer SET gold = '1' WHERE anr I
Hi all,
Can someone tell me what is wrong with this statement?
UPDATE nummer SET gold = '1' WHERE anr IN (SELECT no FROM gull);
I use MySQL 3.23.49.
Thanks
Markus Källander
Hi!
How did you install OpenSSL? From source or packages (e.g. debian or rpm).
In
that case you also have to install the dev-Package of OpenSSL
(openssl-dev)
Sincerly,
Oliver
I was able to repeat this situation.
It happens only when OpenSSL is installed to non-standart
directory and no OpenSSL
Hi. Hope someone can help me. I am running MySQL on a NetWare 6.x
server. I am using Veritas BackupExec. I currently manually copy the
files before a backup or manually unload the MySQL server. I would like
to automate the backup. What is the best way to do a backup on a
NetWare server.
Th
hello-
i am running into trouble compiling on redhat 7.2 (2.4.7-10)
configure and make run without dying - make test however produces the
following output:
02:17:35([EMAIL PROTECTED])/tmp/source/mysql-4.1.2-alpha>make test
cd mysql-test ; ./mysql-test-run
Installing Test Databases
Removing Stale
On Wed, Jun 09, 2004 at 01:45:49PM +0100, Marvin Wright wrote:
> Hi,
>
> We are about to build some new database servers and I have some questions
> which I'd like some advice on.
>
> The machines we are building have 4 Xeon 2GHz CPU's, 4 x 32GB SCSI disk
> using RAID 1+0 (so thats 64GB of storag
Hi,
We are about to build some new database servers and I have some questions
which I'd like some advice on.
The machines we are building have 4 Xeon 2GHz CPU's, 4 x 32GB SCSI disk
using RAID 1+0 (so thats 64GB of storage) and 4 Gig of RAM.
The OS will be Redhat 7.3.
Other than the mysql database
On Wed, 9 Jun 2004 12:58:01 +0200, Jigal van Hemert <[EMAIL PROTECTED]> wrote:
Anyway, my question is this. If I do a single-statement multi-line
insert,
are the auto-increment IDs of the rows inserted guaranteed to be
sequential? Bear in mind also that I'm using InnoDB tables here.
Conversely,
How did you install OpenSSL? From source or packages (e.g. debian or rpm).
In
that case you also have to install the dev-Package of OpenSSL
(openssl-dev)
Sincerly,
Oliver
Craig Harding wrote:
No one else has had this problem? Just wondering if this may be a bug in
the configure script...
c
Hi Michael,
Thankyou for your reply, unfortunately I am unable to use InnoDB tables...
From: Michael Stassen <[EMAIL PROTECTED]>
To: shaun thornburgh <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: DELETE from more than one table
Date: Tue, 08 Jun 2004 12:50:39 -0400
The
No one else has had this problem? Just wondering if this may be a bug in
the configure script...
craig.
Craig Harding wrote:
I'm configuring mysql-4.0.20 source and I have openssl (OpenSSL 0.9.7d
17 Mar 2004) installed in /usr/local/ssl (default)
Below is the output from a make after configurin
> Anyway, my question is this. If I do a single-statement multi-line insert,
> are the auto-increment IDs of the rows inserted guaranteed to be
> sequential? Bear in mind also that I'm using InnoDB tables here.
>
> Conversely, if I know for a fact that it is not guaranteed, I know that I
> need to
Hi,
> Is it possible (stable and without data loss :-)) to run e.g.
>
> mysql-3.23.40 on Port 3306
>
> and
>
> mysql-4.0.20 on Port 3307
> on the same machine (SuSE Linux with 2.4.4-kernel)
yes
> !AND! on
> the same data-directory without the two versions conflicting (e.g. when both version
>
Hello,
I tried searching the archives for this, but since the search tool is
returning no results when searching for 'INSERT' I figured it's not
working. :-)
Anyway, my question is this. If I do a single-statement multi-line insert,
are the auto-increment IDs of the rows inserted guaranteed
[EMAIL PROTECTED] wrote:
> is that a problem?
> I want to avoid ftp db.txt files and then mysqlimport them
You should run mysqlimport on the Windows box and specify MySQL server host with -h
option.
>
> - Original Message -
> From: "Egor Egorov" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECT
May be a full off the filesystem where the relay logbin file is ?
Marc.
-Message d'origine-
De?: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Envoye?: mercredi 9 juin 2004 09:46
A?: [EMAIL PROTECTED]
Objet?: Replication is currupted ...Please help me...
Hi all.
My company has three Mys
Hello *,
a) what could be reason /solution for the following Problem:
ERROR 1016: Can't open file: '#sql-407f_f.MRG'. (errno: 144)
b) in which directory the below reported intermediate file should
be generated
mysql> use syslog
Database changed
mysql> ALTER TABLE logs UNION=(
logs_2004
Hi there,
just one quick question I didn't find an answer in the docu:
Is it possible (stable and without data loss :-)) to run e.g.
mysql-3.23.40 on Port 3306
and
mysql-4.0.20 on Port 3307
on the same machine (SuSE Linux with 2.4.4-kernel) !AND! on
the same data-directory without the tw
Hi all.
My company has three Mysql DB servers.
one is master, the other are slaves.
master's version is 3.23.54-log.
two slaves's version is 4.0.17
and Os of all servers is linux 7.3
2 days ago, another slave's replication was currupted unexpactedly, but the other
slave was ok.
I don't
56 matches
Mail list logo
