Hi all.
Anybody knows a function or some way to convert a string to a integer? I've
looked in the manual and I haven't seen anything.
I need it to order a query by a column which contains numbers but the type
of the column is varchar. I want to convert the values to integer before
ordering the
On Wed, 29 Aug 2001, Sasha Pachev wrote:
On Wednesday 29 August 2001 15:14, Martin MOKREJ? wrote:
Description:
I have on Linux running 3.23.41 the following problem:
$ /usr/local/mysql/bin/myisampack -v -v -f --tmpdir=/tmp
/data/mysql/Aactinomycetemcomitans/blimps.MYI
Compressing
Matthew Walker ([EMAIL PROTECTED]) writes:
What's the best way of doing a hot backup on a database? Our server is
set up in such a way that it's not a simple matter to shut down
apache/mysql and do the backup then. So, is it safe to just copy the
mysql directories, or is there some
Hello...
I got a big problem in MYODBC. I am using myodbc-2.50.31-win95. When I use any MySQL
Administrator to query the database that I had created for example:- SELECT * FROM
dbname, they come out error like:=
Your command could not be completed. MySQL returned the following error:
Got
Eugene wrote:
Hello...
I got a big problem in MYODBC. I am using myodbc-2.50.31-win95. When I use any MySQL
Administrator to query the database that I had created for example:- SELECT * FROM
dbname, they come out error like:=
Your command could not be completed. MySQL returned the
A quick question: How come the mailing list software
doesn't add a reply-to header? Is this intentional to
keep replies off the mysql list, and if so why?
I'll try to remember to reply to the list rather than
directly to the people who ask the questions, as replying
in private does little to stop
Dear List,
I have a (standard table handler ) table defined as follows :
CREATE TABLE fact0 ( d0keyINTEGER,
d1keyINTEGER,
d2keyINTEGER,
val INTEGER,
filler
On 29-Aug-01, Paul DuBois wrote:
Create a single PRIMARY KEY that consists of the two columns chapter and
section, and make section an AUTO_INCREMENT column. When you insert
rows, set chapter to the proper chapter number and section to NULL.
This will cause MySQL to generate independent
Hi all,
On the subject of licensing: I've seen the discussions around this topic
and would like to approach it from another angle.
Until recently I were a student and if it weren't for the free
distribution of mySQL I would have had problems.
On the other hand I will be the
hy,
i want to set up a apache web server with mysql database connection
for different users which should have their databases in their
homedirectories.
for ex: user x use .jsp to write data from forms in a mysql database -
for ex: homedir: /home/x/htdocs
but the
Hi!
Neil == Neil Zanella [EMAIL PROTECTED] writes:
Neil I would like to comment on the following mysql.com question
Neil We have made our product available at zero price under the GNU
Neil General Public Licence (GPL), and we also sell it under a commercial
Neil licence to those who do
Mark kirkwood ([EMAIL PROTECTED]) writes:
CREATE UNIQUE INDEX fact0_pk ON fact0(d0key,d1key,d2key) ;
Whichunfortunatly takes about 20m ( which I think is a bit slow )
Have you tried building the table structure with the index already in place,
then importing the data?
--
Ed Carp, N7EKG -
daniel james ([EMAIL PROTECTED]) writes:
I need to generate a tab-delimited text dump of table
data ONLY and have it output to a text file. I don't
want any table info, delimiters, etc. I need this to
copy/paste into a excel spreadsheet. What's the
syntax?
I'm stuck here:
%
Mark kirkwood wrote:
Dear List,
I have a (standard table handler ) table defined as follows :
CREATE TABLE fact0 ( d0keyINTEGER,
d1keyINTEGER,
d2keyINTEGER,
val INTEGER,
Van writes:
I'm also advertising for MySQL all over my site with the original logo.
Do I need to remove it? I'd rather not, since it's just a link to point people
to a valuable resource. Is my site violating the terms of the trademark?
Van
--
Hi!
On Aug 30, Mark kirkwood wrote:
Dear List,
I then LOAD 300 rows into it ( about 350Mb)
This takes about 2m30s on my ( fairly old ) hardware ( I think this is quite
fast ).
CREATE UNIQUE INDEX fact0_pk ON fact0(d0key,d1key,d2key) ;
Which unfortunatly takes about 20m ( which
Philip Daggett writes:
Is anybody else not able to get onto mysql.com???
There were some temporary problems with firewall. It should be OK by now.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__
There is an issue that confuse me a bit, altough it is not important
for an operational point of view:
From the manual:
The master server keeps a binary log of updates and an index file to
binary logs to keep track of log rotation. The slave, upon connecting,
informs the master where it left
On Thu, Aug 30, 2001 at 12:44:46PM +0200, Claudio Cicali wrote:
[snip]
Here, seems that are the slaves that pop data from master.
So where is the truth ? Is the master that pushes or the slaves the pops ?
Or it is a combination of the two ?
In normal operation, the master pushes to the slave.
On Thu, Aug 30, 2001 at 12:44:46PM +0200, Claudio Cicali wrote:
Here, seems that are the slaves that pop data from master. So where
is the truth ? Is the master that pushes or the slaves the pops ?
Or it is a combination of the two ?
It's a pull mechanism... The slave simply contacts the
Ken Menzel writes:
Wasn't there something awhile back that was supposed to prevent
running the daemon as root? When the daemon was started through
safe_mysqld it would tell you to select a user as root you had to
use --user=root, this seems to be gone!
from the manual:
F.2.26 Changes in
Sinisa Milivojevic wrote:
Van writes:
I'm also advertising for MySQL all over my site with the original logo.
Do I need to remove it? I'd rather not, since it's just a link to point people
to a valuable resource. Is my site violating the terms of the trademark?
Van
--
Hi!
Sasha == Sasha Pachev [EMAIL PROTECTED] writes:
Sasha On Wednesday 29 August 2001 15:14, Martin MOKREJ? wrote:
Description:
I have on Linux running 3.23.41 the following problem:
$ /usr/local/mysql/bin/myisampack -v -v -f --tmpdir=/tmp
Sasha
Hi!
On Aug 30, Alexander wrote:
Hello, mysql team!
Any chance (in the near future) to get FullText indexing working with innodb
table handler?
Alexander
I doubt it will be done it the near future
(unless a customer would like to pay for the feature, of course).
Regards,
Sergei
--
Joyce Vermeulen writes:
Hi all,
On the subject of licensing: I've seen the discussions around this topic
and would like to approach it from another angle.
Until recently I were a student and if it weren't for the free
distribution of mySQL I would have had problems.
On the
hi,
i've got a table collecting info from html forms. problem is, certain
wiseguys always make multiple entries. could someone clue me in to how
i can select the Last entry where there is a duplicate for the User
(type text, these are email addresses), and automatically delete any
previous
Tom Churm ([EMAIL PROTECTED]) writes:
hi,
i've got a table collecting info from html forms. problem is, certain
wiseguys always make multiple entries. could someone clue me in to how
i can select the Last entry where there is a duplicate for the User
(type text, these are email
Is there any way to remove the treatment of words three letters and under
being treated as a stopword when performing a query of a full text index on
a table. If it is a recompile of MySQL is there a good resource on how to do
this... I'm a newbie to the world of compiling MySQL
thanks
Chris
On Thursday 30 August 2001 15:28, Andre Konopka wrote:
Hi,
I have, three tables (one,two, three) with the rows id/value. id is the
key for all the tables.
with
select value from one where id=xx;
select value from two where id=xx;
select value from three where id=xx;
I can select
I am using MySQLGUI 1.7.5-1 on Windows 2000. When I save a query result to
a file it seems to save it as a Hex output. Is this what is supposed to
happen? Can this be used to backup a database?
Thanks in advance.
Jeff
-
Van writes:
Sinisa:
I've never had a doubt about the integrity of the MySQL AB approach to such
issues, nor this one.
Thank you for confirming my assumption that MySQL AB is maintaining a
responsible approach in addressing this issue amid shark-infested waters.
As always, I offer my
And then there's the sad situation I'm in.
I'm using MySQL to do a site for the U.S. Army, but I am not allowed to
put the logo up as it would be considered an endorsement of a commercial
product, which is a major no-no.
And I'd like so much to do it. I'm thinking of a way, but I'll have to
When doing a select with an order by clause, how do you make mysql list the items in
correct numberical order. Normally, when I run the command mysql will list 1000
before 200 because of the initial digit. How do I correct this?
Thanks,
Phil
Get 250 color business cards for FREE!
Jeff Isom writes:
I am using MySQLGUI 1.7.5-1 on Windows 2000. When I save a query result to
a file it seems to save it as a Hex output. Is this what is supposed to
happen? Can this be used to backup a database?
Thanks in advance.
Jeff
It will save query results in a file in
Hi Van,
If you don't give drop privileges how can the user drop tables? Is
there a way to give just drop table privileges, because 'drop' will
let you drop tables and the database? If so I missed it and would be
very happy to know how to do this, as I would feel a little better
about that as
If the column is an int then it will order it numerically. Other wise you have to
cast it. And dont for get the difference between ORDER BY x ASC and ORDER BY x DESC.
--Bill
DROP TABLE IF EXISTS test;
CREATE TABLE test ( i int, c char(20));
INSERT INTO test VALUES
( 1, '5' ),
( 2, '4' ),
(
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
Is anyone else getting a strange flag associated with Jeremy's
email, or is it just me? Every one of his posts comes in flagged
in Outlook,
Mike writes:
I'll probably get brow beat for this but hey the coffee has not kicked in
yetg
How to I allow connections from remote clients?
I lost my note but I thought it was GRANT ALL PRIVILEGES ON *.* TO
[EMAIL PROTECTED];
The rights are high but this is the example I seen
Is there anything I need to be doing maintenance wise on a mysql database?
I have inherited one that was installed as follows
As far as database stuff that we do, we basically
installed the server, set up databases and tables, and use them.
Indices have been created on many of the tables to
I am fairly new to MySQL and I am unfamiliar with the term escaped form.
Can anyone point me to documentation that explains what that is and how it
can be used.
Also, I am trying to perform a backup remotely. My understanding is that
the mysqldump and mysqlhotcopy commands can only be used on
For a float column, is there any way to change the decimal precision for
scientific notation returned from a select statement? For instance, a
select statement currently returns 1.19573e+06 although the actual value is
1.195731e+06.
Also, is there any way to prevent MySQL from using scientific
Hi Jay,
I'd definitely suspect Outlook (or LOOKOUT! as a few of my network support buddies
call it) as the source of the problem, rather than anything to do with Jeremy's emails.
I'm having no problems here -- but then again, I don't use any Microsoft products. :
Good luck,
/Rob
As Rob
Has anyone tested dropping a master database?
I have dropped the master database that was replicating just to see how it
would affect the slave. The slave kept its data.
What would the proper proceedure be in this case?
I wouldnt be able to snapshot the slave and then port the snapshot back
April Sims ([EMAIL PROTECTED]) writes:
Is there anything I need to be doing maintenance wise on a mysql database?
I have inherited one that was installed as follows
As far as database stuff that we do, we basically
installed the server, set up databases and tables, and use them.
Benjamin Krajmalnik wrote:
I have a deployment of mySQL 3.23.26-beta running on FreeBSD 4.2-RELEASE.
I am running 3 databases off of a single mySQL server.
In one particular database I am unable to insert records - the process just
hangs.
My intuition would tell me that maybe something is
OK. I tracked the problem to being out of disk space in the var partition.
The default source installation plaved the data in the /var/db directory.
The var partition is not that large by default, and therefore I am now out
of space.
I would like to move the data to a /usr/local/mysql/data
perror 28
Error code 28: No space left on device
Benjamin Krajmalnik wrote:
I have a deployment of mySQL 3.23.26-beta running on FreeBSD 4.2-RELEASE.
I am running 3 databases off of a single mySQL server.
In one particular database I am unable to insert records - the process just
hangs.
Hi all,
I hate to bring this up in the group, but I haven't found an answer on the site. I've
got mysql-3.23.30-gamma-unknown-freebsdelf4.2-i386.tar.gz installed, but I need to
recompile a little differently. My problem is that I can't find this version in source.
Can anybody tell me where I
i think this is jeremy's not-so-subtle way of bashing your choice of email
client.
check this link:
http://www.rodos.net/outlook/#messageflag
-ravi.
Yeah, yeah - I got it. Only problem is that I DON'T have a choice (company
policy et al)...
\:^{
Jay Fesco
Magical Mystery
now i changed the root password just fine
but now i have to enter it every time i run mysqladmin
even mysqladmin version reqires a -p
tell me there's a simpler way
-
Before posting, please check:
now i changed the root password just fine
but now i have to enter it every time i run mysqladmin
even mysqladmin version reqires a -p
tell me there's a simpler way
http://www.mysql.com/doc/C/o/Connecting.html
* You can specify connection parameters in the [client] section of the
Hi,
I'm running mysql MAX 3.23.41 on LinuxPPC, everything was installed from
an RPM.
My problem is whenever I try to call mysql_connect (), from a php3
script, I got the error function not found or misconfigured
The script is a simple form, that passes the data to be added to an
empty
What about a number field w/zero fill?
On Thu, 30 Aug 2001, Adams, Bill TQO wrote:
Date: Thu, 30 Aug 2001 08:48:11 -0700
From: Adams, Bill TQO [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: order by number
If the column is an int then it will order it
I use MySQL a number of different ways: the C API, from PHP, from the
command line, and often from shell scripts run by other users or from
crontab entries. The latter two uses present a couple of problems that
could be fixed easily through some minor changes to the code for the mysql
program
I have been playing around with merge tables. You MUST have the columns and
indexes in the same order.
Eg. Do
SHOW INDEX FROM real_table;
SHOW INDEX FROM merge_table;
If the Column_name order is different you will get either no records or a
bunch of null records when you select on a column
Hi all,
I am in the process of creating a Virtual Server - and pretty much all
aspects have been completed to my liking. This includes web / mail / ftp and
ssh.
The next hurdle is virtualizing MySQL, and I would like to do this by
sharing the same MySQL server across multiple chrooted clients.
Hello everyone!!
I am installing the latest rpm for mysql 3-23.41 on a RedHat 7.1 box and
want the datadir to be /data/mysql/data. In my /etc/my.cnf file I
have the directive:
[mysqld]
datadir=/data/mysql/data
The installation completes but the daemon won't start. I do the
mysql_install_db
Webmaster Odell wrote:
Hi
I am trying to write a query that pulls all the items from a database except
two
here is what I am using:
$query = 'SELECT DISTINCT Type FROM Products WHERE Type != System,
Upgrade';
This populates the drop down box with all including the System and
Well, I don't know if you can specify what order to put these in,
but mine just happen to not be in the same order:
mysql show index from all_records;
++-+--+-+---+---
--+--++
| Non_unique | Key_name|
Monty helped me with this, and this is my
understanding.
Regardless of what order you generate the keys,
MySQL puts the primary key first, then the UNIQUE
keys, then the others.
When you add a new UNIQUE key, it puts it after
the primary key but before the other existing
UNIQUE keys.
In your
I have tried to enable slow query logging for a couple days now, with no
success.
I have tried adding the line to the my.cnf file as well as stoppign the
service then starting it with the command line version. Both ways, the
server refuses to restart. I have checked the syntax over and over
Evening Gurus,
I have a small problem that I've beaten to death the past 2 days. I am
trying to get the value of a row, and update another table accordingly.
The data within the row is either a 1 or 0. My issue is in trying to
increment a count for both 1's and 0's.
In other words, I want
Unfortunately, when you moved the directories, you forgot to make mysql
the owner
of the new directory.
chown -R mysql /data/mysql
Philip Daggett wrote:
Hello everyone!!
I am installing the latest rpm for mysql 3-23.41 on a RedHat 7.1 box and
want the datadir to be /data/mysql/data. In
SELECT SUM( bool_was_connected=1 ) AS was_connected,
SUM( bool_was_connected=0 ) AS was_not_connected, etc...
b.
[EMAIL PROTECTED] wrote:
Evening Gurus,
I have a small problem that I've beaten to death the past 2 days. I am
trying to get the value of a row, and update another table
Two problems.
The clients don't have access to the databases, the server does.
Chrooted clients will not be able to read and write the named pipe
unless it is in their new root structure.
Mustafa Hashmi wrote:
Hi all,
I am in the process of creating a Virtual Server - and pretty much all
Thankyou kindly Bill. Just to verify, SUM adds up values. My data
is only 1 or 0. I used SUM as an example, the below query you recommend
will count all 'rows' which are 0, thus returning a number which
represents how many 0's were found?
Thankyou for the fast reply,
Calvin
On Thu, 30 Aug 2001,
Calvin,
Maybe I'm just confused (fairly likely), but it appears that you are
confusing 'null' with zero. If you actually want to count all values
including nulls, COUNT(*) will do it. If you want to count NON nulls,
COUNT(a_field_name) does it. SUM(a_field_name) returns the sum of all
Hi People,
I'm trying to execute this Simple query:
SET SQL_SAFE_MODE=0;
The server doesn't like it; However, SET any other option will work fine
except this one.
I'm still using mysqld v3.23.36 . If someone can try it on the latest version.
Thanks.
Randy,
Yes.
A feature of MySQL is that it returns 1 for true and 0 for false. When you
select ... you can put logic tests and sum up the number of true values. In the
case of bool_was_connected=0 will have a value of 1 when it is true and then
you sum up the results.
You could also do something
Evening Jay,
I'm still abit new to MySQL. Spending the last 6 months I have worked
with it more on my CGI development, than good SQL query practicing. My
technical jargon is lacking. In laymens terms ( I know no other at this
point in time ) I have a row that has '1' or '0' in it. I'm trying to
Gerhard,
Thank you for your response.
Emphasizing that I am new to this, could you describe in a bit more detail
how I could put this in the new root structure? (client's chrooted
structure)
If this is too extensive to properly explain, is there some documentation
available which might help?
Jeff Isom writes:
I am fairly new to MySQL and I am unfamiliar with the term escaped form.
Can anyone point me to documentation that explains what that is and how it
can be used.
Also, I am trying to perform a backup remotely. My understanding is that
the mysqldump and mysqlhotcopy
Thanks Gerald!!
That did the trick and everything seems to be running perfectly!
At 01:59 PM 8/30/2001 -0500, Gerald Clark wrote:
Unfortunately, when you moved the directories, you forgot to make mysql
the owner
of the new directory.
chown -R mysql /data/mysql
Philip Daggett wrote:
Hello
I'm a newbie to Unix and MySQL. I have a few
questions.
With 'uname -a' I got the following message
SunOS [EMAIL PROTECTED] 5.7 Generic_106541-06 sun4u sparc
SUNW,Ultra-1
Can i install mysql-3.23.41-sun-solaris2.8-sparc in
it.
Theres no installation instructions for Unix/Solaris
machines in
Anyone,
I apologize for broadcasting to the group, but I've been trying to set-up a
maintenance contract
and licenses for about a month and no-one seems to be listening to the sales and
licensing
e-mail drops for MySQL AB Company.
I assume those that are 'in the know' can direct me to some
Hi,
I have a mysql table:
+---+--+--+-+
| Field | Type | Null | Key |
+---+--+--+-+
| sessionid | int(10) unsigned | | PRI |
| username | char(20) | | MUL |
| start | int(10) unsigned | |
On Thu, Aug 30, 2001 at 10:22:02AM -0600, Jeff Isom wrote:
I am fairly new to MySQL and I am unfamiliar with the term escaped form.
This a Unix-ism. For instance:
this line
'this line'
this\ line
The last two are functionally equivalent. The last one has an
'escaped' space embedded
You mean leading zeros? MySQL will translate as much of a string as it can into a
number when it is cast:
mysql select ('a'+0);
+-+
| ('a'+0) |
+-+
| 0 |
+-+
1 row in set (0.00 sec)
mysql select ('00010'+0);
+-+
| ('00010'+0) |
+-+
|
i think the server does not run with privileges
to write to /root
regards
Sven Huster
Senior IT Systems Engineer
Sven Huster
Senior IT Systems Engineer
-Original Message-
From: Ryan Shrout [mailto:[EMAIL PROTECTED]]
Sent: 30 August, 2001 20:51
To: [EMAIL PROTECTED]
Subject:
The short answer is that you can't, if you're using a named pipe
(/tmp/mysql.sock, or some such). That would require every user having their
own installation of MySQL, which may be what you want.
Why not have the users connect via TCP/IP, and just set permissions
correctly? They would be
Hi,
Is there a number sequence generator/function in
MySQL such that if I were to execute:
UPDATE mytable SET id = thisfunction;
it will update the table mytable and set the column
id to a numbered sequence 1,2,3,4,5,6,7,8,9.?
currently, i have a table with 2.5 million records and
i want to
On Thu, 30 Aug 2001, Michael Widenius wrote:
Hi,
yes this patch *fixes* all of my problems, except one table which is/was
probably too big? I haven't found any options that would make myisamchk to
ask for less memory.
/usr/local/mysql/bin/myisamchk: Out of memory (Needed 4294922813 bytes)
Hi Ryan,
Did you look in you hostname.err file for the error at the end of
the file? Are you running the mysql daemon as root? Could it be the
user you are running mysqld as does not have permission to write to
/root? The .err file by default is in the directory with your other
logs (on my
Thanks for the response Joshua,
That is an option - however not one I would be very comfortable with. I have
a similar setup for virtual hosts generally - wanted something more flexible
and powerful for a virtual server implementation without taxing the actual
server too much.
For example, the
On Thu, Aug 30, 2001 at 02:50:47PM -0400, Ryan Shrout wrote:
I have tried to enable slow query logging for a couple days now, with no
success.
I have tried adding the line to the my.cnf file as well as stoppign the
service then starting it with the command line version. Both ways, the
On Thu, Aug 30, 2001 at 11:00:14AM -0600, Benjamin Krajmalnik wrote:
OK. I tracked the problem to being out of disk space in the var partition.
The default source installation plaved the data in the /var/db directory.
The var partition is not that large by default, and therefore I am now out
That seems like rather a bad idea to me.
Would that not leave anything else that references the sessions
looking at the wrong session?
Jaime Teng wrote:
Hi,
I have a mysql table:
+---+--+--+-+
| Field | Type | Null | Key |
When using the Java call to executeUpdate() for an update statement, the return value
should be the number of rows affected.
mysql is returning a value of 0 on a successful update when it should return 1. The
database is being updated properly, only the response is wrong.
Add an auto_increment column of an appropriate int size.
Jaime Teng wrote:
Hi,
Is there a number sequence generator/function in
MySQL such that if I were to execute:
UPDATE mytable SET id = thisfunction;
it will update the table mytable and set the column
id to a numbered sequence
the master has the correct permission. however the slave reports this
error.
Slave: Failed reading log event, reconnecting to retry, log
'mysql-bin.log' position 30
Slave: reconnected to master 'mysql@mydb203:3306',replication resumed in
log 'mysql-bin.log' at position 30
Slave: received 0
Hi,
Every time we have run into this one, is
because somthing updating, was out of sync.
Best Regards
On Thu, 30 Aug 2001, Dave Berk wrote:
the master has the correct permission. however the slave reports this
error.
Slave: Failed reading log event, reconnecting to retry, log
I'm new to MySQL and I'm sure this has been covered, but I can't find it so
I'll ask here. What is the best way to backup a MySQL database that is
hosted on a remote server.
Our web site is hosted by a hosting company and they configured MySQL. I
want to backup the database periodically. I've
database,sql,query,table
So sprach =BBJaime Teng=AB am 2001-08-31 um 03:53:47 +0800 :
Is there a number sequence generator/function in
you can set the INT types to auto_increment, which will do just that
when you insert rows.
Alexander Skwar
--
How to quote: http://learn.to/quote (german)
Question,
Could some one tell me why our mysqld daemon appears to be incrementing on time.
For instance I get the following output when I use ps -elf. the 470 you see below
was 460
30 secs ago. Is there a memory leak or ?we are using MySql 3.23.30
What can I do to resolve
Greetings,
We're having some problems with our one way replication stalling.
There are no errors in the errors logs, and the status reports seem to
indicate things are still running, however, changes to the master are
not being received by our slaves.
We're running a farm of 4 slave mysql
Can I remove the rigth for one user to see one specific table in database?
for exemple:
user: bob
table: tab_secret
database: Customer_service
Bob can see any table in DB Customer_service except the table tab_secret.
--=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=--
François Boucher
Curtis ...
Do you have the database/table created on the MySQL server? If so, you can
use MSAccess (need ODBC connections to both servers) to Link Tables and move
the data acros that way.
We did it that way until our programmers wrote a C++ app that replicates
server-to-server.
Gerald Jensen
At 12:30 PM -0700 8/30/01, Sujay Daniel wrote:
I'm a newbie to Unix and MySQL. I have a few
questions.
With 'uname -a' I got the following message
SunOS [EMAIL PROTECTED] 5.7 Generic_106541-06 sun4u sparc
SUNW,Ultra-1
Can i install mysql-3.23.41-sun-solaris2.8-sparc in
it.
Theres no
On Thursday 30 August 2001 04:13 am, Carl Troein wrote:
A quick question: How come the mailing list software
doesn't add a reply-to header? Is this intentional to
keep replies off the mysql list, and if so why?
Generally, I hit reply-All, and then just edit the To Line:-)
I'll try to
excuse me if this is too newbie...but I need to perform a duplicate
delete on my database using the e-mail address as the key. I understnad
how to use COUNT and DISTINCT together...
select count(DISTINCT email) FROM table;
but I can't seem to find any info on how to perform the actual
1 - 100 of 131 matches
Mail list logo
