Hi,
I would like to know how mySQL manage the identity (auto increment counter)
in a replication environment when
2 servers are both master on the same database.
Here's a sample of my problem.
We have 2 servers running mySQL. Server1 replicate data on server2 and
server2 replicate data on server
At 17:35 -0800 12/29/02, JamesD wrote:
while Paul probably wouldnt say it, I would:
Well, I *have* been known to make shameless plugs from time to time, but
of course it's better if readers make them for me. :-) So, thanks, I
appreciate it.
his book: "MySql and Perl for the Web" ISBN 0-7357-
At 18:14 -0800 12/29/02, Frank Peavy wrote:
Any one else with any suggestions? Remember, re-compile is out of
the question, it's a hosted site.
Thanks.
If it's necessary to use FULLTEXT and not one of the other suggestions,
you're out of luck. As Egor pointed out, you do this in 3.23 by
a sourc
At 21:17 -0700 12/28/02, Mike Hillyer wrote:
I would think that using the fulltext search IN BOOLEAN MODE would return
results of any length, even 3 characters or less, check the bottom of
http://www.mysql.com/doc/en/Fulltext_Search.html for examples on using
boolean mode.
Nope. IN BOOLEAN MODE
At 21:00 -0500 12/29/02, Carlin Anderson wrote:
I have a number of databases installed under mysql 3.23 and 4.0, and
will need to occasionally re-initialize certain tables. Can I
re-set auto-increment fields within those tables?
You can drop and re-create the tables. This will work for any ta
we are all in sales, 24/7. :-)
Jim
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 29, 2002 9:24 PM
To: JamesD; Peter Lovatt; [EMAIL PROTECTED]
Subject: RE: An Idea (really: MySQL and Perl for the Web)
At 17:35 -0800 12/29/02, JamesD wrote:
>while
At 0:14 -0500 12/30/02, Philip Mak wrote:
On Sun, Dec 29, 2002 at 11:09:47PM -0600, Paul DuBois wrote:
At 5:28 -0500 12/29/02, Philip Mak wrote:
>sql, table
>
>I'm storing a SHA1 checksum as "varchar(20) binary" in my application.
Other people have addressed other aspects of your message, b
On Sun, Dec 29, 2002 at 11:09:47PM -0600, Paul DuBois wrote:
> At 5:28 -0500 12/29/02, Philip Mak wrote:
> >sql, table
> >
> >I'm storing a SHA1 checksum as "varchar(20) binary" in my application.
>
> Other people have addressed other aspects of your message, but I'm
> curious why you're using a V
At 5:28 -0500 12/29/02, Philip Mak wrote:
sql, table
I'm storing a SHA1 checksum as "varchar(20) binary" in my application.
Other people have addressed other aspects of your message, but I'm
curious why you're using a VARCHAR(20), when SHA1() returns a 40-byte
string.
After running a test, i
Thank You so much John and Michael. SHOW TABLES LIKE 'a%' worked like a
charm and was exactly what I was looking for. I guess my searches were
using the wrong keywords. Kind of figures. Some of my searches were
turning up 1000's of results.
How do you know whether it's an "active" a* table
Paul's book is an excellent one.
I also recommend (to anyone who asks):
http://froogle.google.com/froogle?q=%22SQL+For+Dummies%22&btnG=Froogle+Searc
h
and
http://froogle.google.com/froogle?q=%22SQL+For+Smarties%22&btnG=Froogle+Sear
ch
2 more excellent resources.
*
* Cal Evans
* The Virtual CIO
Hi
I think the two would serve different purposes. Paul's book is a best friend
but.
It may take 2-3 days to get a copy (unless you live in a good technical
bookshop) and often people want an answer now.
Although it's good value, not everyone (casual users, students, newbies
making their fir
Just think, one more click and you wouldn't have had to send an e-mail.
http://www.mysql.com/downloads/mysql-max-4.0.html
http://www.mysql.com/downloads/mysql-standard-4.0.html
Richard.
- Original Message -
From: "Ray Kiddy" <[EMAIL PROTECTED]>
To: "Lenz Grimmer" <[EMAIL PROTECTE
Any one else with any suggestions? Remember, re-compile is out of the
question, it's a hosted site.
Thanks.
At 10:49 PM 12/28/02 -0700, Mike Hillyer wrote:
He wants to execute a FULLTEXT search as opposed to a simple LIKE statement,
so I think REGEXP is out of the question.
Mike Hillyer
-
I have a number of databases installed under mysql 3.23 and 4.0, and will need to
occasionally re-initialize certain tables. Can I re-set auto-increment fields within
those tables?
Thanks
Carlin Anderson
-
Before posting, ple
I have researched this and can't find an answer. Maybe I am just looking
in the wrong places or not putting the correct keywords into the search
engines. So any help would be greatly appreciated. I am using MySQL with PHP.
I have some PHP scripts that create tables in a database that are mea
while Paul probably wouldnt say it, I would:
his book: "MySql and Perl for the Web" ISBN 0-7357-1054-6 "New Riders
Publishing"
answers the questions you are getting at below, and
IMHO the book is excellent as a "how do i get started..." and more...
$44.99 SRP - a low cost compared to the 'deep b
What does it mean when you say: "MySQL 4.0.7 is released" and then you
give a URL? When one goes to the URL, one sees text which says "the
latest version is 4.0.5".
So, is 4.0.7 released or is it not?
If so, why do you not point to pages on the web site which actually
include the release w
Hi
My first thought was that the docs on mysql.com should do the job, but,
although they answer most technical questions, often more down to earth
stuff like 'How do I store images' or 'how do I get started with SQL' isn't
there, or it is difficult to find.
The other problem is that the documenta
>Description:
I have installed in my PC the distribution for use Berkeley data bases, and
when i try to execute the mysql server, it fails, and in data directory
there isn't the errors log file
>How-To-Repeat:
Only execute
>Fix:
>Submitter-Id: [EMAIL PROTE
Hello.
On Sun 2002-12-29 at 21:40:22 +0300, [EMAIL PROTECTED] wrote:
> > tell me please where i need write my question about InnoDB in MySQL ?
This mailing list is fine for questions about InnoDB. But your
question is not a MySQL problem, but a misunderstanding about PHP and
Web pages in general
Pikasz,
> >...then appear the next error and I don't understand why:
> >Fatal error: Call to undefined function: mysql_connect() in
> >/var/www/html/vk/vk.php on line 11
Looks like MySQL has not been enabled in your PHP installation. Check
with phpinfo() to find out.
Regards,
--
Stefan Hinz <[
Cal, Paul, dear list,
thank you, Cal, for your wise words ...
> "Here's the FAQ we developed so you don't have to waste our time
asking
> questions that have already been answered."
Go to MySQL.com and type "FAQ" in the search box. This will provide 71
results, some of them with valuable FAQ-lik
Andrew,
> > If i use code at PHP IN ONE PAGE - that uses like :
> > SET COMMIT
[snip]
> > All Actions - work OK - COMMIT & ROLLBACK
> > But if i try use every Insert at defferent page (php)
[snip]
> > p1.php - has
> > SET COMMIT;
> > INSERT 1
> >
> > {go to p2.php}
> > INSERT 1
> > ROLLBA
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Benjamin, et al --
...and then Benjamin Pflugmann said...
%
% Hi.
%
% On Sat 2002-12-28 at 08:15:58 -0500, [EMAIL PROTECTED] wrote:
% [...]
% > create table schedule
% > (
% > # ID number
% > id smallint not null default 0 auto_increment
Hi,
For sure all this happend because of MYODBC.This automation error can
occur when OLE is not able to handled some data/pointers or pointers
to interfaceses which must be transfered to VB,VBA,VBS...etc.
For example : if you wish to transform some char* to UNICODE and in
the new UNICODE dat
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Benjamin, et al --
Thanks for all of the help and info. Lots to learn and read :-)
...and then Benjamin Pflugmann said...
%
...
%
% And you have variables. If the above wouldn't work you could write:
%
% SELECT @card_hash := hash FROM ccard WHE
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
databarn --
...and then databarn said...
%
% Folk,
%
% ... MicroWeb, ...
%
% Anyone know of anything else that might do the job, ...
I echo the sentiment of others that you may not really need all of this
on a CD. However, there is a perl httpd t
1. This is a PHP syntax question.
2. The PHP manual gives a specific example in the MySQL Functions.
$link = mysql_connect("localhost", "webuser", "webpass")
Doug
On Sun, 29 Dec 2002 20:11:14 +0200, Pikasz Gyorgy wrote:
>Hi all!!!
>Red Hat 7.3, MySQL, PHP
>I tried to connect to My
This means that the mod for mySQL is not installed. On the CD there is a
package for PHP-MySQL.
install that and then restart. Hope this helps.
- Original Message -
From: "Pikasz Gyorgy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, December 29, 2002 1:11 PM
Subject: Fatal
On Sat, 28 Dec 2002 15:40:37 -0500, Richard Nagle wrote:
> try to get back into mysql, no luck
> can see mysqld is still running.
>
> how does one get back in ?
At the prompt, type:
mysql -u root -p
And you will be prompted for the password to your mysql root-account.
That's it.
~/j
--
//
Hello mysql,
> tell me please where i need write my question about InnoDB in MySQL ?
> I was instaled on Linux Debian
> MySQL 3.23.53-log
> with InnoDN Tables.
>
> If i use code at PHP IN ONE PAGE - that uses like :
>
> SET COMMIT
>
> INSERT ...1
> INSERT ...2
> ...
> COMMIT / ROLLBACK
>
> Al
Hi.
On Sat 2002-12-28 at 08:15:58 -0500, [EMAIL PROTECTED] wrote:
[...]
> create table schedule
> (
> # ID number
> id smallint not null default 0 auto_increment primary key ,
> client smallint , # references client.id
> class smallint , # references classtypes.id
> place
I would try storing the SHA1() result as a hexadecimal string.
Adolfo
> -Original Message-
> From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, December 29, 2002 7:35 AM
> To: Philip Mak
> Cc: [EMAIL PROTECTED]
> Subject: Re: Storing a SHA1 checksum
>
>
> On Sun 2002-1
On Sat 2002-12-28 at 05:05:45 -0500, [EMAIL PROTECTED] wrote:
> ...and then Benjamin Pflugmann said...
[...]
> % If you choose to go the SQL route, have a look at TEMPORARY TABLES,
> % CREATE TABLE ... SELECT and INSERT ... SELECT. Don't forget that you
>
> You mean a CREATE TABLE command that ha
At 11:38 AM 12/29/2002 -0600, databarn wrote:
> Wouldn't it make more sense for your friend to design a flash based Demo
> CD, then have links to the sites on the web?
No. The purpose of the CD is to let people see the products w/o net access.
> It seems to be a bit excessive to run a HTTP Dae
Hi,
Have you tried passing a string value of the date? MySQL accepts dates in
-MM-DD format instead of Microsoft's standard value... maybe it'll work
if you concatanate the values manually? It's a wild guess : )
At 01:24 AM 12/30/2002 +0800, Chien, Shih Chiang wrote:
tks, Michael
I a
Hi all!!!
Red Hat 7.3, MySQL, PHP
I tried to connect to MySQL server with my login name and password, with the
next command in my php's file:
mysql_connect("localhost", "webuser", "webpass")
In the mysql.user table exist webuser/webpass and in mysql.db table too for
an specified database.
...then
The ' is actually a ` (under the Tilda). It's a used to "quote" column
names in MySQL.
As for trapping the error... I don't think it'll do much good since the
err.description and err.source are already displayed by ASP, which is just
simply:
Microsoft VBScript runtime error '800a01fb'
An ex
On Sunday 29 December 2002 15:06, Octavian Rasnita wrote:
>
> mysql> create table aaa(id int not null unsigned, name text);
>
> Can you tell me why doesn't it work?
>
null can't be signed or unsigned.
try int unsigned not null
Regards
Georg
filter: mysql, query
--
Octavian Rasnita wrote:
> Hi all,
>
> I've tried the following SQL line in MySQL 4.05 for Windows and it told me
> that there is an error starting from "unsigned...".
>
> mysql> create table aaa(id int not null unsigned, name text);
>
> Can you tell me why doesn't it work?
>
Sure ! Your syntax
On Sun, Dec 29, 2002 at 11:43:35AM -0500, Michael She wrote:
>
>
> BTW, does MySQL have a RowNumber function?
You can use variables:
select @a := 0; select id, more, fields, @a:= @a + 1 as rownumber from whatever;
But you cannot use that number in the where part.
Good luck.
(sql, etc)
--
On Sun, Dec 29, 2002 at 04:06:39PM +0200, Octavian Rasnita wrote:
> Hi all,
>
> I've tried the following SQL line in MySQL 4.05 for Windows and it told me
> that there is an error starting from "unsigned...".
>
> mysql> create table aaa(id int not null unsigned, name text);
>
> Can you tell me w
- Original Message -
From: "Octavian Rasnita" <[EMAIL PROTECTED]>
> mysql> create table aaa(id int not null unsigned, name text);
> Can you tell me why doesn't it work?
You want:
create table aaa(id int unsigned not null, name text);
Your way doesn't work as 'unsigned' is a modification
tks, Michael
I am not sure it's mysql's problem or myODBC351's problem
But, what I am sure is
rs2("data").Value = Now
is working fine in mysql323 + myodbc351
but, err in mysql407 + myodbc351
the err msg in msgbox: Query-based update failed because the row to update
could not be found.
try:
create table aaa(id int(5) unsigned not null, name text);
not sure why but unsigned needs to come before not null.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Octavian Rasnita [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 29, 2002
Because that's the way that (FoxPro, Access, Paradox, insert name of
favorite desktop RDBMS here) did it and I can't make the jump to a real
server based RDBMS!
Why do you ask? :)
Seriously, I find this type of issue (not your question Paul, the original
question) one of the most troubling thing
I have heard of cases where there were some problems with MDAC and that
it helped to reinstall the latest version
I also think you should remove the ' from the ID in your SQL query. If
the ID field is not numeric it should be
"...WHERE ID = '" & ID & "'"
If it is numeric it should be
"...WHERE
I have heard of cases where there were some problems with MDAC and that
it helped to reinstall the latest version
Otherwise try to troubleshoot with something like :
On error resume next
..
..
..
Your problem code goes here
..
..
..
if err.number <> 0 then
Response.Write err.description & ""
At 11:26 AM 12/29/2002 +0100, =?iso-8859-2?Q?Adam_Wi=EAckowski?= wrote:
Hello,
I had a problem few days ago. I'm doing my questbook, and I were thinking
what would hapen if I delete some row. Now I know, nothing. I had one column
ID (auto_increment) in my table. I wanted it to be one by one even a
Line 45 is the Recordset open. I've checked the connection object
beforehand to ensure it is connected properly.
What is odd is that the error shows up occasionally - every 10 - 15
database queries. If I reboot my server, the error goes away, but comes
back after a few days.
At 02:43 PM
Hi all,
I've tried the following SQL line in MySQL 4.05 for Windows and it told me
that there is an error starting from "unsigned...".
mysql> create table aaa(id int not null unsigned, name text);
Can you tell me why doesn't it work?
Thank you.
Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email
You just need to snag the website once you have published it or at least
have it running on a server somewhere. The result should be standard html
no need for MySQL or PHP on the CD.
Hope this helps
Pat...
- Original Message -
From: "databarn" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL
Hi Shih Chiang,
From what I remember, MySQL 3.23 was OK with MyODBC as well. However,
with 4.06 MyODBC 2.50 AND 3.51 bomb occasionally with this error message.
At 05:37 PM 12/29/2002 +0800, Chien, Shih Chiang wrote:
Dear ALL.
I have the similar problem...
mysql 3.23 + myodbc 3.51 = OK
mys
For this to work you would have to have a web server (Apache?) with PHP
compiled in and mysql all installed on the target machine. I'm guessing the
answer is no here. HOWEVER. Not knowing your exact requirements I'm going
to blindly give advice here.
Do you really need a database and a scripting
At 11:26 +0100 12/29/02, Adam Wi´ckowski wrote:
Hello,
I had a problem few days ago. I'm doing my questbook, and I were thinking
what would hapen if I delete some row. Now I know, nothing. I had one column
ID (auto_increment) in my table. I wanted it to be one by one
Why?
even after
deleting,
Hi,
I'm able to run the following code in the jsp. But my
problem is I have multiple images in a table and would
like all of it to be display as an icon. I have tried
to put while(rs.next())... it doesn't work.
How should I go about to do it.
Thanks.
Tan
<%@ page import="java.sql.*" %>
<%@ page
On Sunday 29 December 2002 04:55, Frank Peavy wrote:
> Does anyone have a method of performing fulltext searches on words less
> than 3 characters on MySql 3.23? I am dealing with a web hosting company so
> a re-compile is out of the question.
>
> Anyone have any good suggestions? I need to perform
On Saturday 28 December 2002 10:59, Robert Citek wrote:
> Seems like I'm not alone:
> http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:52006
> On the bright side, I found an answer that pointed me somewhat in the right
> direction:
> http://www.geocrawler.com/archives/3/13/1998/11/0/56625
>
> I h
On Sunday 29 December 2002 12:26, Adam Wiêckowski wrote:
> I had a problem few days ago. I'm doing my questbook, and I were thinking
> what would hapen if I delete some row. Now I know, nothing. I had one
> column ID (auto_increment) in my table. I wanted it to be one by one even
> after deleting,
On Sunday 29 December 2002 05:38, Andreas wrote:
> Benjamin Pflugmann wrote:
> > Look up mysqldump and mysql in the manual. You want to do something
> > like this:
> >
> > targethost$ mysqladmin create new_database
> > targethost$ mysqldump -h oldhost some_database | mysql new_database
>
> at leas
Folk,
A friend has asked me to help her to create some business card CDs (with her web on
them) that she can use to promote her business. The web uses PHP, with MySQL for the
database engine . . . it hasn't been published yet, still in the throes [up] of
creation. I've found MicroWeb, which p
Benjamin, Philip,
> > 1. Use blob instead of varchar.
> >Problem: blob type is slower.
>
> Is that really a problem? Did you measure it? If so, I would be
> intersted in the results.
As the manual states: "Note that each BLOB or TEXT value is represented
internally by a separately allocated o
It seems that no one has answered yet.
Does any one know some thing about it?
With kind regards,
Richard Pijnenburg
Klik-on Internet Solutions
> -Original Message-
> From: Mike Wexler [mailto:[EMAIL PROTECTED]]
> Sent: 23 December 2002 21:48
> To: MySQL
> Subject: NPTL and MySQL
>
> Ho
Ö©ÖëÍøÍø¿¯-ÌØ¿¯ºÅ£¬»áÔ±·¢Õ¹°æ
ÒÔÏÂÄÚÈݽöÏÞÖйú´ó½µØÇø£¬ÎÄÖÐËùÉæ¼°Ö®¼ÓÃ˽ð¡£ÀÍÎñ½ðµÈ¾ùÒÔÈËÃñ±Ò¼Æ¡£
¿ªÆªÓï
ÄãÏë³É¾ÍÒ»·¬ÊôÓÚ×Ô¼ºµÄÊÂÒµÂð£¿ÄãÏë³ÉΪ21ÊÀ¼ÍµÄ±È¶û¡£¸Ç´ÄÂð£¿ÄãÏë½áÊøÂþÂþ¼¸Ê®ÄêÀ´¾¼ÃÞ׾ݡ¢¹¶ÇÒ͵ÉúµÄÈÕ×ÓÂð£¿ÄãÏë³¢ÊÔÄDZ¾Ó¦ÊôÓÚÄãÈ´ÒòÔÒòºÍÄã¾ÃÎ¥Á˵ijɹ¦Â𣿾ÍÔÚ½ñÌì--¸Ä±äÃüÔ˵Äʱ¿Ìµ
Hi,
>From what i know i think is possible if you declare(like METADATA) this
object(using UUID).
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
---
Chiang,
I can't seem to pinpoint where the problem lies, but I don't think the
".value" should be there...you may want to try this:
If Not rs2.EOF Then
rs2("data") = Now
rs2.Update
End If
Why go through all the trouble of creating a recordset to update a value?
It adds qu
I don't think so since there is no other way to create an object in ASP
VBScript
Which line is line 45 ? objConn.open or rs.open ?
Freddie
-Ursprüngliche Nachricht-
Von: Gelu Gogancea [mailto:[EMAIL PROTECTED]]
Gesendet: Sonntag, 29. Dezember 2002 12:02
An: [EMAIL PROTECTED]; Michael Sh
On Sun 2002-12-29 at 05:28:57 -0500, [EMAIL PROTECTED] wrote:
> sql, table
>
> I'm storing a SHA1 checksum as "varchar(20) binary" in my application.
>
> After running a test, it seems MySQL will strip trailing spaces from a
> varchar column, even if it is binary!
Yes, the BINARY keyword only in
Hello.
On Sun 2002-12-29 at 11:26:01 +0100, [EMAIL PROTECTED] wrote:
> Hello,
> I had a problem few days ago. I'm doing my questbook, and I were thinking
> what would hapen if I delete some row. Now I know, nothing. I had one column
> ID (auto_increment) in my table. I wanted it to be one by one e
Hi,
This is an aoutomation error and is possible to be raised because you use
CreateObject instead of using object directly.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
Matt,
I am forwarding this to MySQL developers.
> Problem description:
>
> MySQL does not return key information about any column after the first
> in a unique multi-column key. Also, the "MUL" flag seems to indicate
> that the key is non-unique, when in fact it is.
This ou
Hello!
I tried to create table with field enum and if there
is cyrillic symbol "ÿ" query passes but when i start
describe table in others fields names apperes funny
characters. If I relplace "ÿ" with "ß" åverythin is
Ok.
Can anybody give me some advice in this strange
situation?
I'm using RedHat l
sql, table
I'm storing a SHA1 checksum as "varchar(20) binary" in my application.
After running a test, it seems MySQL will strip trailing spaces from a
varchar column, even if it is binary! That means if the last character
of my SHA1 checksum happens to be a space, MySQL will corrupt it.
What s
Hello,
I had a problem few days ago. I'm doing my questbook, and I were thinking
what would hapen if I delete some row. Now I know, nothing. I had one column
ID (auto_increment) in my table. I wanted it to be one by one even after
deleting, so I changed it by myself. But then (after deleting the la
75 matches
Mail list logo
