I've been strugling with a query for some time now and I can't get the
desired answer from mysql.
The desired answer: a date (bv. 2001-02-08)
What is the input: a week number
What date do I need: The date of the monday where week = x
the idea was: select date(week(10),1);
But offcourse
Antione,
What's your definition of a week number ? A week number in the range
1..52 is not in itself enough to calculate a precise date from..
regards,
P
On Thu, 8
Mar 2001, Adams, Antoine A SSI-ISES-56 wrote:
I've been strugling with a query for some time now and I can't get the
desired
Hi,
I have a table that needs to be indexed heavily.
Even though I specify the `pack_keys=1` table option
and all the keys are combinations of unsigned integers of various sizes,
I don't really get any key packing - read the full story below.
Is there any other magic I should use to get my keys
On Wed, 7 Mar 2001, Steve Sizemore wrote:
I'm trying to install the latest stable mysql on Solaris 2.6. [...]
ld.so.1: ../sql/mysqld: fatal: libz.so: open failed: No such file or
directory [...] /opt/local/lib/libz.so
Apparently /opt/local/lib isn't in your LD_LIBRARY_PATH. Check it out
via
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe,
Description:
netinet/ip.h and netinet/tcp.h are not included during compilation.
This causes extremely slow remote access if the last data packet is smaller
than MTU of underlying network layer, because TCP_NODELAY socket option
is not set.
How-To-Repeat:
1. Get 3.23.33 source code
Description:
netinet/ip.h and netinet/tcp.h are not included during compilation.
This causes very slow remote access if the last data packet is smaller
than MTU of underlying network layer, because TCP_NODELAY socket option
is not set.
How-To-Repeat:
1. Get 3.23.33 source code from mysql.com
Hi,
The perror command gives MySQL error messages.
[jenik@zarq jenik]$ perror 2
Error code 2: No such file or directory
I'd guess you should specify the full path to the output file,
and make sure the location is world-writable.
/tmp should work on Unix systems.
Jan
Jennifer wrote:
Greetings!
I am trying to compile MySQL in RedHat 6.0. what I did are:
tar -xvzf mysql-3.23.33.tar.gz
cd mysql-3.23.33
./configure --prefix=/usr/local/mysql
then it startx to work and inerrupt and says
testing gcc working: no
configure: error: installation or configure problem: c compiler can
Hello
I like to propose the attribute create_tmp_priv as little alternative to
create_priv.
The reason is that due to the lack of sub-selects temporary tables which
can be created with the same name at the same time by many connections are
often very usefull.
But I won't give every user the
I would like to modify the following statement
select Item from $table
in such a way that it checks what kinds different items are in the database. Hence,
only those values should be returned, which are not identical to each other. Example:
Apple (5 occurances), Apple-Pie (3 occurances),
select distinct item from $table
It sounds like you might want to read up a little on normalization, however.
I would like to modify the following statement
select Item from $table
in such a way that it checks what kinds different items are in the
database. Hence, only those values should
Bonjour,
je vous
envoie en pièce jointe et zippé avec Winzip8.0,en format StarOffice5.2
.sdw, une description la plus précise possible du problème d'installation de
MySQL que je rencontre actuellement.Si pour une raison ou une autre, l'envoi
de ce mail pose problème, pouvez-vous me le
I have asked this before and was told that it is not going to happen soon. That was a
LONG time ago. Maybe in 4.0?
The only alternative now is to create a scratch database with enough rights and create
your temp tables there.
--
Richard Ellerbrock
[EMAIL PROTECTED]
Christian Hammers [EMAIL
Hello all,
I'm not quite sure how to work this out. I have two columns in a table that
hold a week number (i.e. 1, 9, 52, etc.) and a year value (i.e. 2000, 2001,
etc.). I need to get a date value for the first day of each week and it's
associated year. For example, given week 8 in the year
Hello,
I'm looking for an OLEDB-driver for mySQL. I think it's a very important
technology because a lot of software uses now OLEDB instead of ODBC.
Does someone know of such a project?
Greetings from Switzerland
Bernie
--
Ingenieur- und Vermessungsbro
KAUTER + HUTZLI, Egliweg 6/8, CH - 2560
ODBC API documentation is, of course, available from Microsoft and is
included with Visual Studio or available from their website (I'm not sure of
the exact URL). All of the MyODBC source is available from your closest
MySQL Mirror site. ODBC and JDBC are not the same. Try Sun for JDBC
Where do I get the php libraries as one file?
James
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
Description:
I have just installed mysql 3.23.33 on my system and was
testing the mysqldump command as per the manual. I have not
created any new databases. When I run mysqldump with the --tab
option, the *.txt files created are world read/writable.
This is
Wow, did I ever screw up.
I meant to drop an unused development database and ended up dropping a used
production database.
Can I recover it?
If so, how?
The server runs Linux.
Signed,
Screwed
_
Get your FREE download of MSN
Wow, did I ever screw up.
I meant to drop an unused development database and ended up dropping a used
production database.
Can I recover it?
If so, how?
The server runs Linux.
Signed,
Screwed
_
Get your FREE download of MSN
Did you back up the database?
If not... Ehmmm... Why did they even give you drop db access...
- Original Message -
From: "lounge fly" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 08, 2001 1:05 PM
Subject: Dropped wrong DB. Can I recover?
Wow, did I ever screw up.
Hi
I am using python to interact with mysql and have a small problem ahich I am
hoping someone can help me with:
Basically I am trying to input values into a table which I have created, the
value is www.breakbeat.co.uk. The way I have done this is to assign the url
to a variable: url1. and
lounge fly wrote:
Wow, did I ever screw up.
I meant to drop an unused development database and ended up dropping a used
production database.
Can I recover it?
If so, how?
Go find a backup ;-0
If you've not got any then you can, but it may not work, restore /
undelete files - their
Hui wrote:
Hi,
We have apache 1.3.19, PHP4.0.2 and mysql installed in
our redhat linux 6.2 system. For some reasons, we got
error message " denied for user: nobody@localhost
(Password :YES)". Database in my local machine.
Code: mysql_pconnect("$localhost","$username",
"$password") or
Justin wrote:
I have a puzzle..
Frequently, about, weekly? our data server gets into a state
where
select distinct(keyfield) from table
hangs in the 'sending data' phase, or the 'sorting result' phase,
the client is left waiting for the result, no rows are returned,
no errors are in
Hi,
I am trying to create a bi-directional view to a MYSQL database using an
existing MS SQL Server database. I have MySQL set-up as a linked server and
am using MyODBC.
I have no problems creating a read only view using the open query structure
but wish to use the four part names format for
Jocelyn Bernier writes:
Hi,
I use MySQL version 3.23.33 on Windows NT 4.0 SP6. When I use the command
ALTER TABLE ... RENAME TO ... most of the time my MySQL service stop. I
need to restart it from the service control panel. I don't have any errors
in the logs. When restarted, my
liu hui wrote:
hello;
I meet a problem when I wont to install mysql3-23-33.
after I run the command
./configure
a error report to me
the last several line are printed as followed:
"
checking whether stat file-mode macros are broken... no
checking return type of signal handlers...
Hi All
I am trying to compare information in 2 different tables and return
matches. The problem is that this query only returns the listings where
I want it to return a row from AutoEmail when it finds a match.
What am I doing wrong?
SELECT * FROM AutoEmail, listings WHERE
Mark Selby writes:
Hi all,
When having performed a query with a LIMIT, is there any way to get
the total records that would have been retrieved without the LIMIT
being used (other than building and executing a separate COUNT (*)
query) ?
Please CC to this email address as I'm
Can anyone tell me how to UNSUBSCRIBE from this LIST.
Thanks a lot
"Matthias Urlichs" [EMAIL PROTECTED] wrote:
Hi,
Sinisa Milivojevic:
First of all, where have you got 3.23.34 when it is not out ??
It's the version in your current BitKeeper archive.
Second what type of column is
Hello,
I installed MySql serevr version 3.23.33 on Red Hat Linux 7.0.
Sometimes when I reboot the system, MySql do not work. I have to
uninstall and then reinstall
MySql server. What could be the problem?
Rashid
-
I am trying to compile version 3.23.33 on Linux on an IBM S/390 mainframe.
I the following entry to
config.sub to get configure to recognize the machine type:
# Added a CPU type for the S/390 so we could compile. J. Nealy 3/5/2001.
s390-*)
basic_machine=s390-ibm
Hello mysql,
(Note: this post contains characters in windows-1257 encoding, they
may appear incorectly in your e-mail clients).
I believed everything is OK with MySQL support for cp1257 charset
until I actually tried to sort records alphabeticly.
What I find out was:
1. Typo in cp1257.conf
Hi!
I've compiled the udf_example.cc file into an so, copied it to /usr/lib, but
when i issue a
CREATE FUNCTION lookup RETURN STRING SONAME "udf_example.so";
I get: Error 1041: Out of memory.
I've searched the mailing list and the web, and all the information I get is
that it seems to only
Christian Hammers writes:
Hello
I like to propose the attribute create_tmp_priv as little alternative to
create_priv.
The reason is that due to the lack of sub-selects temporary tables which
can be created with the same name at the same time by many connections are
often very
Dear All
I've been using apachetoolbox - a shell script that installs apache with
the options of including lots of modules (php, mod_ssl, mod_perl etc
...). Its great for installing a custom apache (something I do all to
often ;-).
It offers a menu and will download / configure / complie any
If you can deal with the technical query below it would be much appreciated.
Many Thanks
Sunit
- Original Message -
From: Jonas Norrman [EMAIL PROTECTED]
Message-ID: [EMAIL PROTECTED]
Date: Thu, 8 Mar 2001 17:49:37 +0100 (CET)
To: Sunit Modi [EMAIL PROTECTED]
Cc: [EMAIL
I am confused about the way INSERT DELAYED reacts to setting an
auto_increment field to NULL. I am inserting records into a table where one
of the columns is auto_increment. Usually when setting the value of an
auto_increment field in an INSERT query I pass a value of NULL. When I do
the same
Hi
Have tried to start it manually instead of reinstalling it?
Seung-woo Nam
Rashid Zolqarnain wrote:
Hello,
I installed MySql serevr version 3.23.33 on Red Hat Linux 7.0.
Sometimes when I reboot the system, MySql do not work. I have to
uninstall and then reinstall
MySql server.
Description:
SHOW DATABASE and SHOW TABLES and mysqlshow all return empty lists (i.e a nice list of
blanks - no of blank lines
equals number of databases / tables)
How-To-Repeat:
Do a mysqlshow or SHOW DATABASES under mysql
Fix:
Submitter-Id: submitter ID
Originator:Greg Cope
On 08.03.2001 13:39:34 James Makunike wrote:
Where do I get the php libraries as one file?
What do you mean?
http://www.php.net has the sources and binaries
-
Before posting, please check:
Mark
I ran into a similar problem building a VB maintenance program for a
database that resides on Linux. Many of my queries were too big for
MyODBC to return. I ended up using the count function to find out how
many records would be returned then allowing the user to fetch them in
blocks via
DIGITECNIA.COM presenta su nuevo portafolio de
Soluciones Internet:
-Hosting
-Desarrollo de Sitios Web
-Diseo y Animacion Multimedia
-Comercio Electronico
-eMarketing
Con Excelentes Precios, Servicio y Soporte que garantizan
el exito de la presencia de su empresa en la red.
Visitenos en:
Bonjour,
Tout d'abord, il s'agit d'une liste de diffusion anglaise, donc si tu veux
que le plus de monde puisse t'aider, il vaut mieux faire la demande en
anglais.
Ensuite, il faut eviter d'envoyer des e-mail sous forme HTML, car pour
certains utilisateurs (UNIX,Mac) ca devient illisible !!
Et
[EMAIL PROTECTED] wrote:
Whops !
This is the know bug, but I did mysqlbug on this machine a fwe weeks
ago, and have only just sorted out the mailserver today - and did not
notice this in the queue - appologies for wasting anyones time with
this.
As an aside has anyone got further than this
John Nealy writes:
I am trying to compile version 3.23.33 on Linux on an IBM S/390 mainframe.
I the following entry to
config.sub to get configure to recognize the machine type:
# Added a CPU type for the S/390 so we could compile. J. Nealy 3/5/2001.
s390-*)
Yoann Chevalier writes:
Bonjour,
Tout d'abord, il s'agit d'une liste de diffusion anglaise, donc si tu veux
que le plus de monde puisse t'aider, il vaut mieux faire la demande en
anglais.
Ensuite, il faut eviter d'envoyer des e-mail sous forme HTML, car pour
certains utilisateurs
The following URL Points to the Python MySQl interface. Also Zope is a
web applications server written in python which has the ability to
connect to MySQL.
http://dustman.net/andy/python/MySQLdb/
iq wrote:
Dear Guys,
Is there any API or modules to connect MySQL from Python??
--
Best
I am porting an application from Oracle to mySQL and I have this query which
I need to port:
select id, senderID, recipientFirstName, recipientLastName, recipientGender,
occasion, month, day, sentDate
from reminderclub
where (sentDate is null or sentdate-sysdate30)
and
Hello,
I have searched the mailing list for this topic, but didn't find a match vor
my problem.
I am working on Linux Mandrake with MySQL 3.23.33 installed from the RPMs
for Mandrake. I am trying to convert a ACCESS database to MySQL using a perl
script. The script makes connections to the
Hi
What is the best way to download and upload BLOB object to MySQL database using Java,
JDBC
I tried using load_file in an INSERT query but it did not work
Also I would like to know how to read the BLOB objects from the database
Hello list
While browsing old sources by a former employee I realised that he always
did comma seperated joins and then a "where"
FROM
tablea a, tableb b, tablec c
WHERE
a.id=b.id and b.nr=c.nr
whereas I learned to do
FROM
tablea a
Does anyone know how to convert a FreeBSD UNIX MYSql database to Windows
NT/2000 MYSql Database?
Thanks,
Tom Flanagan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Christian Hammers wrote:
Hello list
While browsing old sources by a former employee I realised that he always
did comma seperated joins and then a "where"
FROM
tablea a, tableb b, tablec c
WHERE
a.id=b.id and b.nr=c.nr
whereas I learned to do
In the last episode (Mar 08), Tom Flanagan said:
Does anyone know how to convert a FreeBSD UNIX MYSql database to Windows
NT/2000 MYSql Database?
Just copy the files over to the new machine. No conversion necessary.
--
Dan Nelson
[EMAIL PROTECTED]
Steve Ruby wrote:
Christian Hammers wrote:
Hello list
While browsing old sources by a former employee I realised that he always
did comma seperated joins and then a "where"
FROM
tablea a, tableb b, tablec c
WHERE
a.id=b.id and b.nr=c.nr
If you are using MS Access, the easiest way is to export the tables via the ODBC
driver. Simply right click on your table name, then click export. At the bottom of the
list there the ODBC option. I haven't had any problems using this method of
transferring tables, other than the fact that
On Thu, Mar 08, 2001 at 10:29:20AM -0700, Steve Ruby wrote:
He is doing an inner join, you are doing a left join, they (potentialy)
do not produce the same results.
Hmm have to think about it... inner means fields where the right table has
a NULL value in the condition are left out, right?
If
Tom Flanagan wrote:
Does anyone know how to convert a FreeBSD UNIX MYSql database to Windows
NT/2000 MYSql Database?
Thanks,
Tom Flanagan
If you are using MyISAM tables (3.23.x) you can simply copy them from
one computer to the other. If you are using ISAM tables like in
3.22 you
Tobias Wolff wrote:
Hello,
I have searched the mailing list for this topic, but didn't find a match vor
my problem.
I am working on Linux Mandrake with MySQL 3.23.33 installed from the RPMs
for Mandrake. I am trying to convert a ACCESS database to MySQL using a perl
script. The script
Christian Hammers wrote:
On Thu, Mar 08, 2001 at 10:29:20AM -0700, Steve Ruby wrote:
He is doing an inner join, you are doing a left join, they (potentialy)
do not produce the same results.
Hmm have to think about it... inner means fields where the right table has
a NULL value in the
Christian Hammers wrote:
On Thu, Mar 08, 2001 at 10:29:20AM -0700, Steve Ruby wrote:
He is doing an inner join, you are doing a left join, they (potentialy)
do not produce the same results.
Hmm have to think about it... inner means fields where the right table has
a NULL value in the
Hi,
We are implementing a linux cluster, and rather than get gouged by oracle
(in performance and licensing) would much rather use MySQL. I searched
through the archives and found several references to failover and
replication but still have some questions.
If I understand correctly,
Hello,
On a related matter, do the various JOIN's (LEFT, INNER, and OUTER) use a
temp file
when processing?
Table pollResponses:
+-+---+--+-+-++
| Field | Type | Null | Key | Default | Extra |
Can anyone recommend a Z39-50 Server to use with MySQL?
thanks
Melanie Dutkiewicz
--
Melanie Dutkiewicz, PhD.Tel: (604) 278-3411x2520
MacDonald Dettwiler direct line: (604) 231-2520
13800 Commerce
Hi
I follow this list for long time. This is first time I have to ask the
question.
I'm developing something like proxy for mysql. Everything works fine
except when mysql client working with mysql over proxy is reciving
bigger amount of data. For example big resultset.
Let me explain situation.
Hi!
Does MySQL's insert delayed handler insert concurrently with selects on
MyISAM tables like the non-delayed inserts?
Sincerely,
Steven Roussey
Network54.com
http://network54.com/?pp=e
-
Before posting, please check:
Hi!
I have received several emails from people that choose not to (or can not)
post to the list about mysql segfaulting.
At the moment, I have the segfaults stopped by doing all of the below, I
don't know (yet) which are to blame or in what combination:
1) Eliminate insert delayed (not really
Hi everybody,
I am using a MySQL Database with MyOdbc 2.50.36-nt under WinNt SP6a and Win
2000 SP 1. The language of my frontend is CA Visual Objects (ClassMate library
for SQL)
When skipping through my data set with
nRetCode =
I am installing mysql-3.23.33-dec-osf5.1-alphaev6 on a DEC Alphastation
running True64 Unix version 5.0A.
Logged in as root, when I run scripts/mysql_install_db as part of the
installation, it runs as far as
% scripts/mysql_install_db
Preparing db table
Preparing host
Hi
Right now I'm happy.
Sorry for spam. I had an error in mys socket coke.
By
P.S. Proxy works well and gives many possibilities.
Daniel a wrote:
Hi
I follow this list for long time. This is first time I have to ask the
question.
I'm developing something like proxy for mysql.
As noted on the mysql website, you need to use the gnu version of zip
(gtar-sparc)if you are on solaris, as you are
/Cody Caughlan
ALICE CHIAPPETTA wrote:
I have downloaded the stable release for Solaris. Everytime I try to
gunzip and tar it. Everything works till the end then I get
Hi =)
Could you help? I have a table with a datetime field and I'm trying to
figure out how to format an SQL query to select records only from within
the current month. Any help would be greatly appreciated.
Thanks,
-Ed
scripts/mysl_install_db --user=mysql
Now that you have files and directories created under the wrong user,
you
can chown -R mysql /usr/local/mysql/var
or whatever the data directory is on your system.
Titus Purdin wrote:
I am installing mysql-3.23.33-dec-osf5.1-alphaev6 on a DEC
I can't see how CASE works ?? Manual is fairly breif on the subject.
The SQL below has some kind of snag. Is this getting too hairy to use CASE within a sum
expression ?? Any thoughts or comments would be appreciated.
SELECT Sum(DebtorTrans.OvAmount + DebtorTrans.OvGST +
.WHERE monthcol=MONTH(now()). I think this should work.
Hi =)
Could you help? I have a table with a datetime field and I'm trying to
figure out how to format an SQL query to select records only from within
the current month. Any help would be greatly appreciated.
Thanks,
-Ed
Hi,
I'm having a dickens of a time getting mysqldump to
work. No matter what I enter, mysqldump says...
/usr/local/mysql/bin/mysqldump: option `--databases' doesn't allow an argument
I've perused the list archives and looked at the manual. It
should work but doesn't. What am I doing
Can anyone shed a little light on this for me? I've got a mysql installation that has
been running for over 2 years now. As the database has grown to over 250Meg (not TOO
large at all) things have kind of slowed down. We're running this on a RH box with
mysql v3.23.32.
So, we bought a new
mysqldump --databases db1 db2 db3 ...
Note, these are complete databases, NOT tables.
to try it do:
mysqldump --databases mysql
Doug Poland wrote:
Hi,
I'm having a dickens of a time getting mysqldump to
work. No matter what I enter, mysqldump says...
Thanks to everyone who helped so quickly =) Based on what people said, I
was able to come up with a solution. The goal was to get a total number of
log entries from a given month and year. The query we came up with is:
select count(*) as Total from log where month(datestamp) =
Well, I am running 3.23.33, and it works for me.
Doug Poland wrote:
On Thu, Mar 08, 2001 at 03:03:43PM -0600, Gerald L. Clark wrote:
mysqldump --databases db1 db2 db3 ...
Note, these are complete databases, NOT tables.
to try it do:
mysqldump --databases mysql
I've tried
folks,
I need help. I installed mysql on NT, everthing seems fine. I wanted to insert fields
into a table, as described in the tutorial from a file. It said the default that
delimits a field is a tab, so I added fields delimited by tabs. (i used microsoft edit
to create the file). i have also
On Thu, Mar 08, 2001 at 03:33:54PM -0600, Gerald L. Clark wrote:
Well, I am running 3.23.33, and it works for me.
I'm working via ssh on an ISP's host. I wonder if there are
permissions that have to be set in order to run mysqldump.
Out of curiosity, I tried it on another ISP running MySQL
I find the fuzzy matches from MATCH and AGAINST to be too unpredictable.
Does using a FULL TEXT index also speed up simple LIKE searches ?
-
Do You Yahoo!?
Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail.
New to list, and to mySQL. If there are archives available, please let me
know--I'll search them.
I have a client who is building a new win2k server, and wants to use
ColdFusion to connect to a mySQL db, instead of MS SQL7.0. Docs show it
will work with myODBC, but gives examples for Unix.
1.
Need more info.
Which tutorial?
Are you trying to insert data into a table or put new fields into an
existing table?
Cal
http://www.calevans.com
-Original Message-
From: David Phoon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 08, 2001 3:44 PM
To: [EMAIL PROTECTED]
Subject:
Hello David,
Thursday, March 08, 2001, 11:44:21 PM, you wrote:
DP folks,
DP I need help. I installed mysql on NT, everthing seems fine. I wanted to insert
fields into a table, as described in the tutorial from a file. It said the default
that delimits a field is a tab,
DP so I added fields
What is the process to purge databases in mysql?
Thanks in advance,
Aruna.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
Andrew Staples wrote:
New to list, and to mySQL. If there are archives available, please let me
know--I'll search them.
I have a client who is building a new win2k server, and wants to use
ColdFusion to connect to a mySQL db, instead of MS SQL7.0. Docs show it
will work with myODBC,
1. Can CF work with mySQL via myODBC on win2k?
Of course. That's the beauty of ODBC, as long as your language can call an
ODBC connection (which CF can of course) you can use it.
2. Is there a better way to use CF and mySQL?
With what goal in mind? If you're worried about the overhead that
I have a similar problem indexing a TEXT field. I am trying to create a
unique index on the first 1024 characters of a TEXT field:
* mysql
* Welcome to the MySQL monitor. Commands end with ; or \g.
* Your MySQL connection id is 66 to server version:
Damn!
It took longer, but crashed again. The stack trace has been the same as the
last three crashes:
# resolve_stack_dump -s /tmp/mysqld.sym -n mysqld.stack
0x40097532 __evoke_link_warning_llseek + 937652786
0x80b3360
Hi guys,
I set up a table that I'll be using for a mailing list. Two
fields: id and addr. The id is a unique primary key that
is used to "identify" (?) the email address in the addr
field.
How can I remove duplicate addresses in the addr field?
I know of the
select distinct addr from
Attached is an updated version of the mysqldumpslow command that's
supplied in the mysql distribution.
The mysqldumpslow, for those who've not tried it, makes it very
easy to summarize and analyze the contents of the 'slow query log'.
This update was prompted by the need to support the newer
on 3/8/01 3:40 PM, Scott Wang at [EMAIL PROTECTED] wrote:
select distinct addr from tablename outfile filename.txt
But how can I write the data to another table or even
replace the information in the table with the output info?
insert into another table (addr) select distinct addr from
On system: SuSE 7.1 Professional
MySql version: Ver 3.23.32 for pc-linux-gnu on i686
have also run the mysql_install_db, which says that all files have been
installed.
when running safe_mysql
1) mysqld errors out
2) I get the following in linux.err
Jerry
At 13:53 08/03/2001 -0800, Andrew Staples wrote:
Hi!
I did a CF tag for Coldfusion to build and remove DSN files for
MyODBC. The dll is called mydsn.dll and you find it at our
contribution page and you can get the source code for VC++
too.
Regards,
Miguel
New to list, and to mySQL. If there are
Hi,
I'd try to `optimize' the tables in the first place.
Have you tried to select and group by PR1.pollResponsesID instead of
PR2.pollResponsesID?
As they are the equal, the result should be the same, but the query might get
optimized better.
Hope this helps,
Jan
"Oson, Chris M." wrote:
1 - 100 of 115 matches
Mail list logo