At 15:36 2002-11-10 -0800, you wrote:
From: A. J. Maclean [EMAIL PROTECTED]
I have a query like this:
SELECT * FROM bc_posts WHERE MATCH (post_city, post_location, post_details,
post_message) AGAINST ('webster');
I get the results as follows:
webster hall
webster
webster hall club
How come
Hi,
I have a mysql table:
mysql describe eventlog;
+-+--+
| Field | Type |
+-+--+
| id | int(10) unsigned |
| time| datetime |
| source | varchar(10) |
| description | varchar(255) |
Hi,
Try this MS Access macro (VB):
http://www.cynergi.net/exportsql/exportsql2.txt.
I have used it but needed to:
- change it to filter out the tables I needed
- alter the way the create statements were generated
Regards,
Petter Ulltveit-Moe
-Mensaje original-
De: John Ragan
Pada Mon, 11 Nov 2002 08:02:31 +0100
Massimo Petrini [EMAIL PROTECTED] menulis:
Good morning to all
On mysql 4,0,4 running under W2K SP3, when I run the command SLAVE STOP;
the
command it is not execute and it remain pending (the prompt of mysql
doesn't
return); instead all is normal
Howdy -
I wonder if there is an more efficient way to do the following:
I have 2 tables -
The user submits a new record into table A and an id (primary key) is
created using the auto-increment.
At the time that the new record is created in table A I need to insert the
newly created id from table
Howdy -
I wonder if there is an more efficient way to do the following:
I have 2 tables -
The user submits a new record into table A and an id (primary key) is
created using the auto-increment.
At the time that the new record is created in table A I need to insert the
newly created id
here is a function i added to my pear DB abstraction class
function lastinsertID(){
$id = mysql_insert_id($this-connection);
return $id;
}
-Original Message-
From: Mark Stringham [mailto:mstringham;edeasolutions.com]
Sent: Monday, November 11, 2002 8:54 PM
To: [EMAIL
Hi,
On Mon, Nov 11, 2002 at 02:52:02AM -0700, Mark Stringham wrote:
I wonder if there is an more efficient way to do the following:
I have 2 tables -
The user submits a new record into table A and an id (primary key) is
created using the auto-increment.
At the time that the new record is
-Original Message-
From: Sergei Golubchik [mailto:serg;mysql.com]
Sent: 10 November 2002 12:23
To: Christian Sylvestre
Cc: [EMAIL PROTECTED]
Subject: Re: SELECT slow after adding INDEX on MERGE table
Hi!
What is the query, and what does EXPLAIN say ?
The query is:
SELECT
daniel,
Monday, November 11, 2002, 3:51:25 AM, you wrote:
d will 4.1 hopefully have stored procedure functionality ?
Nope.
Stored procedures will be implemented around v5.0
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net
Mark,
Monday, November 11, 2002, 11:53:38 AM, you wrote:
I wonder if there is an more efficient way to do the following:
I have 2 tables -
The user submits a new record into table A and an id (primary key) is
created using the auto-increment.
At the time that the new record is created in
Robert,
Saturday, November 09, 2002, 10:23:03 PM, you wrote:
RJ I tried using the instructions I found in the MySQL manual and got hung
RJ up on starting the MySQL server in an unsecured state. The instructions
RJ say to start mysqld with the --skip-grant-tables option. When I do I
RJ get a
lizard,
Sunday, November 10, 2002, 9:32:33 AM, you wrote:
l My name is Mike.
l I have a Linux RedHat 7.3 with Mysql ver 3.23.49.
l I want to grant access to databases and tables to users,but only to a certin
l databases and tables.
l I red the how-to but both grant and revoke commands does not
john,
Saturday, November 09, 2002, 9:45:15 PM, you wrote:
j Ok.. I got the /etc/my.cnf under control, but now when I do this:
j root@rock:/etc# mysqladmin -u root -h rock password *
j mysqladmin: connect to server at 'rock' failed
j error: 'Host 'rock.biohazard.org' is not allowed to connect
Mike,
Sunday, November 10, 2002, 4:16:29 AM, you wrote:
MD Background: I've got a master and slave setup
MD and I'm switching to a new master server. In the process of switching I
MD need the new master to be a slave for awhile. However, after copying
MD over a snapshot of my data I found
Hi
according to this link... 4.1 will have stored procedures
http://www.mysql.com/products/mysql-4.0/index.html
Rich
With the efficiency comment below, I was using the strategy that I'd
prefer
to wait for 4.1's impending (?) release rather than rewrite SQL in a
workaround way.
damn , i read it was 4.1 i guess we have to wait a bit then, i wish i could
program some c ++ to hurry it along a bit, i dont really have access to DB's
like oracle to learn stored procedure stuff
-Original Message-
From: Victoria Reznichenko [mailto:victoria.reznichenko;ensita.net]
Sent:
Greetings to everyone. I have trouble getting mysql shell to use
mysql.sock file which is not located in /tmp. I fixed all entries in
/etc/my.cnf but mysql shell still complains about /tmp/mysql.sock missing.
The only workaround I have found is --socket. Is there a way to make the
shell use the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 11 November 2002 13:03, Richard Morton wrote:
according to this link... 4.1 will have stored procedures
http://www.mysql.com/products/mysql-4.0/index.html
Oops, that page needs to be updated. Stored procedures will come with
MySQL 5.0,
hey, can i hijack my message back?...this thread is about the performance of
subselects, not stored procedures. go write your own message :-)...
sothe original question is if someone would be nice enough to answer..
Do any MySql coders writing subselects in 4.1 know whether EXISTS will
Greetings
Can somebody point to any resource where I can get the equivalent datatype
of MySQL for SQL Server, Oracle and Access
Rgds
Insane
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I'm not sure where you're getting your information (Typically, db vendors
recommend you use an exists clause, not a join when testing for the presence
of child data because it's faster). Not to say that you're incorrect, just
that in working for years with MS-SQL and Oracle and before that Sybase,
Hi Folks,
facts: i have a statistic-database for a
php/mysql content-monitoring program.
the problem: the tables have many entries, and
so i need to optimize all my queries, which
join many tables to one result.
i tried any solution, but i only got minimal
here is one query:
SELECT
How big is the index file. and what type of filesystem is it stored on?
Could this be a 2G filesize limit problem?
[EMAIL PROTECTED] wrote:
Hi,
I have a mysql installed ona RedHat 7.3 machine. The problem is that I am
getting the error 127 many times. Each time I repair the table and after
You have no where clause.
The cartesian product you are creating
could be very large, and may be filling your temp
directory. This will make it appear to have crashed
when it is merely waiting for disk space.
Next time this happens, check freespace.
Eugene Bendersky wrote:
May be this was
Dan Rossi wrote:
damn , i read it was 4.1 i guess we have to wait a bit then, i wish i could
program some c ++ to hurry it along a bit, i dont really have access to DB's
like oracle to learn stored procedure stuff
Don't forget that with MySQL, you can link in external procedures though
...
A Cartesian product will generate the number of rows in Table 1 times the
number of rows in Table 2. For example if T1 has 1,000 rows and T2 has
10,000 rows your result set will contain 10,000,000 rows.
Arthur
-
Eugene Bendersky wrote:
May be this was reported
Hi, I noticed when looking at the spec file for the linux rpm for MySQL
4.0.4 that it noted that ssl support had been disabled until it worked
again. Is the problem with ssl support just with linux or does it also
not work under other platforms (e.g. Solaris)?
Thanks,
Robin McMillon
[EMAIL
Hi, all,
Greetings.
sql, query.
Anyone of you know the parameter for my.cnf to turn autocommit off for
innoDB transaction-safe tables?
Thank you,
Jing
_
MSN 8 with e-mail virus protection service: 2 months FREE*
Hi,
I need some help to install mysql.
I downloaded the rpm for Linux. I installed it successfully based on the
messages I received at the end of the installation. However, I could not
find the mysqladmin tool any where and I do not know what else is missing
from my installation. I would
In the last episode (Nov 11), Greg Matthews said:
hey, can i hijack my message back?...this thread is about the performance of
subselects, not stored procedures. go write your own message :-)...
sothe original question is if someone would be nice enough to answer..
Do any MySql
Dicky Wahyu Purnomo wrote
on master you need to define which databases will be created in binlog file.
(--binlog-do-db=dbname)
Thanks for you reply, but this does not help. Again - I see in slaves
relay-bin.001 that slave had replicated the query, but the table was not
changed
to check this
Anyone of you know the parameter for my.cnf to turn autocommit off for
innoDB transaction-safe tables?
Not settable in my.cnf/ini AFAIK. In MySQL write ...
SET @@local.autocommit=0|1
PB
-
Before posting, please check:
Hello,
I have a column with a name of a person, say Franklin D. Roosvelt. Can I
query the table so that the name will be retrieved in the following format:
Roosvelt, Franklin D.
Any help will be appreciated.
--Kevin
-
Before
Hi all
I am working with mysql, in windows, visual c++.
I am trying to run this query from c++ program:
select * into outfile 'table_name.txt' FIELDS TERMINATED BY '\t' ESCAPED BY
'\0' LINES TERMINATED BY '\r' from table_name
And i get exception with this error: access is denied for user
Hello,
I need your help urgent!
I've a problem whit some tables in mysql, you know how repair damages
tables?
this is the message error:
Didn't find any fields in table 'criterios_evaluacion'
Didn't find any fields in table 'mensaje'
Didn't find any fields in table 'registro_sistema'
Didn't find
Hi,
I installed a new RedHat 8.0. When i connect to server, i received this
message:
#mysql -h vtron
ERROR 2013: Lost connection to MySQL server during query
#
What is it ??
-
Before posting, please check:
On 11/11/02 9:10 AM, Inbal Ovadia [EMAIL PROTECTED] wrote:
Hi all
I am working with mysql, in windows, visual c++.
I am trying to run this query from c++ program:
select * into outfile 'table_name.txt' FIELDS TERMINATED BY '\t' ESCAPED BY
'\0' LINES TERMINATED BY '\r' from table_name
CoastResearch,
Saturday, November 09, 2002, 3:41:36 AM, you wrote:
Caadc VER: mysql-3.23.53-win.zip
Caadc Description:
Caadc If I launch MySQL 3.23.38, everything is fine. If I open tables,
Caadc creat db,
Caadc add records whatever, no problem. When I close MySQL my hard
Caadc
Tomás,
Friday, November 08, 2002, 10:36:46 PM, you wrote:
TG I have a server with SCO Unixware 7.1.0 , I like install a Mysql Version
TG that includes Replication with other Mysql servers... Which version
TG could i install for this ???
You need to install something newer than 3.23.15 :-)
mysql,
Monday, November 11, 2002, 2:19:40 PM, you wrote:
masdmdh Greetings to everyone. I have trouble getting mysql shell to use
masdmdh mysql.sock file which is not located in /tmp. I fixed all entries in
masdmdh /etc/my.cnf but mysql shell still complains about /tmp/mysql.sock missing.
hamidmails,
Saturday, November 09, 2002, 12:09:46 AM, you wrote:
hapdn I have a mysql installed ona RedHat 7.3 machine. The problem is that I am
hapdn getting the error 127 many times. Each time I repair the table and after
hapdn some time (1-2 hours) it happens again. Any comments?
hapdn I am
John,
Monday, November 11, 2002, 3:53:25 AM, you wrote:
JM Can anybody venture a guess as to when this will happen?
When it becomes stable.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___
Mike,
Friday, November 08, 2002, 6:29:29 PM, you wrote:
MAS I've got to do a fresh install of mysql on a webserver (a new server, so it
MAS isn't overwriting anything). Does anyone have any info as whether I should
MAS use just MySQL or MySQL-MAX? What is the difference?
If you use v3.23,
Beauford,
Saturday, November 09, 2002, 8:21:26 PM, you wrote:
B MySQL must be the owner of the data dir. Check the owner of MySQL data
B dir.
B It was, but I have since changed it to root and it works fine now. Any
B idea why this would be?
If you run MySQL server under mysql:mysql, it should
CZachary,
Friday, November 08, 2002, 6:51:03 PM, you wrote:
Cawdc I tried this. The error I received is: error: 'Access denied for user:
Cawdc 'root@localhost' (Using password: NO)'
Cawdc Is there another option?
Does user 'root' have a password? If yes, you must use -p option to
specify a
On 11/11/02 9:26 AM, Victoria Meza [EMAIL PROTECTED] wrote:
I've a problem whit some tables in mysql, you know how repair damages
tables?
this is the message error:
Didn't find any fields in table 'criterios_evaluacion'
Didn't find any fields in table 'mensaje'
Didn't find any fields in
Hi, all,
sql, query.
I use mysqlhotcopy to backup innodb tables and I tried to find how to
recovery database point-in-time with the help of binary log.
I had tried mysqlbinlog --user-jqu --password=1234 Host-bin.[0-9]* | mysql
without success.
Anyone of you know how to recovery database
Greetings
I am writing a C app wherein I have to connect to MySQL server whcih is on
SSH connection.
How can I connect to the server using mysql_real_connect ()
Any ideas ? Its urgent
Rgds
insane
-
Before posting, please
Hello all, I would like to change where the /tmp/mysql.sock file gets
created. How to I get it to create the file in
another location?
Thanks.
-
Before posting, please check:
http://www.mysql.com/manual.php (the
I've got two tables, a log table, and a summary table. I want to take
the output of:
SELECT COUNT(id) as logins, COUNT(DISTINCT(user)) as users FROM table
GROUP BY domain;
... and increment another table with the values;
CREATE TABLE log_summary (
domain varchar(50) primary key,
logins
As I mentioned in a previous post, I have been using 3.23 for a very long
time with no problems whatsoever. About 1 month ago I began to have
stability problems, unable to connect, unable to shut downhundreds and
hundreds of myslq processes
At first I thought this was a particular user, so I
Bad form to reply to ones own postbut I should have emphasized my major
symptom:
I cannot stop the server, mysqladmin -pxxx shutdown never returns.
This is in addition to the too many connections and forcing close of
threads errors
- Original Message -
From: Gary Huntress
You can do this in /etc/my.cnf
~K Black
-Original Message-
From: [EMAIL PROTECTED] [mailto:CZachary;wiley.com]
Sent: Monday, November 11, 2002 10:05 AM
To: [EMAIL PROTECTED]
Subject: /tmp/mysql.sock question (newbie)
Hello all, I would like to change where the /tmp/mysql.sock file
Hannes,
my database is working again!
I've a problem with my disk's space
thanks, thanks, thanks
Victoria.
R. Hannes Niedner wrote:
On 11/11/02 9:26 AM, Victoria Meza [EMAIL PROTECTED] wrote:
I've a problem whit some tables in mysql, you know how repair damages
tables?
this is the
Hi-
I'm running MySQL 3.23.51 with PHP 4.2.3 on a Slackware 8.1 system with Dual
Athlon MP 1.2's and 1 GB RAM.
We run a busy site, approximately 3 million page views/day, almost all of
which hit the database. The problem is that we are getting the
error Commands out of sync. You cannot
For some reason I can't send messages to the mysql list - any ideas why? I
don't even get a bounce message!
--Joe
--
Joe Stump
Affordable Computers, Inc.
800-864-2345 x113
-
Before posting, please check:
Insanely Great wrote:
Greetings
I am writing a C app wherein I have to connect to MySQL server whcih is on
SSH connection.
How can I connect to the server using mysql_real_connect ()
Just use SSH to create a local tunnel then connect to localhost ...
--
Michael T. Babcock
C.T.O.,
Hi,
This is a known bug of PHP :
http://bugs.php.net/bug.php?id=19529
A quick fix for this problem is to use mysql_connect instead of
mysql_pconnect.
Regards,
Jocelyn
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, November 11, 2002 7:09 PM
Subject:
its not waiting, its crushing.
-Original Message-
From: gerald_clark [mailto:gerald_clark;suppliersystems.com]
Sent: Monday, November 11, 2002 6:07 AM
To: Eugene Bendersky
Cc: [EMAIL PROTECTED]
Subject: Re: query crushes server
You have no where clause.
The cartesian product you are
Hi all,
I cant get any version of MySQL to work without crashing my
system eventually. Specifically I have mysql-3.23.53 on a win
98SE system and as I use it throughout the day, there are
hesitations caused by ???. Then slowly apps begin to get buggy ie
the help file for MySQL will not
Can you post about 30 seconds worth of
the vmstat 1 command when the system
is busy?
Thanks
~Kelly W. Black
-Original Message-
From: [EMAIL PROTECTED] [mailto:kahnmatt;engin.umich.edu]
Sent: Monday, November 11, 2002 11:09 AM
To: [EMAIL PROTECTED]
Subject: Commands out of sync
Hi-
this query also crushes the sql server with message:
mysqld-nt.exe has genrated errors and will be closed by Windows.
You will need to restart the program.
An error log is being created.
select distinct a.* from gnrlasoc a, tasks b where a.row_key_1 = b.prim_key;
The number of records this
Hi all,
just for your information:
I just committed new stuff for php's mysql extension:
I added some trace/debug functionality, which can be activated via
ini-setting mysql.trace_mode. When it's set to on, you will get
automatically warnings for:
a) table index scan
b) SQL-Errors
c) non
Hi,
I'm trying to write what I am sure should be a simple query, but just can't get it to
work!
If I create a table called foo like this:
create table foo ( id1 int(11) , id2(int 11) );
populate it with data and then try:
SELECT * FROM foo WHERE id2=1 AND id2=2 (for example),
I just get an
Doubly bad to reply twice to your own posts I have more info though.
my startup script has max_connections=1000, and I cannot log in as the
superuser as mentioned here
http://www.mysql.com/doc/en/Too_many_connections.html
- Original Message -
From: Gary Huntress [EMAIL PROTECTED]
Hello All,
How do I determine the best architecture for my MySQL database?
Do I create multiple databases or do I create only one database with
multiple tables? (Any general rules of thumb?)
How do I know if I need to use Keys, Indexes or other features in order to
optimize the database?
In the last episode (Nov 11), James Dyer said:
If I create a table called foo like this:
create table foo ( id1 int(11) , id2(int 11) );
populate it with data and then try:
SELECT * FROM foo WHERE id2=1 AND id2=2 (for example),
I just get an empty set returned. An explain on the query
In your query ID2 cannot be both 1 and 2 (typomundo)
Peter
^_^
-Original Message-
From: James Dyer [mailto:jad;disparate.org]
Sent: Monday, November 11, 2002 3:04 PM
To: [EMAIL PROTECTED]
Subject: Problems with simple(?) query
Hi,
I'm trying to write what I am sure should be a simple
On 11 Nov 2002, at 20:03, James Dyer wrote:
SELECT * FROM foo WHERE id2=1 AND id2=2 (for example),
I just get an empty set returned. An explain on the query gives an 'Impossible WHERE'
message.
Because it's impossible for id2 to be both 1 and 2. What were you
expecting? Did you mean id1
probably need a little more information!
specifics would help.
--- Original Message ---
From: Joe Stump [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: problems querying the list
For some reason I can't send messages to the mysql
list - any ideas why? I
don't even get a bounce message!
--Joe
I have a script that inserts records into a MySQL table, does the processing
and
then deletes those records. The field name that is autonumber is called BID.
When I run the script again, the BID will sometimes start out at 1 and other
times it will start at the last number. What is the correct
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 11 November 2002 17:03, Robin McMillon wrote:
Hi, I noticed when looking at the spec file for the linux rpm for MySQL
4.0.4 that it noted that ssl support had been disabled until it worked
again. Is the problem with ssl support just
the question was:
Do any MySql coders writing subselects in 4.1 know whether EXISTS will
outperform an equivalent query written as a join. =
yes or no ?
greg.
- Original Message -
From: Arthur Fuller [EMAIL PROTECTED]
To: Greg Matthews [EMAIL PROTECTED]; [EMAIL PROTECTED]
The correct behavior is the number starting at the last number used. If you
are using MyISAM tables, you should see this behavior. If you are using the
old style ISAM tables, it will restart at 1 every time.
j- k-
On Monday 11 November 2002 11:41, Jessee Parker wrote:
I have a
Keith C. Ivey wrote:
On 11 Nov 2002, at 20:03, James Dyer wrote:
SELECT * FROM foo WHERE id2=1 AND id2=2 (for example),
I just get an empty set returned. An explain on the query gives an 'Impossible WHERE'
message.
Because it's impossible for id2 to be both 1 and 2. What were you
I am stumped on how to create a statement that will find all
instances of a field (price) and change the .98 to .99. Looking
through the MySQL book of P. Dubois, it seems I need to do pattern
matching but I can't figure out how to combine the statement into an
UPDATE.
Doea anyone have an off
Alex Pilson wrote:
I am stumped on how to create a statement that will find all instances
of a field (price) and change the .98 to .99. Looking through the
MySQL book of P. Dubois, it seems I need to do pattern matching but I
can't figure out how to combine the statement into an UPDATE.
Doea
I am also a newbie so don't misunderstand my question. Is there any
performance or functionality reason to change mysql.sock location?
Adolfo
On Mon, 2002-11-11 at 14:37, Black, Kelly W [PCS] wrote:
You can do this in /etc/my.cnf
~K Black
-Original Message-
At 8:23 AM +1100 11/12/02, Daniel Kasak wrote:
Alex Pilson wrote:
I am stumped on how to create a statement that will find all
instances of a field (price) and change the .98 to .99. Looking
through the MySQL book of P. Dubois, it seems I need to do pattern
matching but I can't figure out
None that I am aware of.
Some systems have differed locations. However, some
programs expect the file mysql.sock to be in the /tmp
dir.
I don't know if it's good form or style, but on systems
where the sock is located in some out of the way place I
just link it with
ln -s /path/to/mysql.sock
I noticed that Mysql starts up under XFS, Im not even sure what XFS is? Im
running RH 7.3 and mysql 3.23.40. I performed the install based on RPM
packages not from the Packaged OS install. Jsut curious why this is
happening.
Also I noticed that my safe_mysqld daemon is running under root:
There is a cleanup script run via cron that removes files from /tmp. When
I try to stop the db, I get an error message that the socket cannot be
found.
|-+
| | Adolfo Bello |
| | adolfobello@bisa|
| |
the EXISTS logic is ugly in as sql statement.
does that count? seems like ugly should count.
hey, can i hijack my message back?...this thread is about the performance of
subselects, not stored procedures. go write your own message :-)...
sothe original question is if someone would
Jing,
- Original Message -
From: Jannie Qu [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Monday, November 11, 2002 8:03 PM
Subject: mysqlhotcopy point-in-time recovery
Hi, all,
sql, query.
I use mysqlhotcopy to backup innodb tables and I tried to find how to
recovery
XFS is X server Font Server, and is unrelated.
~Kelly W. Black
-Original Message-
From: David Kramer [mailto:DKramer;reflect.com]
Sent: Monday, November 11, 2002 1:51 PM
To: [EMAIL PROTECTED]
Subject: Mysql starts under XFS on boot up???
I noticed that Mysql starts up under XFS, Im not
Heikki Tuuri wrote:
you cannot use mysqlhotcopy to back up InnoDB type tables. Only the .frm
files are in the database directory, while the data is in ibdata files.
mysqlhotcopy does not copy ibdata files or ib_logfiles, and if it would do
that, the copies could be corrupt because of writes the
It would be advisable to modify the script so that
it only looks for files on a targeted basis. Many files in
/tmp are important, for example orbit, cron, etc. In my opinion
I would only remove all file under the /tmp if I was experiencing
some sort lock file problem or something.
Michael I have a nice perl program I wrote that I use to dump
from MySql to a tab delimited ASCII file. I would
pass it along if you think it would help...
~Kelly W. Black
-Original Message-
From: Michael T. Babcock [mailto:mbabcock;fibrespeed.net]
Sent: Monday, November 11, 2002 2:38
After upgrading our database to 3.23.52 on WinNT
Server, we are encountering the above error. Error
msg:
MySQLAdmin Entry point not found. The procedure entry
point created tool help 32 snap shot could not be
located in the dynamic link library kernel32.dll
Tried uninstalling and re-install, but
I have a need to retrieve a subset of records as follows:
Database structure:
Field0IntegerAutonumber
Field1IntegerUnique
Field2Integernot unique
where the starting record would be selected by Field1 (an indexed field of
unique values).
The ending record
Can you tell me why during bootup I see XFS starting Mysql Daemon then? Any
thoughts on the safe_mysqld question?
Thanks much,
DK
-Original Message-
From: Black, Kelly W [PCS] [mailto:kblack05;sprintspectrum.com]
Sent: Monday, November 11, 2002 2:36 PM
To: 'David Kramer'; [EMAIL
Hello All,
I want to copy a table from a webserver that has MySQL database server
located on it, then, ftp to my local machine to insert into my local
database.
any ideas on how to do this?
my goal is to create an Excel spreadsheet from the table for distribution. I
have created the spreadsheet
At 04:47 PM 11/11/2002 +0800, Thomas Seifert wrote:
Are you using MySQL-3.23.x?
AFAIK it doesn't use a key for ORDER BY (MySQL-4.x does).
Maybe thats the cause?
Hi,
Yes. Im using 3.23.52(nt). I just upgraded it from 3.23.27.
You mean, if I have ORDER BY as part of the query statement,
MySQL
Mysqlfront has this nice feature where u can open 2 database and copy it
From 1 to the other
-
Chris Kay (Systems Development)
Techex Communications
Website: www.techex.com.au Email: [EMAIL PROTECTED]
Telephone: 1300 88 111 2 - Fax:
-Original Message-
From: William Martell [mailto:willmartell;yahoo.com]
Sent: 11 November 2002 20:02
To: MySQL Main List
Subject: SCHEMA, ARCHITECTURE ???
Hello All,
How do I determine the best architecture for my MySQL database?
Years of painful but fulfilling experience :)
Seriously
phpMyAdmin has an 'export to csv or Excel' function. If you are running php
this will produce a CSV file you can import directly into Excel
http://www.phpwizard.net/projects/phpMyAdmin/
hth
Peter
---
Excellence in internet and open source software
Hi,
I'm trying to write what I am sure should be a simple query, but just can't get it
to
work!
If I create a table called foo like this:
create table foo ( id1 int(11) , id2(int 11) );
populate it with data and then try:
SELECT * FROM foo WHERE id2=1 AND id2=2 (for example),
I
You can use mysqldump to export the data from your webserver to a file,
ftp the file, and import into your local database.
There are also some tools that might help -- urSQL
(http://www.urbanresearch.com/ursql), for example, can export query
results directly to Excel. This means you could
Hi,
How stable is the new MySQL 4.x?
I've read some really nice and powerful stuffs with MySQL 4.
x and surely like to use them.
Is this still in the 'use at your own risk' stage?
or is it stable enough for use already?
regards,
Jaime
1 - 100 of 112 matches
Mail list logo
