Li, Lenny Yong Bo (Lenny) wrote:
Now I am assigned to do the backup of a whole mysql database (version: 3.23.36). I
want to make sure whether the following procedures are correct for database backup.
1. mysqldump -F --opt database_name database_name.backup
In my opinion, you should
Hi
I am linking my program (which works fine on a PA-RISC 32-bit) with
libmysqlclient_r.a. The following error is reported.
ld: Mismatched Data ABI. Expected None but found EF_IA_64_ABI64 in file
libmysqlclient_r.a[libmysql.o]
How do I resolve the error. Hope somebody can throw light on
Hello, Could someone help me with a tip on how I can convert my old Access DBs to
MySQL?
Regards
/Jonas
Fred,
Thanks for your quick response!
Do you mean that only one step is enough for a backup mysqldump -F --opt
--quote-names database_name database_name.backup? The second step is not needed at
all. Am I right?
I added the option -Q, it failed, but the --quote-names option works well.
Jonas Lindén wrote:
Hello, Could someone help me with a tip on how I can convert my old Access DBs to MySQL?
Hello Jonas, I managed to do this out of Access by exporting the tables
to a MyODBC DSN.
Please check the column types later - don't know if they are all
converted correctly.
Regards,
Andrey Kotrekhov [EMAIL PROTECTED] wrote:
SQL
Hi, All!
Is 4.1.1 replication compatible with 4.0.x?
I have problem to replicate data from 4.0.17 to 4.1.1
show slave status show all are OK
perlicate position and the exec position are the same.
But if I update data on master, slave is not
I was wondering if I can user libmysqld with PHP.
If it's possible would someone post a simple exampe.
TIA,
David
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SQL
Hi!
Andrey Kotrekhov [EMAIL PROTECTED] wrote:
SQL
Hi, All!
Is 4.1.1 replication compatible with 4.0.x?
I have problem to replicate data from 4.0.17 to 4.1.1
show slave status show all are OK
perlicate position and the exec position are the same.
But if I update data on
Andrey Kotrekhov [EMAIL PROTECTED] wrote:
Andrey Kotrekhov [EMAIL PROTECTED] wrote:
SQL
Hi, All!
Is 4.1.1 replication compatible with 4.0.x?
I have problem to replicate data from 4.0.17 to 4.1.1
show slave status show all are OK
perlicate position and the exec position are the
hi ,
Can somebody help me tocenter this table
?
?php/* Connecting, selecting database
*/$link = mysql_connect("localhost", "root", "z")
or die("Could not connect : " . mysql_error());#echo "Connected
successfully";mysql_select_db("abcd") or die("Could not select
database");
/*
I think that
print table border=\1\ cellpadding=\5\ cellspacing=\0\
align=\center\\n;
or
print centertable border=\1\ cellpadding=\5\ cellspacing=\0\
align=\center\/center\n;
should be enough...
Jiri Matejka
==Wednesday, February 25, 2004 11:26 AM [EMAIL PROTECTED] wrote:
hi ,
Can
Hi,
I have an application working in Windows, developed in VB5 using RDO method
to access data.
I use a parametrised query that is correctly working on e PC with Office97
installed.
When is installed Office2000 I receive the error:
07002:[MYSQL][ODBC 3.51 Driver]
[mysqld-3.23.53 max]
.
What replication options do you use?
Check if queries are present in the master binary logs and in the relay l=
ogs on the slave.
I research the problem and have got some details.
Now we have this theme of mysqld replication (with server ids)
+-+
+--+-1|
?
...
...
/* Performing SQL query */
$query = SELECT * FROM ServiceStatus;
$result = mysql_query($query) or die(Query failed : . mysql_error());
?
!-- Printing results in HTML catering for all browsers --
div style=text-align:center;
table border=1 cellpadding=5 cellspacing=0
can i create a constraint to a field so that every data entered to that
field (string) be stored in uppercase, if is posible can anybody give me an
example or point me to a link with documentation.
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Hi Ricardo,
can i create a constraint to a field so that every data entered to that
field (string) be stored in uppercase, if is posible can anybody give me
an
example or point me to a link with documentation.
MySQL doesn't support check constraints.
With regards,
Martijn Tonies
Database
I am running Delphi 6 Ent. along with Corelab
technology to access MySQL 4.1.14.
We run into problem of table coruption (error: 127,
145) from time to time using the following SQLs. This
is done in the transaction context. Most of the time
it works fine but it does get into problem. We have
What replication options do you use?
Check if queries are present in the master binary logs and in the relay l=
ogs on the slave.
I research the problem and have got some details.
Now we have this theme of mysqld replication (with server ids)
+-+
Andrey Kotrekhov [EMAIL PROTECTED] wrote:
What replication options do you use?
Check if queries are present in the master binary logs and in the rela=
y l=3D
ogs on the slave.
I research the problem and have got some details.
Now we have this theme of mysqld replication (with server
Hi!
I have a problem with logging. I am logging all
queries to MySQL server. And I have a program which
inserts large chunks of data. The problem is that I
would like to log all queries except for those insert
queries as those flood my logs (they get really very
big). The program is written in
Hi,
One of our enterprise database servers (MySQL 4.0.16-max on Solaris 9)
recently refused connections with a 1203 error, User [username] has
already more than 'max_user_connections' active connections.
Show variables like '%conn%' displayed:
+--+---+
| Variable_name
I have a 3.x database that I backed up and restored to a 4.0 server. All
worked fine, except for one issue:
One table holds addresses, and when restoring it, would fail with an
unmatched quotes message.
On further examination, I found that it would occur on entries where the
text was like 123
Ok
I think I am a bit confused on how the MAX_ROWS works...
This is the result of SHOW TABLE STATUS \G:
Name: gabe_test
Type: MyISAM
Row_format: Fixed
Rows: 33
Avg_row_length: 5
Data_length: 165
Max_data_length: 327679
Index_length: 1024
I use SQLyog - http://www.webyog.com/sqlyog
It has a pretty good ODBC Import Wizard.
Karam
--- Jonas_Lindén [EMAIL PROTECTED] wrote:
Hello, Could someone help me with a tip on how I can
convert my old Access DBs to MySQL?
Regards
/Jonas
__
Do you Yahoo!?
Eric B. [EMAIL PROTECTED] wrote:
I know that in 4.11+ you can preload your MYI index file into the key cache
using LOAD INDEX (http://www.mysql.com/doc/en/Index_preloading.html), but is
there a way to configure MySQL to do this whenever the MySQL service starts?
I'm willing to write .sql batch
Mike Mimic [EMAIL PROTECTED] wrote:
Hi!
I have a problem with logging. I am logging all
queries to MySQL server. And I have a program which
inserts large chunks of data. The problem is that I
would like to log all queries except for those insert
queries as those flood my logs (they get
Hi!
When i'm using mysql client, version 12.21 - Distrib: 4.0.15 / windows,
for queries or loading data, i always get an error 2013 (lost
connection...)
after 30 seconds and the connection breaks down.
This doesn't happen, when i use the older version 11.16 , Distrib: 4.0.0 /
windows.
There is no
Look into the mysql_insert_id function, that looks like what you want.
On Feb 24, 2004, at 12:02 PM, David Scott wrote:
Hi list peeps
In many of my projects I have the need to insert a new record into a
table and then later on in the script update this record, Right now I
am doing this by
Bungarz, Kai [EMAIL PROTECTED] wrote:
When i'm using mysql client, version 12.21 - Distrib: 4.0.15 / windows,
for queries or loading data, i always get an error 2013 (lost
connection...)=20
after 30 seconds and the connection breaks down.
This doesn't happen, when i use the older version
This is the query i want to run but i doesn't work.
select id from c_table where users_id in (select id from users wherelocations_id=3) order by data_ora
But it gives me this error:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for
Hai MySQLians,
I have listed down the log details which shows the mysql servers normal shutdown and
improper
shutdown while it got trouble from C coding.
Log details from c:\mysql\data\mysql.err
MySql: ready for connections.
Version:
Hi,
I have a question regarding to search with fulltext on table and fetch
the data from another.
Table one:
id, textid, name, number, url
Table two:
id, text
On table two there is a fulltext index.
These two tables recently was one table, but i had to split them due to
the amount of data.
Gregorio [EMAIL PROTECTED] wrote:
This is the query i want to run but i doesn't work.
select id from c_table where users_id in (select id from users where
locations_id=3) order by data_ora
But it gives me this error:
You have an error in your SQL syntax. Check the manual that
Have you changed the interactive_timeout and wait_timeout values?
Original Message
On 2/24/04, 4:54:57 PM, [EMAIL PROTECTED] wrote regarding inserting huge
string:
hi,
I am using mysql 4.0.14. I have a table where one of the fields has a
datatype longblob. What I am trying to do is
What MySQL version are you running?
Original Message dated 2/25/04, 9:19:43 AM
Author: Gregorio [EMAIL PROTECTED]
Re: Nested queries:
This is the query i want to run but i doesn't work.
select id from c_table where users_id in (select id from users where
locations_id=3) order by data_ora
Gregorio [EMAIL PROTECTED] wrote on 25/02/2004 15:19:43:
This is the query i want to run but i doesn't work.
select id from c_table where users_id in (select id from users where
locations_id=3) order by data_ora
But it gives me this error:
You have an error in your SQL syntax.
Greetings,
Our MySQL server (4.0.13) is currently running with the option
--skip-networking. We want the server to accept TCP/IP connections. If
this option were specified in the config file, perhaps I could just modify
the config file and HUP the server process. So there would be no server
Think that is for your script to work on, i.e.
INSERT INTO table
(field1, field2)
VALUES (UCASE('form.field1'), form.field2)
depending on the syntax of your programming language (and which MySQL
version you are using). The above works on 4.1.1.
Terry
--Original
Thanks Victoria! I must have missed that option. Exactly what I was
looking for!
Eric
Victoria Reznichenko [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Eric B. [EMAIL PROTECTED] wrote:
I know that in 4.11+ you can preload your MYI index file into the key
cache
using LOAD
My program, NCR (Non-Conformity Report), keeps track of problems with
items that are received from vendors. I am creating a report where the
user can retrieve a list of vendors that have had a NCR written against
them a certain number of times. For example, if the user wants to see
what vendors
Jacque Scott wrote:
My program, NCR (Non-Conformity Report), keeps track of problems with
items that are received from vendors. I am creating a report where the
user can retrieve a list of vendors that have had a NCR written against
them a certain number of times. For example, if the user
That works. I knew I was missing something simple. It was the GROUP BY
and the HAVING together.
Thank you very much.
Michael Stassen [EMAIL PROTECTED] 2/25/2004 9:05:34 AM
Jacque Scott wrote:
My program, NCR (Non-Conformity Report), keeps track of problems
with
items that are received
We've recently started using MySQL for customers with a large number of
records on their systems.
For the first time, one of our customers has gone over the 4 million
record mark, and we're running into some problems with the MAX_JOIN_SIZE
and the SQL_BIG_SELECTS. Using the control center, or
Hi,
I have a strange problem in the return types of the query:
select count(*) from table gives in MySQL Version 4.0.18 an return
type of long. In Version 4.1.1 its an char (0).
The query goes vi MyODBC to MySQL. I checked the ODBC Trace to see
the different return types.
Does anyone know about
Hello,
Sorry if this is a obvious question, but I am new to mySQL, and PHP. I am
used to working with MS SQL Server 2000 and coldfusion. In SQL server I can
build DTS packages and schedule them to update the data in my tables with
different queries, and to import current data from other
On 25 Feb 2004 at 8:35, Tucker, Gabriel wrote:
What values of MAX_ROWS and AVG_ROW_LENGTH would I need so that I
could limit this table to 3 [or n] number of records?
You can't. That's not what MAX_ROWS and AVG_ROW_LENGTH are for.
They're only there to allow MySQL to decide how many bytes
So I'm having issues with indexes in mysql 4.0
I issue the following:
Create Index Index1 on Table1 (ParentID,ClassID,Amount,Memo(20));
That works fine. However I'm running into problems when I'm trying to
insert into this table using INSERT I'm receiving errors about duplicate
keys against
I am doing a very simple query joining two copies of tables with identical
structures but different data. We are running MySQL 4.1.1.
The tables each have about 24,000 lines of data in them. For some reason
this query, which is a simple join between the two tables is taking 8
minutes to run.
I am doing a very simple query joining two copies of tables with identical
structures but different data. We are running MySQL 4.1.1.
The tables each have about 24,000 lines of data in them. For some reason
this query, which is a simple join between the two tables is taking 8
minutes to run.
What does the explain look like?
-Original Message-
From: Eric Scuccimarra [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 25, 2004 1:03 PM
To: [EMAIL PROTECTED]
Subject: Query Problems
I am doing a very simple query joining two copies of tables with identical
structures but
Do you have separate indexes on:
Table1.ID
Table2.ID
Table1.Field1
Table2.Field1
Table1.Field1
Table1.Field2
Select*
FROM Table1 as a
INNER JOIN Table2 as b ON (a.ID = b.ID or (a.Field1 = b.Field1 and
a.Field2 = b.Field2))
WHERE bla bla bla
We have
Jonas
Check out the free DBManager at http://www.dbtools.com.br/EN/dbmanager.php
It can not only import directly from Access but might be very handy later in
your every day work with MySQL as a front-end
Couldn't live without it !
Freddie
-Ursprüngliche Nachricht-
Von: Jonas Lindén
I usually use php for most of my work, but I have to run a fair percentage
of maintenance etc from the mysql shell program. I have a record that has
an apostrophe and so was inserted using php by escaping the ' with \ so that
it was put in as \' and it shows up in the record as O'Brien as it
At 02:32 2/25/2004, Jonas Lindén wrote:
Hello, Could someone help me with a tip on how I can convert my old Access
DBs to MySQL?
Regards
/Jonas
I've had some success with Cynergi.net's ExportSQL script
http://www.Cynergi.net/exportsql/
Start Here to Find It Fast! -
Are you using the DTS to schedule replication or periodic data imports?
Original Message
On 2/25/04, 11:48:02 AM, HACKATHORN, TODD (SWBT) [EMAIL PROTECTED] wrote
regarding updating tables in MySQL:
Hello,
Sorry if this is a obvious question, but I am new to mySQL, and PHP. I
am
used to
Can you do a show create table Table1 and see how the index is defined?
Original Message
On 2/25/04, 12:02:43 PM, James Lamanna [EMAIL PROTECTED] wrote
regarding Problem with indexes:
So I'm having issues with indexes in mysql 4.0
I issue the following:
Create Index Index1 on Table1
At 14:25 -0500 2/25/04, Larry Brown wrote:
I usually use php for most of my work, but I have to run a fair percentage
of maintenance etc from the mysql shell program. I have a record that has
an apostrophe and so was inserted using php by escaping the ' with \ so that
it was put in as \' and it
Are you not able to do
SELECT *
FROM table
WHERE col = O\'Brien
?
Original Message
On 2/25/04, 1:25:06 PM, Larry Brown [EMAIL PROTECTED]
wrote regarding command line escape for apostrophe:
I usually use php for most of my work, but I have to run a fair
percentage
of maintenance etc
On 25 Feb 2004 at 13:09, Eric Scuccimarra wrote:
Select*
FROM Table1 as a
INNER JOIN Table2 as b ON (a.ID = b.ID or (a.Field1 = b.Field1 and
a.Field2 = b.Field2)) WHERE bla bla bla
It's hard to know without seeing the indexes and the full WHERE
clause, but part of the
Description:
When a temp table is included twice in a query mysql fails with the
error:
ERROR 1137 at line 9: Can't reopen table: 'foo'
This happens on both 4.0.17 and 4.0.18. It did not happen on 4.0.14.
How-To-Repeat:
create temporary table test (pk int primary key);
select * from test as
Hi,
Currently our web infrastructure has one main MySQL server, to which connections are
made by (mostly) mod_perl running under Apache
(on 3 different machines), and several other custom-built application servers on other
servers (which have persistant connections,
and do both reads and
My bad people. The error was elsewhere in the query, but the error
happenned to describe the query as failing near where the apostrophe was.
Sorry to waste anyone's time.
Larry
-Original Message-
From: Larry Brown [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 25, 2004 2:25 PM
To:
Hi! One of my associates here read a report somewhere that mysqld when
compiled under OS X 10.3 was 40%+ more efficient due to improvements in the
compilers and the way 10.3 work. Also 10.3 is a 64 Bit Operating System and
it would be a major benefit to us to set some of the memory values in
HACKATHORN, TODD (SWBT) wrote:
Hello,
Sorry if this is a obvious question, but I am new to mySQL, and PHP. I am
used to working with MS SQL Server 2000 and coldfusion. In SQL server I can
build DTS packages and schedule them to update the data in my tables with
different queries, and to import
A Z wrote:
I am running Delphi 6 Ent. along with Corelab
technology to access MySQL 4.1.14.
We run into problem of table coruption (error: 127,
145) from time to time using the following SQLs. This
is done in the transaction context. Most of the time
it works fine but it does get into problem.
Cliff Addy wrote:
I've got on that really has me stumped ...
I've modified tha analog web stats program before to use a mysql database
before and I'm trying to do it again on a new system. I have this
function:
void db_connect(){
printf(start connect\n);
mysql_init(dbh);
if
I'm about to pull my hair out on this one so I thought I would see if
somebody could point me in the right direction.
I have a subquery that like like so.
SELECT *
FROM Word
INNER JOIN DomainWord
USING ( word )
INNER JOIN Domain
USING ( domain )
WHERE Domain.domain = ANY(
SELECT Domain.domain
Found out that the problem was actually a bug in 4.0.17.
Upgrading to 4.0.18 seems to have fixed the problem.
Noted here:
http://bugs.mysql.com/bug.php?id=2446
[EMAIL PROTECTED] wrote:
Can you do a show create table Table1 and see how the index is defined?
Original Message
On 2/25/04,
I am assuming that the Memo field is a text datatype and you were
encountering the duplicate key bug.
Original Message
On 2/25/04, 3:28:58 PM, James Lamanna [EMAIL PROTECTED] wrote
regarding Re: Problem with indexes:
Found out that the problem was actually a bug in 4.0.17.
Upgrading to
At 02:06 PM 2/25/2004, you wrote:
Hi,
Currently our web infrastructure has one main MySQL server, to which
connections are made by (mostly) mod_perl running under Apache
(on 3 different machines), and several other custom-built application
servers on other servers (which have persistant
Yes.
[EMAIL PROTECTED] wrote:
I am assuming that the Memo field is a text datatype and you were
encountering the duplicate key bug.
Original Message
On 2/25/04, 3:28:58 PM, James Lamanna [EMAIL PROTECTED] wrote
regarding Re: Problem with indexes:
Found out that the problem was actually
I'm currently running mysql 4.0.13 on red hat 7.2. The following create
table query currently requires the user to use SET SQL_BIG_TABLES=1 for the
query to go through on the master successfully. However, that doesn't seem
to get set when the slave tries to replicate the create table statement.
Good afternoon,
How can I take the 3 results below add them together then divide by
131.77?
Can it all be done in one SQL statement?
Thanks in advance.
mysql describe ads;
+---+---+--+-+++
No, we tried individual indexes and then one big grouped index but not
individual indexes on each of the fields. Adding the index actually added a
few seconds to the query so we weren't sure if that was the way to go.
I'll try this, though.
Eric
At 10:36 AM 2/25/2004 -0800, Daniel Clark
I know Oracle likes the indexes separatly, but mySQL might like combinations.
No, we tried individual indexes and then one big grouped index but not
individual indexes on each of the fields. Adding the index actually
added a few seconds to the query so we weren't sure if that was the way
to
Hello List:
I have installed MySQL Master Server from Binaries 4-5 times without
problem. Now I am installing MySQL CLIENT from source and have run into
problem, as explained below:
Download mysql-5.0.0-alpha.tar.gz in /usr/local
% cd /usr/local
% gunzip
What is the preferred way of storing a dollar amount in the range
0.00 - 9.99?
double
decimal(11,2)
bigint (storing value*100)
...?
I'm more interested in speed of use as an indexed column (especially
for range searches) than in disk space usage.
-keith
--
MySQL General
What about
SELECT (SUM( ads.col * 1.91) * ads.depth ) ) / 131.77
FROM ads
WHERE date = '2004-02-26'
AND editionID = '13'
AND ads.page = '16'
Original Message
On 2/25/04, 4:19:12 PM, Rogers, Dennis [EMAIL PROTECTED] wrote
regarding Query help - add results then divide by :
Good
Thanks so much!!
SELECT (SUM(( ads.col * 1.91) * ads.depth ) / 131.77) * 100
FROM ads
WHERE date = '2004-02-26'
AND editionID = '13'
AND ads.page = '16'
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 25, 2004 5:55 PM
To: Rogers, Dennis
Cc:
I'm sure this is in the manual somewhere or in the archives, but
I'm not finding it and I bet someone easily knows the short answer:
Using 3.23
setting a varchar field to PASSWORD(secret)
Having altered nothing regarding encryption in the server
what is the default encryption type for PASSWORD?
Summary: When I run a fulltext search, it always returns no results. I have
added a fulltext index to the column being searched. Also, I am searching
for a term that is in the table, but not in more than 50% of the rows.
I notice that when I add EXPLAIN to my search, the key_len of my fulltext
Excuse if i'm not correct but this may be your problemo ?
MySQL 3.23.55 running on my webhost's Linux box
phpMyAdmin 2.1.0
I didnt think fulltext was in 3.23 wasnt this a Mysql 4 feature ??
Summary: When I run a fulltext search, it always returns no results. I
have added a fulltext index
You might want to post this on the PHP user lists at news.php.net sub-group
php.general
Respectfully,
Ligaya Turmelle
David Jackson [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I was wondering if I can user libmysqld with PHP.
If it's possible would someone post a simple exampe.
I think that you can just do this:
select sum(ads.col)*1.191*sum(ads.depth)/131.77 where date ='2004-02-26'
AND editionID = '13' AND ads.page = '16';
because of the disttributive property of multiplication.
(2 * 1.191) +(6*1.91) +(4*1.91)/131.77 = 12 *1.91/131.77 =
(12*1.91)/131.77 =
040225 13:57:20 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
040225 13:57:21 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
040225 13:57:22 InnoDB: Log file
Stanton, Brian wrote:
I'm currently running mysql 4.0.13 on red hat 7.2. The following create
table query currently requires the user to use SET SQL_BIG_TABLES=1 for the
query to go through on the master successfully. However, that doesn't seem
to get set when the slave tries to replicate the
Hi folks,
my system: openbsd 3.3
mysql ver: 4.0.18
Well, I was working on phpBB conf, when I've seen errors from mysql:
mysql use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Didn't find any fields in
Rogers, Dennis wrote:
Good afternoon,
How can I take the 3 results below add them together then divide by
131.77?
Can it all be done in one SQL statement?
Thanks in advance.
mysql describe ads;
+---+---+--+-+++
Bruce Dembecki wrote:
Hi! One of my associates here read a report somewhere that mysqld when
compiled under OS X 10.3 was 40%+ more efficient due to improvements in the
compilers and the way 10.3 work. Also 10.3 is a 64 Bit Operating System and
it would be a major benefit to us to set some of the
Hi Bruce,
On Thu, 2004-02-26 at 06:26, Bruce Dembecki wrote:
Hi! One of my associates here read a report somewhere that mysqld when
compiled under OS X 10.3 was 40%+ more efficient due to improvements in the
compilers and the way 10.3 work. Also 10.3 is a 64 Bit Operating System and
it would
Hello All,
How can I dump selected rows into a file (using a query or mysqldump)?
i.e, I want to dump only the rows of this query:
SELECT * FROM tbl WHERE id100 AND id200;
thanks in advance,
-Lorderon.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
At 2:50 +0200 2/26/04, Lorderon wrote:
Hello All,
How can I dump selected rows into a file (using a query or mysqldump)?
i.e, I want to dump only the rows of this query:
SELECT * FROM tbl WHERE id100 AND id200;
mysqldump --help shows that it takes a --where / -w option.
So:
mysqldump -w id100
Hello Everyone,
If I run the following query in MySQL Control Center or MySQL-Front it
works correctly,
SELECT -1 AS ProductID, Add New Part AS PartNumber, AS
VendorPartNo, AS Description, AS VendorStatus
FROM Products
UNION SELECT ProductID, PartNumber, If(SubNo=1135,
Tried to make the indexes separate and did an EXPLAIN and no performance
increase and this is what the explain says:
id select_type table typepossible_keys
key key_len ref rowsExtra
1 SIMPLE tb ALL PRIMARY,tb_ndx3,tb_ndx4,tb_ndx5
NULL
Something like that:
SELECT - INTO OUTFILE 'filename' FROM Table etc etc ;
Marcelo Araujo
On Wednesday 25 February 2004 21:50, Lorderon wrote:
Hello All,
How can I dump selected rows into a file (using a query or mysqldump)?
i.e, I want to dump only the rows of this query:
SELECT *
At 15:02 -0700 2/25/04, Colleen Dick wrote:
I'm sure this is in the manual somewhere or in the archives, but
I'm not finding it and I bet someone easily knows the short answer:
Using 3.23
setting a varchar field to PASSWORD(secret)
Having altered nothing regarding encryption in the server
what is
Say I have this query:
SELECT *
FROM topics
ORDER BY lastPostTime DESC;
How would I modify it to answer the question How many rows would be
returned before the row that has topics.id = $x?
I was thinking of something like this:
$xPostTime = SELECT lastPostTime FROM topics WHERE id = $x;
I've got a query that I can't seem to get optimized, so I'm
hoping someone here can spot something I've missing!
Table has three columns:
CoordID int unsigned,
Zip_Lo char(9),
Zip_Hi char(9)
Table has 3 million records
indexes:
acg_lo (Zip_Lo)
acg_hi (Zip_Hi)
acg_combined (Zip_Lo, Zip_Hi)
Maybe i'm wrong here, someone correct me, if its just int's you are gonna
use set the field types to bigint it may search faster you are doing a
character search, to get there quicker in a text search scenerio i'd
suggest mysql4 and full text searching MATCH AGAINST
I've got a query that I
Paul DuBois wrote:
At 15:02 -0700 2/25/04, Colleen Dick wrote:
I'm sure this is in the manual somewhere or in the archives, but
I'm not finding it and I bet someone easily knows the short answer:
Using 3.23
setting a varchar field to PASSWORD(secret)
Having altered nothing regarding encryption in
1 - 100 of 104 matches
Mail list logo