Subject: Re: MySQL/InnoDB-4.0.4 is released
...
Subject: Re: MySQL/InnoDB-4.0.4 is released
...
Subject: Re: MySQL/InnoDB-4.0.4 is released
...
Subject: Re: MySQL/InnoDB-4.0.4 is released
...
Subject: Re: MySQL/InnoDB-4.0.4 is released
...
Subject: Re: MySQL/InnoDB-4.0.4 is
Hi,
My tables is something like this
Value Count
B 10
C 20
A 15
D 8
When I query using SELECT Value, Count FROM Table, the data is
appearing
exactly at the order above, however when I select only a single column
using SELECT
Is there primary key on field Value? Or any index?
Daniel
At 14:37 2002.10.04._ +0800, you wrote:
Hi,
My tables is something like this
Value Count
B 10
C 20
A 15
D 8
When I query using SELECT Value, Count FROM Table,
When trying to create an index on
Table ANSCHLUSS:
| ID | int(11) | | PRI | NULL| auto_increment |
| TELEFON | varchar(20) | | MUL | ||
| REGION | int(11) | | | 0 ||
| LAND | int(11) |
Hi,
Do u mean when u take a dump you need to add before
each table drop table if exists
then here is the command.
mysqldump -uusername -p -hhostname
--add-drop-table databasename tablename test.sql
regards,
Praveen
--- John Kelly [EMAIL PROTECTED] wrote:
Hi, I am trying to use mysqldump to
Or your could ...
mysqldump -uusername -p -hhostname --all --add-drop-table --add-locks --
complete-insert --compress --extended-insert --flush-logs --force --opt --ve
rbose --databases databasename tablename test.sql
- Original Message -
From: swati sandhya [EMAIL PROTECTED]
To: John
John,
Friday, October 04, 2002, 6:41:46 AM, you wrote:
JK Hi, I am trying to use mysqldump to dump the structure of a single database
JK and want the output to make create table commands that include the IF NOT
JK EXISTS switch so that when the file is imported into an existing database it
JK
William,
Thursday, October 03, 2002, 10:14:04 AM, you wrote:
I have three tables in my database
t1, t2, and t3. Each table has records that are the same or similar. I
WM am
trying to SELECT part number, part description, location, part cost, sell
price and on hand quantity from these three
On Fri, 4 Oct 2002, Stephan Gloor wrote:
When trying to create an index on
Table ANSCHLUSS:
| ID | int(11) | | PRI | NULL| auto_increment |
| TELEFON | varchar(20) | | MUL | ||
| REGION | int(11) | | | 0 |
* Jan Steinman
Is there a simple way to duplicate one or more rows in a table?
I tried:
INSERT INTO table SELECT * FROM table WHERE criteria
but apparently INSERT...SELECT cannot function on the same table.
Right, but you can use an intermediate temporary table:
CREATE TEMPORARY
Andrey,
Thursday, October 03, 2002, 6:08:16 PM, you wrote:
Andrey,
Tuesday, October 01, 2002, 11:53:41 AM, you wrote:
AK Why is temporary tables replecated?
AK Is it true?
Yes, temporary table are replicated properly since 3.23.29:
Palash,
Thursday, October 03, 2002, 7:44:33 PM, you wrote:
PMK i have just installed mysql.i was able to start the mysqld
PMK process.howeveri am unable to set password for root using the following
PMK command sequence :
PMK ./bin/mysqladmin -u root -password 'abcd'
This statement
äÏÂÒÙÊ ÄÅÎØ.
Yes, temporary table are replicated properly since 3.23.29:
http://www.mysql.com/doc/en/Replication_Features.html
AK Hmm... What is the reason?
AK If I create a temporary table in one process, I can't use it in another.
AK And after close connection table will destroy.
I have tried that with no success. A suggestion was made though of just
tarring the data dir, I think I shall try that route.
Mike
-Original Message-
From: Andrew Braithwaite [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 03, 2002 6:46 PM
To: 'Mike Hillyer'; MySQL Mailing List
Using RedHat 7.2 and GCC 3.1 to compile the MySQL 4.04 beta, I get the
following error:
./gen_lex_hash lex_hash.h
./gen_lex_hash: error while loading shared libraries: libstdc++.so.4:
cannot open shared object file: No such file or directory
Is this a bug or a problem with my
Jan Steinman wrote:
This is a high-traffic list. The only way some of us can contribute is to get it in
digest format, and the endless quotes make digest reading painful.
I read the list 'live' if you will (not pre-digested) and find it
equally irritating. I'd appreciate everyone taking
Niclas Hedhman wrote:
I don't by the less functionality argument any more than if you have a good
emailer. I think I have a good emailer, and on the munging lists, I press
Reply-All, it will also send to the original author, but 95% of the case I want the
list, and original author doesn't
Well, there is the ideal setup, which requires intimate knowledge of the
database, lots of disks and extra administration. And then there is the
easy setup. Ideally you don't want to have any hot disks which will
cause contention. This requires you to place your busy tables (read or
write)
Josh Trutwin wrote:
The first query averages about 0.085 seconds from the mysql prompt, the
second about 0.075 seconds and the 3rd 0.065 seconds.
Thanks for some great advice, this has been bugging me for a while!
Its well appreciated to see examples of what works and what doesn't too;
its
.
If I may beg the List's tolerance for a while -
The practice of putting responses before the (often wildly varied and
prolix) text prompting that response means that those whose eyesight is not
what it used to be, if indeed it yet remains, do not have to wait for aeons
as speech software
Hello,
I have a very serious problem.
I hope you can give me some advice, that would be very appreciated.
I have a mysql query like this
SELECT PartnerID,CampaignID,BrowserID,count(DISTINCT IP)
FROM tblData20020930
WHERE EventType='Impression' AND
I hate this spam filter with a passion.
Original Message
Subject: Re: Re: Fwd: Re: OT: Reply-Adress in this list
Date: Fri, 4 Oct 2002 17:25:26 +0200
From: [EMAIL PROTECTED]
To: Michael T. Babcock [EMAIL PROTECTED]
sql,query
Niclas Hedhman wrote:
I don't care which
* Michael T. Babcock
Its well appreciated to see examples of what works and what doesn't too;
its nice to know how to get one's queries in an order that makes the
MySQL optimizer's life easier. I'm trying to decide if there's some
logical way to inform MySQL that it can reorder a series of
Hello there!
If I have a table with 100,000 records in and I have two columns in the
table, one an ID field (int) numbered 1 to 100,000 that is indexed etc. The
other field is a text field with say 100 words in each row.
What would produce the fastest search if I wanted to search for all
right. corereader is designed to query all
platforms from an ms. windows frontend.
Thanks John,
I looked through your web site, it seems to me that corereader is
microsoft based product. I'm on Linux RedHat 7.2.
thanks
[EMAIL PROTECTED] wrote:
corereader will help you
right. it also won't run on mainframes. :)
corereader is designed to query all platforms from
an ms. windows frontend.
Thanks John,
I looked through your web site, it seems to me that corereader is
microsoft based product. I'm on Linux RedHat 7.2.
thanks
[EMAIL PROTECTED]
Description:
I have a table with columns containing
keywords in cyrillic. If I write i.e.
select * from imgs where kw_1 like '%xx%'
(xx are two cyrillic letters and kw_1 is the first
keyword-column. The table contains 2666 rows.)
MySQL returns a lot of words(396 rows) and all of them
do
Pass Filter: sql,query
Hello All,
I have three tables in my database
t1, t2, and t3. Each table has records that are the same or similar. I
am trying to SELECT part number, part description, location, part cost, sell
price and on hand quantity from these three tables. Each part number is
the
On Thursday, Oct 3, 2002, at 20:41 America/Phoenix, John Kelly wrote:
Hi, I am trying to use mysqldump to dump the structure of a single
database
and want the output to make create table commands that include the IF
NOT
EXISTS switch so that when the file is imported into an existing
Hi,
I'm having trouble in configuring the my.cnf for optimal condition on my server.
My MySQL server (3.23.52max) is running on Solaris 8 - Sun Sparc 4 processors and 4 GB
memory.
and my.cnf is :
- keybuffer : 768M
- sortbuffer : 8M
- recordbuffer : 8M
previously is :
- keybuffer : 1024M
-
In which tables of the three that you mention are the fields:
part number, part description, location, part cost, sell
price and on hand quantity
What is the structure of each or the tables.
-Original Message-
From: William Martell [mailto:[EMAIL PROTECTED]]
Sent: Friday, October
Brent Baisley wrote:
Well, there is the ideal setup, which requires intimate knowledge of the
database, lots of disks and extra administration. And then there is the
easy setup. Ideally you don't want to have any hot disks which will
cause contention. This requires you to place your busy
I have a few questions regarding recovering an innodb tablespace/datafile.
Here's the situation.
I lose a drive on my master database that contained an innodb datafile. I then
shut the database down and umount that drive.
What would I need to copy from the slave database in order to bring the
Hi List,
I am new to mysql so I ask for your patience...
1 - I am trying to load a text file (with mysql-front) to a table that
contains a TEXTdata type field. Despite of the documentation (TEXT = 2^16
bytes), after the load of the file that field is truncate to 51 characters.
On the text file
With gcc 3.2, I get this:
g++ -DMYSQL_SERVER
-DDEFAULT_MYSQL_HOME=\/usr/local\
-DDATADIR=\/usr/local/var\
-DSHAREDIR=\/usr/local/share/mysql\
-DHAVE_CONFIG_H -I../innobase/include
-I./../include
William Martell wrote:
rice and on hand quantity from these three tables. Each part number is
the same in all three tables. The other fields are different. I would like
to display each tables data sorted by item number. I am having trouble with
my select statement.
SQL: select * from t1,
Begin forwarded message:
From: Clayburn W. Juniel, III [EMAIL PROTECTED]
Date: Fri Oct 4, 2002 10:24:06 America/Phoenix
To: Clayburn W. Juniel, III [EMAIL PROTECTED]
Subject: Re: Create table if not exists from mysqldump?
On Friday, Oct 4, 2002, at 08:48 America/Phoenix, Clayburn W. Juniel,
Hi all,
I'm fairly new to MySQL and PHP, but have been reading a few books and
experimenting a bit. I've created a php application that will allow me to
view all the fields in my Database, but have not been able to correctly
build a search function in it. Here's a little background on what
Greetings...
I am developing an application on MySQL using the MySQL API's.
I have .sql file with 1 insert statement. I want to run all the queries
in one shot. mysql_real_query() allows me to execute only one query at a
time ?
So what do you think is the best approach to execute all the
Hi everyone!
I need to run an update query on 400 sets of data.
Being given a list of 400 names with 2 email addresses (company and
private) each, the task is to update all people who have an old email
address (either company or private).
So here are my questions:
1.Is there any way I can
I'm new to this list. I hope I don't break any rules, but here goes. I'm
just getting on linux box that someone else set up with mysql 3.23. That
person unfortunately is back in school and hasn't yet answered my questions.
As if his exams are more important than my questions, imagine that.
I
On Fri, 4 Oct 2002, Cohan, Sean wrote:
How can I either remove this installation so I can reinstall the latest
version from scratch, or get mysqld started with this installation?
Find the var directory for the mysql installation. There will be log files,
typically machine.name.err
--
On Thu, Oct 03, 2002 at 06:39:26PM -0500, Shane Allen wrote:
We have a 4.0.4-beta master and slave.
The slaving process starts correctly, but randomly (and frequently) has
issues.
When the server starts, it will slave, but eventually will hit one of
two conditions:
- Duplicate key
Thanks for all the responses on how to import a dump file that will not
write over existing tables and not stop with an error on existing tables -
in other words just add missing tables. As Victoria pointed out, there is no
option in mysqldump to add the appropriate create table option [IF NOT
Two things. I see the following in one of the mysqld.log files:
021004 14:41:05 mysqld started
021004 14:41:05 /usr/libexec/mysqld: Can't find file: './mysql/host.frm'
(errno: 13)
021004 14:41:05 mysqld ended
We have red hat 2.4.7-10. When I tried to install a later version of mysql,
I
Can someone please help me with the following? Normally I would do this
with a nested select, but since this is not available in MySQL I think I
need help.
Here is what I have: An order table with sales tax total and an
orderdetail table with ordered, itemid and qty.
What I need to do is form
David McInnis wrote:
select tax from orders, orderdetail where orders.id =
orderdetail.orderid and (productid = 1 or productid = 2 or productid =
3)
I can get multiple tax amounts where an order has multiple matching
records in orderdetail. I know that I can group by order.id, but what I
Hello All,
I'm looking for a date function that will allow me to update only the year
portion of a field to a particular year, in this case, 2002.
I've tried UPDATE [table] SET YEAR([field]) = '2002' WHERE [field] 2002
but this gives me an error. The MySQL documentation only seems to cover
Here is my table schema.
Thanks for your help.
David
ORDERS
+--+---
| Field| Type
+--+---
| id | int(10) unsigned zerofill
| clientid | int(11)
| refid
So you want a SQL QUERY something like:
SELECT ORDERDETAIL.id as detailid, qty, unitcost, unitcost * qty as
extended from ORDERDETAIL
LEFT JOIN ORDERS ON orderid = ORDERS.id
WHERE ...
Right?
What's the problem you have with tax requests that you hinted at last time?
David McInnis
Well, what I need to do is something like this:
select sum(tax) from orders, orderdetail where orders.id =
orderdetail.orderid and (productid = 1 or productid = 2 or productid =
3)
The problem is this that when I run this sql query:
select orderdetail.itemid, orderdetail.id as odid, orders.id,
On Fri, Oct 04, 2002 at 12:36:30PM -0700, David McInnis wrote:
Can someone please help me with the following? Normally I would do this
with a nested select, but since this is not available in MySQL I think I
need help.
Here is what I have: An order table with sales tax total and an
I have a Mysql DB schema which consists of some core tables in a database
'core'.
Then I have about 22 separate databases which have between 20 - 150 tables a
piece. I normally will stay within one of the daughter databases but
occasionally have to mine data from one of its sisters. I would
I had gotten some feedback on this, but I still do not have enough
information on this to resolve it.
the initial thoughts comments I got from people the believed it was a
connectivity problem. this is on an internal network. the linux box has
shared drives I use all day everyday with no
Does MySQL support GUIDs? Is there any code around that is equivalent to the
built-in M$-SQL function NewID(), which returns a GUID?
TIA,
Arthur
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
In the last episode (Oct 04), Arthur Fuller said:
Does MySQL support GUIDs? Is there any code around that is equivalent
to the built-in M$-SQL function NewID(), which returns a GUID?
Providing GUIDs is usually the job of the OS, and there really isn't
much of a standard for it yet. One
I've uninstalled the previous version and installed the latest version
3.23.52.1. safe_mysqld is now running. I'm making progress but getting
bogged down in the littlest things. I feel ignorant, but I know once I get
over the first hump, I'm well on my way.
I'm trying to change the password
I'm encountering a situation with MySQL that's really driving me crazy and I
have been unable to locate a solution. I'm hoping that someone on the
mailing list can provide some guidance...
I'm attempting to use a piece of php software (phpBB) which is talking to a
dedicated MySQL server via
Hi!,
From: W [mailto:[EMAIL PROTECTED]]
Sent: 04 October 2002 15:11
To: [EMAIL PROTECTED]
Subject: Question Regarding Update Year statement
I'm looking for a date function that will allow me to update only the year
portion of a field to a particular year, in this case, 2002.
I've tried
-Original Message-
From: Dicky Wahyu Purnomo [mailto:[EMAIL PROTECTED]]
Subject: Memory Limit
And what is the calculation for the memory also
The formula you want is (this does not account for InnoDB buffers either):
key_buffer_size + (record_buffer +
HELP ! I'm a newbie to both Linux mySQL.
I have a simple mySQL sample data base running on a
Red Hat 7.3 machine.
It was already setup when I got it.
Now I want to find the data base files that mySQL
creates so I can back them up... and for my education.
I can't seem to get Linux to search
On Fri, 2002-10-04 at 20:38, tmb wrote:
HELP ! I'm a newbie to both Linux mySQL.
I have a simple mySQL sample data base running on a
Red Hat 7.3 machine.
It was already setup when I got it.
Now I want to find the data base files that mySQL
creates so I can back them up... and for my
Installed mysql-3.23.43-pkg on Solaris Sparc 8. Get the missing library
error on everything I try.
Anyone know what to do?
Here's the error log entry for the command ./usr/local/bin/safe_mysqld
--user=mysql
021004 21:41:12 mysqld started
ld.so.1: /usr/local/mysql/libexec/mysqld: fatal:
1 - Where does mySQL normally store it's data base
files?
* From what I have seen, it depends on how you install it. You can
check in the my.ini file and that will let you know where it is.
2 - Can you change the default directory for a data
base?
* Yes, you can change this in the
At 23:46 2002-10-04, Chris Couture wrote:
1 - Where does mySQL normally store it's data base
files?
* From what I have seen, it depends on how you install it. You can
check in the my.ini file and that will let you know where it is.
On Linux (which I believe is the one in question) it
1)Is it possible to enable LOAD DATA LOCAL INFILE from the configuration
file?
My.ini file is below:
[mysqld]
basedir=C:/mysql
datadir=C:/mysql/data
enable-local-infile
local_infile=1
When I perform the LOAD DATA LOCAL INFILE 'file_name.txt' INTO... command
from a client application using
I have a db with slightly over 614,000 records of names and addresses. In
the address column, there are quite a few records like
123 any rd # 2
319 w. 1st st # B
4321 test blvd # 42
etc
I want to replace all the number signs with the actual word 'number'.
Is there a SQL command I can use for
67 matches
Mail list logo