> I tried this and doesn't work unforunately. I get "ERROR: Duplicate
> entry..." that occurs when copying from the temporary table back into
> the original table.
> Is there a way to do this, to copy a single record, without moving the
> primary key into the temporary table so I can avoid this
I tried this and doesn't work unforunately. I get "ERROR: Duplicate
entry..." that occurs when copying from the temporary table back into
the original table.
Is there a way to do this, to copy a single record, without moving the
primary key into the temporary table so I can avoid this error?
Ar
Jeremy wrote:
I've been looking though "MySQL" by Paul DuBois (second edition) and the
MySQL docs at http://www.mysql.com/doc/en/Date_and_time_functions.html
(and others).
I'm looking for a MySQL function that returns the unix time (second
since epoch), and there doesn't seem to be one.
UNIX_TI
On Tue, Feb 17, 2004 at 09:19:26PM -0500, Jeremy wrote:
> I've been looking though "MySQL" by Paul DuBois (second edition) and the
> MySQL docs at http://www.mysql.com/doc/en/Date_and_time_functions.html
> (and others).
UNIX_TIMESTAMP(NOW())
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux M
My client reported the a case to me. He said one mysql table lost some of
the data. The table structure is shown as follows:
+---+---+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+---+-
What are the options to load data infile when not all lines in the file are
perfect.
For example, I have a 12 field file, but some of the data in the lines is
bad, could contain 10 or less, I just want to let those go in in the order
they are in.
--
---
Ari Denison wrote:
I have a need to duplicate individual records in a table with a large
number of fields.
This is not part of a backup or restore process. I simply need to be
able to duplicate a record or two on occasion.
Is there an efficient way to do this?
I obviously don't want to duplic
Cira Account wrote:
I apologize if the listings below are badly
formatted. I am posting this from a webmail client
and it has very short line lengths.
I am using MySQL 4.0.17 on QNX 6.2.0. I can connect
by typing "mysql -u root" from the command line.
However, I get:
Database connect failed
I've been looking though "MySQL" by Paul DuBois (second edition) and the
MySQL docs at http://www.mysql.com/doc/en/Date_and_time_functions.html
(and others).
I'm looking for a MySQL function that returns the unix time (second
since epoch), and there doesn't seem to be one.
Using a PHP script,
I have a need to duplicate individual records in a table with a large
number of fields.
This is not part of a backup or restore process. I simply need to be
able to duplicate a record or two on occasion.
Is there an efficient way to do this?
I obviously don't want to duplicate keyfields, just
> I have reproduced this on two Windows 2000 boxes. What's going on? Why do
> I keep adding on to the result set? When I drop back down to 4.0.13 this
> problem disappears! Is this a bug in 4.0.18?
Bruce, this is curious. To help us reproduce this, can you either
upload the table in question to
I am using snort with mysql and am noticing
significant increases in response time, I think this
is due to data growth but I am still reading the docs.
Are there a few commands to check the db, and possibly
improve performance response time? Any pointer to
admin commands section welcome.
On Tue, Feb 17, 2004 at 01:18:45PM -0800, lee wrote:
> We are trying to do some capacity planning, and we need to know how MySQL
> allocates the the filespace in the directories set by the tmpdir
> configuration parameter.
>
> The manual simply states:
> "...It may be useful if your default /tmp
Hello.
I just installed 4.0.18-nt and I am getting very weird results. I asked
this before but the example was too complicated to follow. Sorry about
that. Here it is in a much simpler form: For example after restarting
mysqld I run this query:
select location from vevents where event_id=15 UN
From: "Keith Thompson" <[EMAIL PROTECTED]>
> select somefields from t1, t2 where t1.id = t2.id and t2.x2 =
somenumber;
Try:
select somefields from t1 join t2 on t1.id = t2.id and t2.x2 = somenumber;
Also take a look at the estimate number of records for each step in the
explain output.
It's
Klaus,
>>in this case, I suspect, is that the disconnect happens in the
>> pre-data-sending stage, which is possibly quite lengthy.
> Exactly ! It takes hours till these results are erased and i even don't know
> where the period when they are erased come from.
> I still hope this is set in a ser
I apologize if the listings below are badly
formatted. I am posting this from a webmail client
and it has very short line lengths.
I am using MySQL 4.0.17 on QNX 6.2.0. I can connect
by typing "mysql -u root" from the command line.
However, I get:
Database connect failed
Can't connect
Hi all,
I have some questions I thought people might be able to enlighten me on.
I have a database of website content that I have inherited that is
full of standards-killing html (about 500 website pages; long story). I
would like to change that, but its a job that is a little too big for
on
At 01:54 PM 2/17/2004, walt wrote:
>> (SELECT FROM table WHERE condition1) UNION (SELECT FROM table WHERE
>> condition2);
Ah, interesting... I'll play around with UNION to see if that will do the
trick for me.
Right off the bat, I am able to get a fast query with it, but the output
isn't quite,
We are trying to do some capacity planning, and we need to know how MySQL
allocates the the filespace in the directories set by the tmpdir
configuration parameter.
The manual simply states:
"...It may be useful if your default /tmp directory resides on a partition
that is too small to hold tempor
I am trying to execute mysqld_multi script in unix. But it's giving me following error
"WARNING! my_print_defaults command not found. Please make sure you have this command
available and in your path. The command is available from the latest MySQL
distribution."
I have the laterst MySQL distrib
[EMAIL PROTECTED] root]# rpm -qvl MySQL-server-4.0.18-0
-rwxr-xr-x1 rootroot 5575 Feb 12
09:02 /etc/init.d/mysql
-rw-r--r--1 rootroot 657 Feb 12
09:02 /etc/logrotate.d/mysql
-rwxr-xr-x1 rootroot 900144 Feb 12
09:02 /usr/bin/isamchk
-rwxr-x
On Wed, 11 Feb 2004, Sean Flynn wrote:
> Humble apologies for the broken link. Google on the filename; it seems
> popular enough that it should be out there somewhere. Particularly look
> at the MySQL site; there might've been a few links there.
The latest FSU-threads site is at
http://moss.csc.n
Assuming that the address field is of type char or varchar,
Assuming that the address field has a NULL default value the following should
do it
select ... from ... wehre address is null;
In case that the address field has no default value the following should do
it:
select ... from ... where
On Tue, 10 Feb 2004, Stefaan Van Dooren wrote:
> I'm trying to compile MySQL 4.0.17 on SCO OpenServer 5.0.6, gcc version 2.95.3
> 20030406 (SCO/p4).
>
> I always get the following error :
>
> Undefined first referenced
> symbol in file
> pthread_k
On Tue, 10 Feb 2004 [EMAIL PROTECTED] wrote:
> Hi,
>
> I could not find the binary for SCO Unixware (Intel based) in download
> section. I suppose mysql supports this environment too. May I know as to
> where can I find this binary. Do I need to build this myself?
There are some version on ftp.zen
Hi!
http://www.f-secure.com/v-descs/bagle_b.shtml
A new Bagle.B worm epidemy is apparently causing the messages ID sent to the MySQL mailing list by my name.
The worm has probably infected the computer of someone following this
mailing list, and the worm has scanned my email address from the ha
Keith Thompson wrote:
I've got a query that's not using an index and I don't understand why.
Here's a stripped down version of what the tables look like:
create table t1 (
id int(10) unsigned not null auto_increment,
x1 date not null,
... 8 other small, fixed fields
primary key (id),
Ross,
rpm -qlp package_name.rpm will list all the files in an rpm for you. You
may
need to install the client rpm as well.
walt
Ross O wrote:
>
> I was able to successfully install MySQL server 4
> under windows, but am a little confused about doing it
> through linux.
>
> My main confusion is
This will list all the files in the package and where they are located.
rpm -qpl .rpm
or from the rpm database
rpm -ql
Matt
Ross O wrote:
I was able to successfully install MySQL server 4
under windows, but am a little confused about doing it
through linux.
My main confusion is where the
Yeah but it doesn't work. I unsubscribed 3 months ago
-Original Message-
From: Mike Johnson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 17, 2004 2:03 PM
To: Tim V; [EMAIL PROTECTED]
Subject: RE: How do I unsubscribe
From: Tim V [mailto:[EMAIL PROTECTED]
> How do I unsubscribe?
T
The biggest problem I see is that you are using a text field and you don't
have an index on it anyway. Maybe you should use a different field type and
index it. That should make it a little bit faster.
Donny
> -Original Message-
> From: Lancashire, Pete [mailto:[EMAIL PROTECTED]
> Sent:
The problem is, that i can't prevent queries like
SELECT * FROM WHERE LIKE 'a%'
where an index will not help on a Table > 100.000.000 records.
It's not that we have to answer hese queries (therefore the timeout), but
it's impossible to prevent dumm users.
Run EXPLAIN on the untrusted queries f
Please help. What is the syntax of idenfying those
who "do not" have addresses (in the address field) in
the database?
__
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online.
http://taxes.yahoo.com/filing.html
--
MySQL General Mailing List
For li
On Tue, 2004-02-17 at 11:00, A. Clausen wrote:
> I am trying to construct what is proving to be a somewhat tricky SQL query.
> I have a database in which wireless activity data is dumped. The following
> is a boiled down version of what the table and the contents may look like:
>
> Date,Unit,Inpu
Lancashire, Pete wrote:
I'm doing some tests on a small Sun server, a 280R to demo
MySQL vs. Oracle. For the demo I using a subset of a test table.
The destination server will be a Sun 880 with 8 1.2 GHz CPU's,
16 GB RAM, Sun T3+ RAID Array.
Any suggestions on settings or other changes would be hel
I am interested to help, you can email me the call graph or source.
I nearly have nothing much to do ( no client, teching guiter now!!! ha
ha). I am using the C API 100% flawlessly in my
http://www.DhakaStockExchangeGame.com/
Still using it
--
Aftab Jahan Subedar
CEO/Software Engineer
Su
no swapping so far
I can see where I'm 'asking for' more then 8 GB, but for testing,
I gambling that the total amount of test data is less
then 8GB. also, i'm currently only doing tests with only one query at
a time.
one thing i've notices is the memory being consumed by mysqld has
so far not gon
From: Tim V [mailto:[EMAIL PROTECTED]
> How do I unsubscribe?
This message should have a "To unsubscribe" link at the bottom (if you haven't already
noticed it on every other message you receive).
--
Mike Johnson
Web Developer
Smarter Living, Inc.
phone (617) 886-5539
--
MySQL General Maili
I was able to successfully install MySQL server 4
under windows, but am a little confused about doing it
through linux.
My main confusion is where the install goes? Im using
the rpm, and from my personal directory where i
downloaded the rpm to, i issue a rpm -i
MySQL-server-...rpm command and it
I am trying to construct what is proving to be a somewhat tricky SQL query.
I have a database in which wireless activity data is dumped. The following
is a boiled down version of what the table and the contents may look like:
Date,Unit,InputOctets,OutputOctets,AccountingID
2004-01-31 23:59:05,0E:
How do I unsubscribe?
__
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online.
http://taxes.yahoo.com/filing.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTE
I run MySQL version 4.0.16 on my linux box.
My replication is working fine when I drop my database and import it on the
master server. It seems to me that configuration files for both master and
slave are OK. Privillege too.
I define a user with the following right's:
* Reload
* File
Bill,
Someone sent this too the list the other day.
>> MySQL's optimizer has a slight problem. OR queries cause it to get very
>> confused.
>>
>> Try the following to get the best performance:
>>
>> Rewrite SELECT FROM table WHERE (condition1) OR (condition2);
>>
>> As:
>>
>> (SELECT FROM table WH
Sp.Raja wrote:
Thanks for your lightening response.
Even I thought of this idea
- Isolate pairs like
- my_malloc and my_free
- Innodb pair: ut_malloc and ut_free
But if pointers are passed between InnoDB and MySQL or MySQL and clients, then the memory consumer should free it using my wrap
Pete,
I was just glancing at this and it looks like you have about 13.5GB of
memory allocated on a 8GB machine (4096+4096+512+4096+1024).
Are you swapping badly??
walt
"Lancashire, Pete" wrote:
>
> I'm doing some tests on a small Sun server, a 280R to demo
> MySQL vs. Oracle. For the demo I usin
I've got a query that's not using an index and I don't understand why.
Here's a stripped down version of what the tables look like:
create table t1 (
id int(10) unsigned not null auto_increment,
x1 date not null,
... 8 other small, fixed fields
primary key (id),
key search_x1 (x1)
)
I've noticed that If I use an OR in my query, mysql seems to choose not to
use my indexes. Though, it would seem to help (as, if I do the query in
two steps, I can get faster results than as one query).
Is there some way I can convince mysql to use my keys with an OR, or
perhaps another way to
Speaking of MySQL database security, what are some key things to keep in
mind, other than changing the root password?
Thanks,
Eve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Well, I agree with your reply. But to my opinion there is a big difference between
letting someone walk into an open manhole or put a small fence around it for
protection.
The way it is now, not much is done to prevent the stupid from being stupid. I like to
see some minimum safeguards just to
It works fine (with a little tweak).
SELECT DISTINCT CASE WHEN c1.winner_1 = c1.winner_2 THEN c1.winner_1 ELSE c1.winner_2
END AS winner FROM champions c1,champions c2 ORDER BY winner ASC
is what I wanted. Thank you very much! Btw, I can't help my webhotel is rotten and
only uses old versions.
Store the password (encrypted of course) in your DB de jour
Read the 'user record' for that username and pull the associated password
Of course its nice to allow the capability to assign a new password
Yes I Agree wholeheartedly with your first statement..
-Martin
- Original Message -
From:
I'm doing some tests on a small Sun server, a 280R to demo
MySQL vs. Oracle. For the demo I using a subset of a test table.
The destination server will be a Sun 880 with 8 1.2 GHz CPU's,
16 GB RAM, Sun T3+ RAID Array.
Any suggestions on settings or other changes would be helpful.
Also what woul
Thanks for your lightening response.
Even I thought of this idea
- Isolate pairs like
- my_malloc and my_free
- Innodb pair: ut_malloc and ut_free
But if pointers are passed between InnoDB and MySQL or MySQL and clients, then the
memory consumer should free it using my wrapper and not sy
Carl Schéle, IT, Posten wrote:
I got a table, champions, looking like this:
id winner_1 winner_2
0carl mattias
1daniel carl
2er
hi all,
I have installed MySQL 5.0.0a-alpha for Windows...
Everday 1st time it's started using WinMySQLAdmin 1.4 tool
and working on the mysql prompt, it works fine...
whenever i shut down the system OR Stop the service once
and restart again it started asusual, but no values displayed
in Envi
Now UNION is implemented in MySQL 4.0.0. and as I stated earlier I run 3.23.58.
-Ursprungligt meddelande-
Från: Rodolphe Toots [mailto:[EMAIL PROTECTED]
Skickat: den 17 februari 2004 16:19
Till: Jonas Lindén; Carl Schéle; [EMAIL PROTECTED]
Ämne: SV: SQL-HELP
yeah
but that wont really do
yeah
but that wont really do it since the names are in two columns
so, there must also be a UNION included
do a union and then select distinct on the result from the union
that should do it (eller hur?)
-Ursprungligt meddelande-
Från: Jonas Lindén [mailto:[EMAIL PROTECTED]
Skickat: den 17
Hi Sacha,
Thx a lot for your reply
you wrote:
>in this case, I suspect, is that the disconnect happens in the
pre-data-sending
>stage, which is possibly quite lengthy.
Exactly ! It takes hours till these results are erased and i even don't know
where the period when they are erased come from.
Yours ID afccvi
--
Thank
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello, you might want to try select DISTINCT ?
http://www.mysqlfreaks.com/statements/18.php
/Jonas
- Original Message -
From: "Carl Schéle, IT, Posten" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 17, 2004 3:49 PM
Subject: SQL-HELP
Hello!
I got a table, champio
Andreas Pardeike <[EMAIL PROTECTED]> wrote:
> Hi List,
> should I report the following as a bug?
>
> mysql> select count(*) from words as w1 where w1.val in (select w2.val
> from words as w2 where w2.val like 'm%');
>+--+
> | count(*) |
> +--+
>
Hello!
I got a table, champions, looking like this:
id winner_1 winner_2
0carl mattias
1daniel carl
2erik
no .they really are out to get you :)
Security is always a challenge. You can build the most secure system in the
world but if the users are not educated in security you have wasted your
time.
The "no password" relies on a user knowing what to do. The question is this
OK default behaviour - t
Missed ccing it to list!
Yes In mysqld. system provided malloc has access to a samller space of entire main
memory, and we APIs to access the rest, I'm trying to change mysqlds malloc calls to
our extended malloc which make use of the entire main memory.
Regards,
Sp.Raja
> > Orig
Greetings:
I just installed 4.0.18-nt on Windows 2000 Pro to utilize the new UNION
feature and am experiencing weirdness which makes me think that MySQL is
caching result sets when it shouldn't.
Here's a simple query from an events table and a UNION with a recurring
events table, and its (cor
I'm new to MySQL and in starting to use it some questions came up to me about
sequrity. Please allow me to post them here.
Why is is that MySQL on a new installation has *no* password at all?
OK, the documentation gives you a waring for it and strongly suggest
to install one. But why not installi
Chris Nolan wrote:
Hi!
You'll want to look through the MySQL C API docs. There are specific
calls for allocating certain structures that MySQL client software
should use (and routines for deallocating it as well).
Regards,
Chris
Sp.Raja wrote:
Hi List,
I want to use some other memory alloca
Server end? As in, writing code that will integrate with the MySQL
Server process? Or are you building UDFs?
Regards,
Chris
Sp.Raja wrote:
Thanks for your input. I'm trying to do is at the server end(mysqld), could you get some pointers?
Regards,
Sp.Raja
Original Message---
"Rhino" <[EMAIL PROTECTED]> wrote:
> I'm confused. According to your note and to a passage I found in the manual,
> InnoDB support is installed in all 4.0.x versions of MySQL, which should
> obviously include my 4.0.11 install. Yet SHOW_VARIABLES LIKE 'have_innodb'
> returned NO. Why? It would appe
Franz, Fa. PostDirekt MA wrote:
Hi Stefan,
thanks for your fast reply !
Would it be possible to call mysql_free_result() from your
application? You might be able to set a "timer" in your app, calling
that function after, for example, 20 seconds.
I am not the of developer this programm ...
But
Thanks for your input. I'm trying to do is at the server end(mysqld), could you get
some pointers?
Regards,
Sp.Raja
> Original Message
> From: Chris Nolan <[EMAIL PROTECTED]>
> To: "Sp.Raja" <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED]
> Date: Tue, Feb-17-2004 6:29 PM
> Su
Garth Webb <[EMAIL PROTECTED]> wrote:
>
> Hi, I am experiencing strange behavior from a TIMESTAMP column in an
> InnoDB table on my MySQL 4.0.16 server. Specifically, it fails to
> select certain rows by this column. The table is defined as:
>
> CREATE TABLE log (
>s_id int(11) not null
Michael McTernan wrote:
Hi there,
Given this model, each thread is obviously going to want to have
multiple transactions outstanding. Is this something that might be added
to MySQL in future or am I totally overestimating the expense of using
one thread per connection?
I'm guessing you me
Hi!
You'll want to look through the MySQL C API docs. There are specific
calls for allocating certain structures that MySQL client software
should use (and routines for deallocating it as well).
Regards,
Chris
Sp.Raja wrote:
Hi List,
I want to use some other memory allocator routine other t
When a select query is run on a mysql table with text and blob fields, the
text fields return the whole text but the blob fields return only the first
4 bytes of the blob data. I use MySQL 4.0.17 with VB6.0 on Windows 2000.
What should I do to retrieve complete data from the blob field?
Any help
Hi Stefan,
thanks for your fast reply !
>>Would it be possible to call mysql_free_result() from your
>>application? You might be able to set a "timer" in your app, calling
>>that function after, for example, 20 seconds.
I am not the of developer this programm ...
But i'm sure I can convince him
Hi there,
> Given this model, each thread is obviously going to want to have
> multiple transactions outstanding. Is this something that might be added
> to MySQL in future or am I totally overestimating the expense of using
> one thread per connection?
I'm guessing you mean that each thread will
Klaus,
> we are porting an application from ORACLE to MySQL.
> The application does lot of queries and has and times out a query, if no result is
> back
> after 10 seconds.
> It handles queries parrallel and rasies or lowers the amount of connection variable
> (the programm is a server itself).
>
Hello list, I have a text field in a database, it contains a \r seperated
list of items. I want a random item out of the list.
Please don't lead me down a path of using random in php or perl, that wont
be happening on this one, I am looking for something more like..
Select name, random(split(dat
Hi List,
I want to use some other memory allocator routine other than malloc in MySQL/InnoDB
4.0.15a.
Does MySQL call malloc directly? or thru wrappers? If it is through wrappers then my
job will be much simpler, If so please give me the list of wrappers.
Any Advice welcome
Regards,
Sp.Raja
"Logan McKinley" <[EMAIL PROTECTED]> wrote:
> I am using MySQL (4.0.17) and am getting errors with the following SQL
> statement originally writen for MS products.
>
> SELECT
> survey_questions.Question_ID,
> First(survey_questions.Question_Text) AS FirstOfQuestion_Text, <== this line
> returns e
Dear Sirs and Ladies,
we are porting an application from ORACLE to MySQL.
The application does lot of queries and has and times out a query, if no result is back
after 10 seconds.
It handles queries parrallel and rasies or lowers the amount of connection variable
(the programm is a server itself).
Sure! Just remember that your slave will have to be able to keep up with
all the UPDATE, INSERT and DELETE statements issued on the master servers.
Regards,
Chris
[EMAIL PROTECTED] wrote:
That looks like a good solution...
Do you know if i can replicate multiple databases from diferent servers
On Monday 16 February 2004 18:27, Mulugeta Maru wrote:
> Many thanks. What I would also like to know is that can a field in Table A
> be a foreign key of on of the fields in Table B with has two fields
> combined as a primary key?
Yes, it's possible.
Note: column must be first column in the multi
That looks like a good solution...
Do you know if i can replicate multiple databases from diferent servers to
one server? many masters and one slave, the slave might have replicas of
each master database
(cause i need to query on many diferent mysql servers)
thanks...
FBR
Chris Nolan <[EMAIL
Bill Marrs <[EMAIL PROTECTED]> wrote:
> I noticed these files in my mysql data directory:
>
> -rw-rw1 mysqlmysql 5242880 Feb 15 20:54 ib_logfile0
> -rw-rw1 mysqlmysql10485760 Feb 15 20:54 ibdata1
> -rw-rw1 mysqlmysql 25088 Jun 3 2003 ib_arch_log_
87 matches
Mail list logo