On Thu, Jan 30, 2003 at 04:13:17PM +0100, W. Enserink wrote:
> Hi all,
>
>
> Im in need of some tps.
>
> I want to copy a row in a table to a new row in the same table except for
> the unique ID. Is there some mysql statement for this?
Dear Wilbert,
INSERT ... SELECT almost allows you to d
Am Donnerstag, 30. Januar 2003 19:57 schrieb Dan Nelson:
> In the last episode (Jan 30), Christian Kohlsch?tter said:
> > Actually, you _can_ use ORDER BY with UPDATE.
> >
> > It works fine, if you do an
> >
> > update tb_roubr set id=id+1 where id>1 order by id DESC
> >
> > on your table.
>
> Only
If I create a FULLTEXT index for 2 or more columns in a table will I be able
to use it for a MATCH only against a single column (of the above) or do I
have to create additional FULLTEXT indices for each of these columns?
Thanks/h
sql,query,queries,smallint
--
oh and my test server is my PC , so I had all kinds o crap running
on it at the same time.
Mary Stickney
TAG-TMI
Data Warehouse Programmer
402-474-7612 x 3099
[EMAIL PROTECTED]
-Original Message-
From: Jennifer Goodie [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 30, 2003 1:57 PM
On 30 Jan 2003, at 15:41, Roger Baklund wrote:
> However, you would normally need to store something more than just the
> float value, otherwise it would be difficult to use the data for
> anything... assuming you also need an integer pointer for each value,
> you would need 4 extra bytes per row,
Hi
- Original Message -
From: "W. Enserink" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 30, 2003 4:34 PM
Subject: copying a row
> Hi all,
>
>
> Im in need of some tps.
>
> I want to copy a row in a table to a new row in the same table except for
> the unique ID. Is
I created a "file.sql" with mysqldump.
mysqldump my_db my_table > file.sql
What I do to get this file with the mysqlimport?
mysqlimport ??
Thanks,
e.
_
MSN Messenger: converse com os seu
The warehouse is updated once a month at night , with data from the
mainframe. no records are updated or added to these databases in any other
way.
It is strictly a report database. They reports are ordered from a website.
A record is put into a database called ReportQueue the VB app checks the
q
> > Because with native threads, enabling the second CPU (and thus locking
> > MySQL to one thread, one process, -period-, because running another on
> > another port isnt viable) makes the job take just over twice as long.
>
> This explains your point of view: I never tried to run MySQL on
> dual-
one other thing , the girl that made them did it with an Access database
copy of the warehouse.
I changed the connection to the real Datawarehouse.
if that makes any difference
Mary Stickney
TAG-TMI
Data Warehouse Programmer
402-474-7612 x 3099
[EMAIL PROTECTED]
-Original Message-
From
You are positive there is nothing else running while you are trying to do
your reports? Have you tried keeping an eye on the processlist to see where
it is getting stuck and to make sure there is nothing else going on? Where
does the production server get its data from? Are their updates going o
no it is dedicated to the DataWarehouse Report Processor.
runs one report at a time from a ReportQueue.
both have a local host.
Mary Stickney
TAG-TMI
Data Warehouse Programmer
402-474-7612 x 3099
[EMAIL PROTECTED]
-Original Message-
From: Jennifer Goodie [mailto:[EMAIL PROTECTED]]
Sent:
Please don't hijack threads.
In the last episode (Jan 30), Jonas Ask?s said:
> I'm wondering how well MySQL compress data. I'm about to design a
> database which will hold mainly _a lot_ of FLOAT-values, and since I do
> not really know how well MySQL compress data or how I could calculate
> this
>They run in 8 minutes on my test server , about 4 minutes each. Printing to
>a PDF driver.
>On the Production Server they take HOURS to run and print.
The production server is probably trying to do other stuff at the same time,
making your reports slower. A machine with one active connection wi
Accessing a DB via Java is very easy as well.. IMHO PHP and the like scripts are
over rated. You'll have much more flexibility with Java. (If you don't have to worry
about firewalls...) Since it sounds like you a C++ person you'll pick up on Java
quickly, if you don't know it already.
If
Hi,
- Original Message -
From: "Guddack Thorsten ICM MP SCM GO 21" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 30, 2003 3:44 PM
Subject: Replication Problems/Questions
> Hi List
>
> I'm using 2 WinNT-Servers, Sp6 with mysql 4.0.5. max-nt.
>
> I ve setup a replicati
Howdy list,
Does anyone have a FreeBSD/MySQL bin-log rotation script that I could use?
I'm not sure how to go about rotating the binary logs. Doesn't the
index have to stay in sync?
Thanks!
Matthias
-
Before posting, please ch
Hi all,
I am creating a new table with an auto_increment primary key.
How do i tell mysql to start incrementing at a certain value, let say
1000 instead of 1?
Thanks,
MT
--
-
Before posting, please check:
http://www.mysql
On Thursday 30 January 2003 13:47, you wrote:
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> sql,query,queries,smallint
>
> If you just reply to this me
I am trying to use replication with 4.0.9.
Changes to the datbase are not being recorded in
the bin file on the master for a DB called Medic
when presented by an application but will if I
setup a test table in the DB mysql and use the
mysql client to insert/update.
At this point I have no idea
In the last episode (Jan 30), Christian Kohlsch?tter said:
> Actually, you _can_ use ORDER BY with UPDATE.
>
> It works fine, if you do an
>
> update tb_roubr set id=id+1 where id>1 order by id DESC
>
> on your table.
Only if you're runing MySQL 4.0. 3.23 does not allow UPDATE .. ORDER BY.
C
Thomas,
> I installed MySQL on my server and after reboot i got the error
message
> when starting mysql:
> "ERROR 2002: Can't connect to local MySQL server through socket
> '/var/run/mysqld/mysqld.sock' (2)"
Is mysqld up and running? Try "ps xa | grep mysqld".
Regards,
--
Stefan Hinz <[EMAIL
Mike,
> Has anyone done any work with getting images into and out of a MYSQL
> database? I have used mysql for some time, but never stored an image
in a
> blob field. I am curious on how to insert the image from a web form
upload,
> and how to display the picture on another HTML page.
You might
> > gcc -v
> Using built-in specs.
> Configured with: FreeBSD/i386 system compiler
> Thread model: posix
> gcc version 3.2.1 [FreeBSD] 20021119 (release)
Okay.
> Because with native threads, enabling the second CPU (and thus locking
> MySQL to one thread, one process, -period-, because running an
:Has anyone done any work with getting images into and out of a MYSQL
:database? I have used mysql for some time, but never stored
:an image in a
:blob field. I am curious on how to insert the image from a
:web form upload,
:and how to display the picture on another HTML p
Hi Group,
I want to start my mysql with max_connections option. Now I am getting To
many connction error. So I want to allow 200 concurrent connections...
I tried with
safe_mysqld max_connections=200 &
But it is not coming up...
How can I set max_connections as 200. Do I need to specify that in m
> Hello all-
> I am using MySql, php and forms in HTML to update information. When I
select results from column type VARCHAR, if the information stored
> in the column has a space in it (for example, Tampa Bay), it will only
> return Tampa (I have the length set at 30 so it is not a length issue).
These two links should help you.
http://www.mysql.com/doc/en/Column_types.html
http://www.mysql.com/doc/en/Storage_requirements.html
I believe you would be using a 4byte field. So..
(1 314 000 000) * (4) = 5 256 000 000 bytes
or, 5.256Tb
(assuming my calculations are not in error)
Huge.
--
> -O3 on a production server? Mmmm... not good. gcc 2.95 is sometimes buggy, I
> suggest to use -O alone.
> gcc -v
Using built-in specs.
Configured with: FreeBSD/i386 system compiler
Thread model: posix
gcc version 3.2.1 [FreeBSD] 20021119 (release)
> I don't see any reason to use LinuxThreads. W
You have written the following:
Hello dear all,
i try to set-up replication,
i've configurated master and slave,
and on the slave-side i see this log:
030130 17:22:41 Slave: Failed reading log event, reconnecting to retry, log 'FIRST'
position 35
030130 17:22:41 Slave: reconnected to ma
Platform: windows
MySQL version: 4.0.9-gamma
PHP version: 4.3.0
Connected through Command Prompt via MySQL client to local MySQL server.
Output from a SELECT query:
mysql> select * from category;
+++---+--+-++
| id | parent | name
> I'm wondering how well MySQL compress data. I'm about to design a
> database which will hold mainly _a lot_ of FLOAT-values, and since I do
> not really know how well MySQL compress data or how I could calculate
> this I'd really appriciate a little guidance.
see chapter 6.2.6 of the mysql manu
Well, just a suggestion, but if you did not install world (where the
threads are) then you have a mismatch between kernel and world.
OT (but what the heck!)
proper procedure for freebsd
cvsup to desired version
cd /usr/src
mergemaster -p
make buildworld
make buildkernel KERNCONF=yourkernel
make
Is it possible to build a query that contains a left join that refers to a
table, that in its turn refers to another table?
Thanks
best regards
DI Horst Scheruga
-
Before posting, please check:
http://www.mysql.com/manual.
Hello,
My name is Dragos Pruteanu, and I am the author of a
web-oriented schema editor.
The application is free, and because I'm interested to
make it known, I am
writing this email with the hope I can get your
interest and the interest of the
mysql comunity.
The application is done in java with
Hi all,
Im in need of some tps.
I want to copy a row in a table to a new row in the same table except for
the unique ID. Is there some mysql statement for this?
regards Wilbert
-
Pas de Deux
Van Mierisstraat 25
2526 NM Den Haag
tel 070 4450855
fax 070 4450852
http
>Here's an example of how much data could be stored in a year:
>1 value/minute are stored = 1440 values/day.
>365 days / year.
>We have 100 different tables with 25 columns each.
>This makes 100*25*365*1440 = 1 314 000 000 values per year.
>A typical value could be 25,5624.
>How much space (in
* Jonas Askås
> I'm wondering how well MySQL compress data. I'm about to design a
> database which will hold mainly _a lot_ of FLOAT-values, and since I do
> not really know how well MySQL compress data or how I could calculate
> this I'd really appriciate a little guidance.
mysql does not compres
"Grigor, Peter" wrote:
>
> You need to run [analyze table] to create the index stats...do this
> reasonable often (once a day for a well-used table).
This script will be run on servers around the world by regular people,
not sys admins. I will have no control over their databases.
> Running [o
Hi all,
Im in need of some tps.
I want to copy a row in a table to a new row in the same table except for
the unique ID. Is there some mysql statement for this?
regards Wilbert
-
Pas de Deux
Van Mierisstraat 25
2526 NM Den Haag
tel 070 4450855
fax 070 4450852
ht
I have 2 Crystal Reports 8.5 (for the record I didn't make these reports)
that draw straight from the MYSQL
database. They use only 1 table. I am calling them to print from VB 6.0
Theses reports have lots of complex calculations in them, counts , sums and
groups.
My test server has the same code
Hi List
I'm using 2 WinNT-Servers, Sp6 with mysql 4.0.5. max-nt.
I ve setup a replication between these two servers as discribed in the
manual and some small problems comes up.
Maybe someone can give me some help.
1.) On the Master I create a user repl with the rights 'replication slave'.
Hi
I have problem with passwords.
Normal users who have only 'USAGE' global privileges are
not able to change their own password. I tried to do fresh installation
of mysql 4.0.9 (and 4.0.8) on my windows workstation. I created new user
(as root):
GRANT USAGE ON *.* TO dummy@localhost;
then I
Hi,
I don't know who is receiving my message, but i have an important
request on you.
I also have the same problem.
I installed MySQL on my server and after reboot i got the error message
when starting mysql:
"ERROR 2002: Can't connect to local MySQL server through socket
'/var/run/mysqld/mysql
Hi Prabu,
>From my own experience I'd say that PHP is the best option since it can be
compiled with MySQL support and you will find that accessing the database
is very easy.
Regards,
Eric
On Wed, 29 Jan 2003, Prabu Subroto wrote:
> Dear my friends,
>
> My boss wants a database application runni
Matthias,
what have you done? Below you create table 'foo' but mysql answers that it
cannot create 'stundenliste.frm'.
"
mysql> create table foo (id int auto_increment,unique key (id))
type=innodb;
ERROR 1005: Can't create table './test_smurf/stundenliste.frm' (errno: 121)
mysql> create table
Actually, you might want to play with sed or perl.
mysqldump -u root --no-create-info -q --all-databases | sed s/'INSERT INTO
acctlog'.*//
is a first draft, although perhaps not optimal in speed. It will remove all
acctlog inserts from all databases. You might want to play a bit with shell
script
try running winmysqladmin.exe under mysql folder
lewell
The content of this email when sent is as full as practical. Due to the
settling of the words the contents might not appear as full as it was but
the weight remains the same. The contents is being sent by weight and not by
volume.
- Orig
Hi all I am trying to import a csv file from MySQL and keep getting an error on
line one.
Is there an alternative way to import a csv file other than using phpmyadmin?
I exported the file from MySQL but can't import it back in, any ideas?
Andrew
-
>Description:
Table not creatable
>How-To-Repeat:
mysql> create table foo (id int auto_increment,unique key (id)) type=innodb;
ERROR 1005: Can't create table './test_smurf/stundenliste.frm' (errno: 121)
mysql> create table stundenliste (id int auto_increment) type=in
Hi
My tables are of type MYISAM.
What exactly REPAIR does?
Is this enough? If my database in not consistent is this command will help?
Thanks, Inbal
-Original Message-
From: R. Hannes Niedner [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 29, 2003 10:10 PM
To: Inbal Ovadia; MySQL Mai
* Roger Baklund
[...]
> UPDATE a SET new_date =
>
(
> MID(my_date,7,4),'-',
> MID(my_date,1,2),'-',
> MID(my_date,4,2));
huh? How did this happen...? I just checked my outbox, and the message I wrote
yesterday[1] contained "new_date = CONCAT(". It seems as the substring "CON" has been
rep
Hi there,
I'm running a mysql server on Linux RedHat 7.3:
Server version 3.23.49-log
Protocol version10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Locally everything is ok but when I'm trying to connect remotely I always
ge
Hello,
Can you tell me how to drop or desactivate a foreign key without
losing any data in SQL for MySQL 3.23.51 ?
Thanks in advance.
JeanClaude
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
[NOM] à [ADRESSE] a écrit le 30/01/03 9:52 :
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> sql,query,queries,smallint
>
> If you just reply to this
Hi,
I'm wondering how well MySQL compress data. I'm about to design a
database which will hold mainly _a lot_ of FLOAT-values, and since I do
not really know how well MySQL compress data or how I could calculate
this I'd really appriciate a little guidance.
Here's an example of how much data coul
Hi,
I'm wondering how well MySQL compress data. I'm about to design a
database which will hold mainly _a lot_ of FLOAT-values, and since I do
not really know how well MySQL compress data or how I could calculate
this I'd really appriciate a little guidance.
Here's an example of how much data coul
Has anyone done any work with getting images into and out of a MYSQL
database? I have used mysql for some time, but never stored an image in a
blob field. I am curious on how to insert the image from a web form upload,
and how to display the picture on another HTML page. Preferred web
scripting
Am Donnerstag, 30. Januar 2003 00:02 schrieb Dan Nelson:
> In the last episode (Jan 29), Igor Kutsyy said:
> > Could you help me with this. I`m trying to increment values of
> > primary auto_increment field from table, and ofcourse it is not
> > working. Could you tell me how to construct a query c
Hi,
I'm wondering how well MySQL compress data. I'm about to design a
database which will hold mainly _a lot_ of FLOAT-values, and since I do
not really know how well MySQL compress data or how I could calculate
this I'd really appriciate a little guidance.
Here's an example of how much data coul
Everytime I try to compile with the MySql.h or any other includes with a
gcc++ compiler I have many errors. Are there any known issues with a current
release of the files that any one knows of? If someone uses C++ to interact
with a MySql database, please let me know or send a sample project to me.
Loren McDonald wrote:
Have you done all the office (or at least Access) XP updates? If not,
it is possible that one of them my resolve your crash problem. I have
been testing Access XP with the same versions of MyODBC and MySQL for a
few weeks now and have yet to see a crash. About the only pr
×ð¾´µÄmysql:ÐÂÄêºÃ!
ÎÒÃÇÊÇ¡°ºÓÄÏÊ¡ÔÑô»ªÑô±£½¡Æ·³§¡±£¬½ß³ÏÏòÄúÍƼö
ÎÒ³§Ö÷µ¼²úÆ·--¡°»ªÑôÅÆ´ÅÁÆÒ©Õí¡±¡£¸ÃÕíÓÉÃû¹óÖÐÒ©¼Ó
´ÅÁƾ«Öƶø³É£¬ÇáËÉ·½±ãÁÆЧºÃ£¬ÎªÖÚ¶àÒÑ»¨ÊýǧԪҽÁÆ
·ÑµÄ»¼Õß½â³ýÁ˶àÄ겡ʹ£¬»ñµÃ¡°»ªÑôÉñÕí¡±µÄÔÞÓþ¡£
[¹¦Ð§ÔÀí]£ºÐÑÄÔ¿ªÇÏ¡¢Õò¾²°²Éñ¡¢ºÍѪͨÂç¡¢ÐÐÆøֹʹ£¬
ͨ¹ý˯ÃßÓëÈËÌåÃÜÇнӴ
Hi.
Has anyone successfully build Mysql 4.1 from development source in
Windows(XP) environment?
Been getting this error(?) in cloning and in executing bk -r get
-Sq(executed from cygwin)
---
You are trying to create a symlink on a win32
file s
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dander --
...and then [EMAIL PROTECTED] said...
%
...
% and file:/var/www/test1.php could not be found using the browser.
% note that /var/www/test1.php is the only ?/www/? directory found.
I have to hand it to you for your documentation. You've pr
At 11:09 -0600 1/29/03, Ray wrote:
is they a way to have mysqldump ignore a list of tables, but get everything
else?
something like:
mysqldump -ume -psecret -hserver --all-databases
--exclude-tables=server.acctlog
No.
--
mysql, sql, query, sql, sql, sql
-
i'm trying to set mysql up on windows 2000, and having some problems. i
download file and installed. what do i have to do to get it running. never
done it on windows just linux
_
The new MSN 8: advanced junk mail protection and 2
Hello,
I want to do the following query
INSERT INTO temp_explanations(tip) SELECT tip FROM explanations WHERE
explanations.file=temp_explanations.file AND
explanations.level=temp_explanations.level;
but I'm getting an 'unknown table temp_explanations' error.
How can I get around this?
Thanks,
:is there a way to use the date part of a datetime field that
:still uses the
:index on the datetime field? i've tried a few different things
:and it keeps
:saying in the explain it says that its a possible_key, but
:NULL for the key
I'm not sure if this ignores the indexes
On Wed, Jan 29, 2003 at 09:22:50AM -0500, Bill Lovett wrote:
> I was reading about user defined functions, and although they sound
> interesting, I can't find many examples of their use. If anyone is using
> them, what are you using them for? Are they a way to manipulate data
> going into a record,
In the last episode (Jan 29), Rusch (ext) Reiner said:
> I've got one question which belongs to the new query cache in 4.01.
>
> I wonder why the cache should be deleted if there's a statement like
> update, insert etc. I think it must be considered that there are
> possible situations where this
:+---+--+--+-+-++
:| Field | Type | Null | Key | Default | Extra |
:+---+--+--+-+-++
:| id | int(11) | | PRI | NULL|
:auto_increment |
Hello again,
Turns out it is implemented - but it's 'stop-slave' and 'start-slave'. Shoulda done a
'mysqladmin --help'. Grepping the source found it.
- GW.
>Date: Wed, 29 Jan 2003 11:19:06 +1100
>To: [EMAIL PROTECTED]
>From: Guy Waugh <[EMAIL PROTECTED]>
>Subject: 'mysqladmin slave-st(art|op)'
73 matches
Mail list logo
