Hi Prabhu,
> -Original Message-
> From: Prabhu Venkata [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, November 22, 2001 11:14 PM
> To: '[EMAIL PROTECTED]'
> Subject: Connection Terminated
>
>
> Hi all
>
> I have my mysql database installed on NT.
> I have written small VB application to
database,sql,query,table
database,sql,query,table
If you just reply to this message, and include the entire text of it in the
reply, your reply will go through. However, you should
first review the text of the message to make sure it has something to do
with MySQL. Just typing the word MySQL once
Okay, so I decided to test a few things out. If I try to compile
mysql+gemini-3.23.41 with no additional options, everything compiles
fine, and MySQL works just fine. However, if I add --with-gemini to my
configure line, it bombs during compile with:
gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../i
Hi Satish,
> -Original Message-
> From: K. Satish Kumar [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, November 22, 2001 10:55 PM
> To: [EMAIL PROTECTED]
> Cc: Apparsamy perumal
> Subject: Driver problem
>
>
> Hi!
>
> This is Satish. I am using your mysql software for administering my
Hi all
I have my mysql database installed on NT.
I have written small VB application to upload .txt files into database.
If I work from NT to NT is working fine.
If I install my vb application on Win98 and having the database at NT then
after couple of line reading from the text file. It gives m
Hi!
This is Satish. I am using your mysql software for administering my
database. We have developed an application using VB as the front end and
mysql as the back end on all the windows plaforms(NT, 95,98,2000,ME). The
problem where we are facing is while installing the driver. It works fine
w
Hi all,
I need to read some tab delimited text files into mysql. The files are in
Mac Roman (Western) encoding. This encoding support is not there in the
default installation of Mysql.
Can anybody provide me the pointers as to from where can I get a binary
distribution for Mac OS X with support
Hi,
> -Original Message-
> From: Delphi Guy's [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, November 22, 2001 2:06 PM
> To: [EMAIL PROTECTED]
> Subject: HOW TO : Run wave files stored in BLOB field ???
>
>
> Hi all, This the first post for me to this lists I
> appreciate If I take a go
At 4:21 PM -0500 11/21/01, Kurt Tappe wrote:
>Why does the MacOS X build of MySQL 3.23 include a "manual.html"
>that contains install instructions for only Linux and Windows? I'm
>stuck trying to figure out how to install this thing. MacOS has no
>"groupadd" command (due to the existence of t
At 7:14 PM -0800 11/21/01, Bennett Haselton wrote:
>Each time I open a database handle (in perl code), does that cause a
>new process to run, a new instance of mysqld? And each time I
>disconnect the database handle ($dbh->disconnect() in perl code),
>does that cause the number of running inst
Hello Everyone,
I wants to find the max. date and Login status of employee for Attendance
table.
The qurey runs fine but it shows me the wrong status.
select max(a.dAtt_Date),a.nLog_Status from tbl_attendance a,tbl_attendance b
where a.nEmp_id = 1 and a.nLog_Status = b.nLog_Status
group by b.nEm
Okay, so seeing Gemini failing, it was InnoDB's turn:
gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../../include -I../include
-DDBUG_OFF -O3 -DDBUG_OFF-DDEBUG_OFF -DUNIV_INTEL_X86 -c sync0sync.c
sync0sync.c: In function `sync_gnuc_intelx86_test_and_set':
sync0sync.c:187: impossible register const
Has anyone else tried to set the INSERT_METHOD for MERGE tables? It
keeps throwing a syntax error for me.
Following the docs verbatim (http://www.mysql.com/doc/M/E/MERGE.html),
here's what I get:
>>output
mysql> CREATE TABLE t1 (a INT AUTO_INCREMENT PRIMARY KEY, message
CHAR(20));
Query OK, 0 r
Hey, I was reading over some of the stuff on this list, and I was just
wondering, where I could find information on the different types of tables
and their purposes since I really don't know this... :/
1vs0 - Design by Dreams
-
Has anyone setup MySQL 3.23.44 with ColdFusion 5.0 Enterprise Edition. I
have heard that there may be problems with transactions. I was wondering if
anyone knew how to do this, and if they could point me to some reading
material.
I was also wondering if MySQL 4.0 would include transactions and
when I try to run mysqld on Solaris 2.6
there are the errors like this
ld.so.1:mysqld fatal : libCrun.so.1 :open failed : No such file or directory
please help me , thank you very much
-
Before posting, please check:
http:/
Hi!
> "Ken" == Ken Kinder <[EMAIL PROTECTED]> writes:
Ken> Monty, is this like a product you're selling? I would like more information,
Ken> although I haven't gotten to this yet in my security sweep.
This is something a customer of our is sponsoring and that we will put
into MySQL 4.0 as
Hi all,
Is there anyway to delete the duplicate records in mysql
without creating new tables. I am wondering what query
will achieve this task where mysql doesnt supports like ROWID and sub queries.
I appreciate if some one help me out.
thankyou.
-malkova.
-
Please excuse the OT posting, but I'm am somwhat in a bind and wasn't sure where
to post this question. and I've many references to upgrading from the gcc 2.91
to 2.95
I've installed all the dependency for gcc 2.95.1 and when I attempt to install
the rpm gcc-2.95.1 I keep getting this message:
[
Hi,
using the binary distribution mysql-4.0.0-alpha-pc-linux-gnu-i686, installed
in the standard location /usr/local, running on
Debian GNU Linux, I noticed the following buglets:
INSTALL-BINARY and manual.txt both refer to bin/safe_mysqld which doesn't
exist; they mean bin/mysqld_safe.
--
If you have an index consisting of member_id & mail_id (opposite
order), you'll need just one index.
A good explanation of why may be found at:
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Optimisation.html#Multiple-column_indexes
-rh
>I for sure need an index on the mail_i
Check out the 'INTO OUTFILE' portion of the SELECT statement.
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SELECT
-rh
>Hello all,
>
>Usually I back-up my tables importing them to .csv files.
>
>What I do is I issue the following command :
>
>mysqldump - h localhost -
Take a look at using a regular expression in the where clause of the
UPDATE SQL statement to match them.
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#IDX1206
http://www.mysql.com/documentation/mysql/bychapter/manual_Regexp.html#Regexp
From there, MySQL's string fun
Hi.
I hope I've solved problem with mysql.
I've contacted with my motherboard vendor (Asus) and technical support suggest
me to upgrade bios. It is standard answer IMHO :), I haven't believed it can
help. But it helped. Now everything looks OK.
I'm sorry that I couse confusion.
Best regards.
At 10:04 22/11/2001 +, Sandeep Murthy wrote:
Hi,
When you are having problems for to start the server as service on
NT/Win2000 machine. Follow the below troubleshooting:
1- Enter in the \mysql\bin directory opening a DOS prompt screen.
2- Execute the remove service command with any server e.
Hi Ashley,
- Original Message -
From: "Ashley M. Kirchner" <[EMAIL PROTECTED]>
> While compiling MySQL+Gemini-3.23.41 i received the following error:
> [...]
> System is RedHat 7.1, with their GCC 2.96-85
No idea about Gemini, but we do have an advisory against using gcc 2.96 o
At 9:43 AM +0100 11/22/01, Attila Beno wrote:
>-BEGIN PGP SIGNED MESSAGE-
>Hash: SHA1
>
>On Thu, 22 Nov 2001, Ashley M. Kirchner wrote:
>
>> While compiling MySQL+Gemini-3.23.41 i received the following error:
>>
>> System is RedHat 7.1, with their GCC 2.96-85
>
>Same here, altho
At 12:45 PM -0500 11/21/01, Auri Net SAC wrote:
>Hi
>
>it is possible
>
>"select * from table where col1 <= now and col2>=now"
>
>where col1 and col2 are date type
>
>thnaks
Yes, except that it should be now() rather than now.
-
Hi all, This the first post for me to this lists I
appreciate If I take a good picture as I hear...
I creat table in MySQL like this
CREATE TABLE test
(
ItemID INT NOT NULL AUTO_INCREMENT,
FirstNameCHAR(50),
LastName CHAR(50) NOT NULL,
Mark writes:
> When I do a describe statement, I see some default values assigned
> automatically to columns in the table. What statement will assign a column
> to blank, so that there is no default value assigned?
Short answer: you can't. There was a long thread about this a week
or two ago,
Hi Jose,
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jose
> Gerardo Amaya Giron
> Sent: Thursday, November 22, 2001 1:11 PM
> To: [EMAIL PROTECTED]
> Subject: MySQL Newbie and Access Database
>
>
> Hello all, I just start up with mysql so I have s
When I do a describe statement, I see some default values assigned
automatically to columns in the table. What statement will assign a column
to blank, so that there is no default value assigned?
-
Before posting, please check:
I think you want to do the following (notice the parentheses next to the
mysql function named now):
SELECT * FROM Table WHERE col1 <= now() AND col2 >= now();
Bye,
Neil
On Wed, 21 Nov 2001, Auri Net SAC wrote:
> > Hi
> >
> > it is possible
> >
> > "select * from table where col1 <= now and c
the bin log files are actually files for binary logs fused in
replication.
To do rollbacks and such, you need to use innodb table types.
Innodb has table locking, commits, rollbacks, etc and also special log
files to handle the rollbacks.
Read more about innodb table types in the Mysql help.
Other
Hello all, I just start up with mysql so I have some stupid questions to
ask.
right now I have an MS Access database with one table that has 25 fields
and like 2000 records in it. I'm trying to move to MySQL in order to
have a better DB. I can define the database and the table manually
that's not
So I have found out that mysql creates bin logs of all queries so that it
can do rollbacks and such. But is it really necessary for it to maintain
these logs forever so that they end up to be 10gigs + for only a few
thousand current rows.
Ric
Happy thanksgiving everyone! And I especially thank those involved in
MySQL development and other open source projects -- you really make the
computer world a better place for all of us!
I also have a problem that I hope some can help me with ;-)
I wrote earlier in this thread, trying to compil
Hi
Having a bit of bother with this one, wondering if anyone has the answer,
I've got two tables one is News items
News_IDNewsetc...
1Today in .etc
2Hello world .etc
3Blar di blaretc
4And now time for something
In the last episode (Nov 21), Bennett Haselton said:
> Do you mean processes instead of threads?
>
> (ps lists each *process* separately, along with its process ID, but
> doesn't list separate threads within each process. If mysqld handles
> each new connection by calling fork(), then I think fo
>> I would like to send multiple SQL statements using the C
>> API mysql_query. I have a large string with 20 SQL statements. When
>> I call mysql_query with that string, only the first one is processed.
>>
>> Is there a way to do what I'm doing without separating the statements
>> into individ
On Thu, Nov 22, 2001 at 09:25:47PM +0200, Scott Alexander wrote:
> Hi,
>
> Does anyone have any experience in using webdav with apache to
> update a mysql db?
>
> Any pointers?
>
> I'd like that when a user uploads a file using webdav to then move
> the file to a new location on the server and
Hi!
On Nov 22, Stuart Scamman wrote:
> I'm getting "Got error 127 from table handler" on specific tables quite
> regularly, what does this indicate and how do I avoid it ?
% perror 127
127 = Record-file is crashed
So - repair your tables.
If the error still persists, report the bug.
Regards,
S
Hi,
Does anyone have any experience in using webdav with apache to update a
mysql db?
Any pointers?
I'd like that when a user uploads a file using webdav to then move the
file to a new location on the server and enter the filename and file
location into a mysql database.
my system is using
lin
I'm getting "Got error 127 from table handler" on specific tables quite
regularly, what does this indicate and how do I avoid it ?
Hi,
> -Original Message-
> From: Adam Douglas [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, November 22, 2001 6:54 AM
> To: '[EMAIL PROTECTED]'; Mysql@Lists. Mysql. Com (E-mail)
> Subject: RE: MySQL with MyODBC & Access
>
>
> Hi I recently upgraded MyODBC as you stated on our term
Sorry, new MySql user test.
-
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 unsub
Hello all,
Usually I back-up my tables importing them to .csv files.
What I do is I issue the following command :
mysqldump - h localhost -u
user -ppassword --tab="/tmp" --fields-terminated-by=";" database_name
table_Name > table.csv
This creates a file called table.csv by dumping all the cont
Hello all,
I've got some e-mails addresses on an e-mails database where one domain has
been changed to another.
So I have :
email1@domain1
email2@domain1
I need to change @domain1 to @domain2 on this e-mail field and keep the user
name.
Some e-mails of an specific ISP had their domains change
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Thu, 22 Nov 2001, Sergei Golubchik wrote:
> > I have a quick question about replication: how does it process
> > transactions? Does it store all the commands, or does it just store the
> > ones that were commited?
>
> Only committed.
>
> >
Hi!
On Nov 22, Attila Beno wrote:
>
> I have a quick question about replication: how does it process
> transactions? Does it store all the commands, or does it just store the
> ones that were commited?
Only committed.
> And: can I use replication with different table fortams on teh master and
Dana,
What I did, to set up a second MySQL on our Linux box, compiled the second copy
from source, which gives you a lot more control on how MySQL is installed. then
created a my.cnf file with all the relavent settings for the second server, port
and socket, pid ...etc.. then put this in the dat
Hello,
As you probably know mysql comes installed in Linux 7.1 as default.
I installed my own mysql server in a different location in the file system,
In safe_mysqld I indicated the path in which I want the mysql.sock to be
created in but when I start my mysql server I get an error message:
Can't
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
hi,
I have a quick question about replication: how does it process
transactions? Does it store all the commands, or does it just store the
ones that were commited?
And: can I use replication with different table fortams on teh master and
slave?
Let
On Thu, 22 Nov 2001 05:56:21 -0800 (PST), Michael Bevan <[EMAIL PROTECTED]>
wrote:
>>I think I erased my .pid file in a misguided effort
>>to reset my password, does anyone know how to
>>re-create it or do I need to do a full SQL re-install?
>>
>>Thanks - Mike
No, simple restart the MySQL server
Dear Sirs and Madams,
EMS HiTech company is announcing the next version (1.21) of MySQL
Manager -- A Powerful MySQL Administration and Development Tool for
Windows95/98/ME/NT/2000/XP.
You can download the latest version from
http://www.mysqlmanager.com/download.phtml
Since now MySQL Manager wil
Hi I recently upgraded MyODBC as you stated on our terminal server
and two PCs. Now I tried running the install.bat file but it didn't seem to
work so I just looked at the batch file and did it all manually. I believe
for some odd reason the variable %windir% wasn't working. Either way the
>> Any one have example Banking software written in PERL or PHP with MySql
Database. if you have one mail me or provide me the URL of such software.
I don't think there are many banks that don't pay insane amounts for Oracle
or IBM to come in and design all their systems.
---
At 10.08 21/11/01 -0700, Steve Meyers wrote:
>Wait for 4.1, it will have multi-table updates in it. Until then,
>you'll have to use two separate queries.
>
>Steve
i'm also new to mysql but i think you can use MERGE tables.
Couldn't you ?
==
dott
I think I erased my .pid file in a misguided effort
to reset my password, does anyone know how to
re-create it or do I need to do a full SQL re-install?
Thanks - Mike
__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/
Dear members,
I am using mySQL in Windows platform.
Through OLEDB I am connecting to the ASP page.
For simple queries, it is working fine.
If I use for outer join means it is giving error "Provider could not support
asynchronous execution"
I am using myOLEDB.
Help me
Thanks in advance
yours
Karthi
Hi. We're in the process of making a database driven website for a
client and I'd like to clear one doubt. There are going to be two frontend
machines w/ apache on linux and one shared NAS on the back for the all
data (possibly a Netapp box).
My question is: is it a good idea to have the dat
Glenn English writes:
> RH7.2
>
> When I run 1.7.5 either static or semi static, I get
>
>Can't connect to local MySQL server through socket " (111)
>
> Host name is "localhost" ("120.0.0.1" doesn't work either).
>
> I do have access rights - running as root.
> --
> Glenn English
> [EMAI
dan writes:
> Towards the end of running the end of the configure script (./configure
> --prefix=/usr/local/mysql - and yes I know I can optimise better than
> this), I get:
>
> creating ./config.status
> creating Makefile
> sed: file conftest.s1 line 6: Unterminated `s' command
> creating os/M
You can join all three tables together
select d.members_id, m.name, old.name from data as d
left join members as m on m.members_id=d.members_id
left join oldmembers as old on old.members_id=d.members_id
If the members_id belongs to an old member, all fields from the member table
Hi,
We're replicating databases across a firewall with
a 300 second reflective ACL timeout set.
This causes occasional problems with replication,
where if the master is idle for more than 300
seconds, the connections are closed by the firewall
in such a way that the slaves never notice. Tha
Hi, all,
I tried to install mySQL on Windows NT (Service Pack 6).
That means: Unzipping, installing, then starting mySQL as a service with
: mysqld-nt --install.
Until now everything worked fine and we saw the service in the NT's
Service list.
But we could not start the service. Neither with NT
>Can't you just make a check before you make a call to the DB?
>if( member_id > 1000 )
> // old member query here
>else
> // new member query here
Now I did just that, but that means I have to open recordset 20 times a page
(for each record separately)...
I am a begginer, I don't kn
Hi,
I'd like to know how to change the port to use for connection
I work under WINNT. I tried with mysqld-nt --port=1234
but it seems it enters in a loop.
Thanks in advance
Francesco
--
FRANCESCO TAGLINO
LEKS - Laboratory for Enterprise Knowledge and Systems, at IASI-CNR
Viale Manzoni 30, 00185
>Hello! How do I get the size of a blob?
>I want to do something like this:
>SELECT * FROM blob_table WHERE size(blob_column) > 1024;
replace "size" with "LENGTH" and it will work.
SELECT * FROM blob_table WHERE LENGTH(blob_column) > 1024;
Giuseppe Maxia
>Description:
$ rm -f config.cache
$ ./configure --prefix=/home/crystal/local/mysql-3.23.44 \
$ --with-berkeley-db \
$ --with-innodb \
$ --with-charset=big5 \
$ --with-extra-charsets=latin1,gb2312
$ make clean
$ make
$ make test
$ # mysql-3.23.39, 3.23.40, 3.23.42 can pass all tests.
$
hi,
I had posted a few days back regarding having problems running MySQL on WIN
2000...
I forgot to add before, I can ping my localhost but unable to do a telnet
localhost too...
I had installed and was running MySQL and PHP with IIS successfully for
nearly 2 mths now... All of sudden since a fe
hi,
I had posted a few days back regarding having problems running MySQL on WIN
2000...
I had installed and was running MySQL and PHP with IIS successfully for
nearly 2 mths now... All of sudden since a few days back the MySQL service
refuses to start and keeps giving various errors such as unab
>Description:
$ rm -f config.cache
$ ./configure --prefix=/home/crystal/local/mysql-3.23.44
$ --with-berkeley-db \
$ --with-innodb \
$ --with-charset=big5 \
$ --with-extra-charsets=latin1,gb2312
$ make clean
$ make
$ make test
$ # mysql-3.23.39, 3.23.40, 3.23.42 can pass all tests.
$
$ rm
Hi.
You will get far just by downloading it and read the manual
at www.mysql.com
ABDULLAH ERDOÐAN wrote:
>
> Mysql, On Linux and win2000 or Win9x.
> Thanks I am beginner.
>
> _
> Do You Yahoo!?
> Get your free @yahoo.com address at http:
Can't you just make a check before you make a call to the DB?
if( member_id > 1000 )
// old member query here
else
// new member query here
-Ursprungligt meddelande-
Fran: Jerry [mailto:[EMAIL PROTECTED]]
Skickat: den 21 november 2001 21:24
Till: [EMAIL PROTECTED]
Amne:
Mysql, On Linux and win2000 or Win9x.
Thanks I am beginner.
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
-
Before posting, please check
hi glenn,
try to connect from another system on network. because it is client
software. if i am connecting from another system on network it is
connecting.
urs,
sreedhar
- Original Message -
From: "Glenn English" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, November 22, 20
What is Error 127 table handle error ? Restarting mysqld takes care of
it. ulimit = 1024. Thanks.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thu, 22 Nov 2001, Ashley M. Kirchner wrote:
> While compiling MySQL+Gemini-3.23.41 i received the following error:
>
> System is RedHat 7.1, with their GCC 2.96-85
Same here, althogh the binary version starts up fine.
> While I'm on
While compiling MySQL+Gemini-3.23.41 i received the following error:
gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../incl -I../msgs -O3 -DDBUG_OFF -c
dsmindex.c
In file included from dsmindex.c:39:
/usr/include/string.h:245: parse error before `('
/usr/include/string.h:245: warning: conflicting types
80 matches
Mail list logo
