On Sat, Oct 27, 2001 at 09:08:40PM -0700, Vincent Chen wrote:
>
> Dear all,
>
> It might be a FAQ, but bothered me several days. I tried to insert
> a BLOB,acturally a picture, into a table. but always got SQL error.
But you haven't told us the error message you're getting!
Have you double-ch
On Fri, Oct 26, 2001 at 05:52:58PM +0800, sj wrote:
> hi,
>
> I have two machine, install mysql, create same database.
>
> I want these two database can be the same at any time. in other
> word, if one table be inserted a record in one machine, then the
> same table in another machine can be i
On Fri, Oct 26, 2001 at 10:04:44AM +0100, Javier wrote:
> Hi,
>
> I need do the follow:
>
> Table 1.
> Field 1. Varchar (6)
> Field 2. Varchar (6)
>
> The data in this table are for example
>
> Field 1 Field 2
> A TT
> A YY
I tried the lock monitor, and the info it produced seemed to be impossible
to correlate with the actual data operations. On top of that, I run it as a
service, so I have to uninstall the service just to do use the lock monitor,
so hesitate to run it. If you think you can actually make sense out
Dear all,
It might be a FAQ, but bothered me several days.
I tried to insert a BLOB,acturally a picture,
into a table. but always got SQL error.
this is what I do.
$sth=$dbh->prepare("insert into photo values (?,?)");
$sth->bind_param(1,'2001-10-27');
$sth->bind_param(2,$image,SQL_BINARY);
$s
Dear,ray,
Congratulations!
Your downline reached 2000 people today
lets have your September $15 000 BONUS!
In addition of your $19 500 commission check!
In the last episode (Oct 27), D Campbell said:
> quickie: can auto_increment wrap?
>
> I have a system that uses mysql for temporary storage of data. The
> records are kept unique in the usual lazy man's way of having an
> auto_increment ID field.
>
> A large number of records come and go from
> quickie: can auto_increment wrap?
Only with ISAM tables which reuse deleted auto_increment numbers. MyISAM
tables will give you "Duplicate entry" errors if you hit the maximum.
-
Before posting, please check:
http://www.m
quickie: can auto_increment wrap?
I have a system that uses mysql for temporary storage of
data. The records are kept unique in the usual lazy man's
way of having an auto_increment ID field.
A large number of records come and go from this database.
At SOME point in the future, the integer val
On Saturday 27 October 2001 16:00, you wrote:
> I'm having some trouble moving a C application from
> a test machine to production. The program, which uses
> the small wrapper around mysql_query() shown below, runs
> flawlessly on the test machine (hours of runtime; tens
> of thousands if not a
Hi Curtis!
On Sat, 27 Oct 2001, Curtis Gordon wrote:
> omg!
> code red!!
> I JUST installed apache and mysql the other day because my host went down
> and I didn't want to miss out on dev time!
> Is is possible that the downloads i grabbed were already infected?
I think you're fine. Those were
omg!
code red!!
I JUST installed apache and mysql the other day because my host went down
and I didn't want to miss out on dev time!
Is is possible that the downloads i grabbed were already infected?
_
Get your FREE download of MSN
On Thu, Oct 25, 2001 at 06:53:28PM -0500, William Robbins wrote:
> I am getting this error message on my slave server
>
> 011025 16:46:14 mysqld started
> /usr/local/mysql/libexec/mysqld: ready for connections
> 011025 16:46:14 Slave thread: error connecting to master: Unknown MySQL
> Server Ho
When I try to compile the default MyC API that is on the Contributed API
page I get the following error:
I believe that the error has to do with the way database.h includes
mysql.h and that it cant call the methods that are in it.
/cygdrive/d/DOCUME~1/ADMINI~1/LOCALS~1/Temp/cc5hhVhM.o(.text+0x8
I'm having some trouble moving a C application from
a test machine to production. The program, which uses
the small wrapper around mysql_query() shown below, runs
flawlessly on the test machine (hours of runtime; tens
of thousands if not a million+ queries).
On the production machine, the progr
That's W32.Nimda, I believe. Maybe Code Red.
Every 10 minutes or so, you'll get 16 or so attempts shot to yer log.
But yes, this has nothing to do with MySQL.
Mike
Curtis Gordon wrote:
> hi Jim, I am finding a TON of errors like this one..
>
> [Sat Oct 27 01:14:57 2001] [error] [client **.***
>Description:
Note: Thanks to Mr. Chakarat Skawratananond Technical Consultant,
Rapid Port Team, IBM Server Group in Austin, TX USA for his
invaluable help in diagnosing these problems.
make fails because the _AIX32_CURSES symbol is defined before
includi
Tnx for the help.
The problem was indeed the missing ; after every statement, but even then
phpMyAdmin would mess up. Free Mascan did the trick however (after I
inserted the ;'s).
tnx again.
Johan
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday,
hi Jim, I am finding a TON of errors like this one..
[Sat Oct 27 01:14:57 2001] [error] [client **.***.***.**] File does not
exist: c:/phpweb/scripts/..%5c/winnt/system32/cmd.exe
I am not on a winnt system though, I'm running winME here at home. It looks
to me like somebody is trying to access
Hi Paul!
On Sat, 27 Oct 2001, Paul DuBois wrote:
> At 9:38 -0400 10/27/01, jim barchuk wrote:
> >Hi Carl!
> >
> >> Paul DuBois writes:
> >>
> >> > NULL basically means "unknown value", so saying WHERE x = NULL cannot
> >> > work, even if x is NULL. That means "where one unknown value = anoth
Thanks Jim! That didn't even occur to me! Now I looking all through the
mysql folder and I can't find a single log file, where are they kept on a
win32 machine? Do you know?
>From: jim barchuk <[EMAIL PROTECTED]>
>To: Curtis Gordon <[EMAIL PROTECTED]>
>Subject: Re: insert trouble
>Date: Sat, 2
Hi, people !
I'm having a trouble with a program written in C.
This program try to create a record on a table, and it
receives the 2006 error code, "MySQL server has gone
away".
I've looked at the MySQL manual, searched the Web but
the solutions posted doesn't worked for me.
I've checked the
Hello, I am attempting to insert user information into a mysql db, I am
using php4 and the lastest win32 distribution of mysql. I don't get an error
when I try the insert, but the data is not saved. I can create tables just
fine. Also when I enter the same information in the console it insert
In the last episode (Oct 27), Gunter Leeb said:
> Below sequence shows that MySQL returned 0 rows affected after it
> deleted 2 records.
>
> mysql> delete from mmecounter;
> Query OK, 0 rows affected (0.00 sec)
>From the manual:
If you issue a `DELETE' with no `WHERE' clause, all rows are
Below sequence shows that MySQL returned 0 rows affected after it deleted 2 records.
Regards,
Gunter
Environment:
W2K,
mysql. 3.23.41-max-nt
mysql> select * from mmecounter;
+--++-+--+-+
--++-+-
Hi friends,
i installed Mysql 3.23.36 in my Red Hat 7.1 system.
i am using "mm.mysql-2.0.6.1.jar" jdbc driver for connceting to my mysql database.
my program is:
import java.sql.*;
public class TestMysql
{
public static void main(String[] Args)
{
try {
Hi,
On Tru64 5.1, I am trying to install mysql 3.23.43. I follow
the steps in section 2.3 of running scripts/mysql_install_db.
It comes back with the error:
/usr/local/mysql-test/libexec/mysqld: unrecognized option `--password=reqid'
a password I never typed in. After that, it gives the usage
I've had that problem before. It's usually a problem with the max upload
size set in the php.ini or something.
My suggestion would be, if you can get into the mysql console on the
server. Like so:
[mike@sherman mike]$ mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ;
Are the statements ended properly?
like...insert into table (values etc);
Some db's will dump with no semicolon on the end...will give you
an error on the second line.
eejack
091120010850
At 06:28 PM 10/27/01 +0200, Johan Nagels wrote:
>Hi,
>
>I'm trying to import a huge SQL-dump (generated
Hi,
I'm trying to import a huge SQL-dump (generated by another program). The
statements are correct because if I excute them one-by-one no error is
generated. However if I upload them all at once (thru phpMyAdmi or Free
Mascon) I always get an error somewhere at te second line.
Btw. in the dump t
At 23:59 -0500 10/26/01, BadgerBay wrote:
>How do I avoid search problems when a user leaves a search box empty on an
>Ultradev search page running jserv and attached to a MySQL database?
>
>I have three search boxes: Author, Title, and Keyword
>The user enters the search data into one, two, or al
At 9:38 -0400 10/27/01, jim barchuk wrote:
>Hi Carl!
>
>> Paul DuBois writes:
>>
>> > NULL basically means "unknown value", so saying WHERE x = NULL cannot
>> > work, even if x is NULL. That means "where one unknown value = another
>> > unknown value", which cannot be evaluated with any certa
Hi,
I'm working on a payment system that uses an e-wallet. I intend for the
system to provide payment services to other merchants on their sites as well
and I'm worried about scalability and correctly tracking transactions.
Incidentally, I'm very familiar with SQL Server getting MySQL to do what
If you have not obtained Paul DuBois's "MySQL" (New Riders pub, ISBN
0-7357-0921-1), you should consider it a great investment.
For what it's worth, page 169 has a section on resequencing auto_increment
columns that you might be able to apply to your database. Undoubtedly, there
are pages o
Hi Carl!
> Paul DuBois writes:
>
> > NULL basically means "unknown value", so saying WHERE x = NULL cannot
> > work, even if x is NULL. That means "where one unknown value = another
> > unknown value", which cannot be evaluated with any certainty. :-)
>
> It is sort of odd, though, that x = NULL
Hi, Sandra.
Configure Library Setting of JBuilder IDE.
Check IDE's menu out.
Thanks.
Sandra Rovena Frigeri wrote:
>
> Hi,
>
> I need some information about jdbc driver for mysql dbms
> (windows version 3.23.43) for use it with jbuilder (version 2 or 3.5).
>
> Thanks for any information.
Hi,
Document and License is included in gweMysqlJDBC_extra3.zip.
It is Free.
Thanks.
P.S.
I have sent e-mail to 'www.gwe.co.uk' admin 1 year ago.
But They have not replyed me. ;-)
Roland wrote:
>
> > Hi, Roland
> >
> > Try my JDBC Driver.
> >
> >http://www.t3-jpn.com/jdbc/jd
Hello BaderBay!
> How do I avoid search problems when a user leaves a search box empty on an
> Ultradev search page running jserv and attached to a MySQL database?
>
> I have three search boxes: Author, Title, and Keyword
> The user enters the search data into one, two, or all three of the fields
Thank you for your notes.
I do not think, however that logging of successfull connections will
be added, as we have many installations which operate in LAN/WAN
environment with many users.
Not to mention that sites that have highest load have separate servers
for MySQL and separate for WWW ser
On 26-Oct-2001 I wrote:
> I have inherited a database built by someone else who was apparently
> very
> stingy. :-)
>
> A primary key was set to 'tinyint(4)' limiting the number of records
> to 128.
>
> I've tried:
>
> alter table my_data modify phyid mediumint unsigned DEFAULT "0";
>
> ...bu
Sander Pilon writes:
>
>
[skip]
>
> I don't know if it works with the standard mysql++, as we use an
> internal mysql++ clone.
>
> Regards,
>
> Sander
>
Hi!
There is a patch for standard MySQL++ to enable it to be built and
used with STLPort.
I do not think that latest GNU 3 STL is any
Hi,
I have written a Perl script to run SQL commands, and then uses
DBI->dump_results. I need to be able to capture the output of this into
a variable. However, no matter what I do, all I end up with, is the last
line.
Any help would be appreciated.
Thanks
John
--
[EMAIL PROTECTED] writes:
> Hello,
>
> sorry that I'm bothering you, but I havent fount answer to question:
> Does MySQL take any advantage from SUN SPARC/Solaris 8 64bit
> architecture. I think there may be little adavatage when I compile mysql
> with 64bit Forthe compiler than 32bit gcc, becaus
TAKAHASHI, Tomohiro writes:
> Hi, All
> I Fixed two bugs.
>
> 1. If LoginUser has empty password, Driver can not connect to MySQL.
> 2. Connection Pool does not work correctly. ;-)
>
>
> Check this URL out for new Driver. :-)
> http://www.t3-jpn.com/jdbc/jdbcmysql.html
>
Thank y
Francois Barnard writes:
> Hi i have got borland 5.5 commandline compiler and i have just downloaded
> c++ api for mysql.What must i do with the include files to get it to work
>
> Francois
>
>
Hi!
Just include sqlplus.hh
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /
Hi,
I need some information about jdbc driver for mysql dbms (windows version 3.23.43) for
use it with jbuilder (version 2 or 3.5).
Thanks for any information.
Sandra.
-
Before posting, please check:
http://www.mysql.com
George Eric R Contr AFSPC/CVYZ writes:
> How about this:
>
> Create a table with two columns. The first is autoincrement, so guarenteed
> unique. The second is random (but not neccesarily unique).
>
> Now sort this table by the second column.
> The first column, read in order, should now sui
Paul DuBois writes:
> NULL basically means "unknown value", so saying WHERE x = NULL cannot
> work, even if x is NULL. That means "where one unknown value = another
> unknown value", which cannot be evaluated with any certainty. :-)
It is sort of odd, though, that x = NULL returns something wh
Joe writes:
> Is there a query I can run to change the next autoindex to the next highest
> integer in the column.
>
> I mean I have my userIDs, and they are autoincrementing. But if I have say
> 9 users delete 5 of users, and then want to compact the table so that the
> ids are all sequenti
Hi, I have succesfully installed MySQL for personal use, but it doesn't
work. I know my username and pw, but what's my database server
Is it http://127.0.0.1; localhost, db.localhost.com... I don't know.
Thanks, Peter
-
B
50 matches
Mail list logo
