date:20021229

An Idea

2002-12-29 Thread Adam Wickowski

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 last ID
was 17, and before 32), next ID was 33, not 18. Is there any function, which
can change it? If not, mayby you'll try to do something like that. It's
right, I can do it by myself not using auto_increment, and giving the ID
number MAX(ID)+1, but if there is such function it would be realy fine.
Greatings,
MySQL user

Adam Wickowski
GG# :1257924



***r-e-k-l-a-m-a**

Masz do pacenia prowizji bankowi ?
mBank - za konto
http://epieniadze.onet.pl/mbank 

-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Storing a SHA1 checksum

2002-12-29 Thread Philip Mak

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 should I do? It seems I can:

1. Use blob instead of varchar.
   Problem: blob type is slower.

2. Make my application pad the checksum out to 20 spaces.
   Problem: Increases my code complexity a bit.

3. Wait for MySQL to fix the strip trailing spaces bug.
   Problem: That doesn't provide an immediate solution.

-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Problem with enum and cyrillic symbol 'ÿ'

2002-12-29 Thread Konstantin Yotov

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 linux 7.3 with mysql 3.23.49 

Kosyo

__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Bug report: UNIQUE KEY and DESCRIBE TABLE

2002-12-29 Thread Heikki Tuuri

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 output format of DESCRIBE TABLE has been discussed before. It is not
easily understandable, though the above is what Monty intended it to be.

I recommend using

SHOW CREATE TABLE tablename;

to look at a table structure. It contains the foreign key definitions and
all. DESCRIBE TABLE does not contain all information.

Regards,

Heikki

- Original Message -
From: Matt Solnit [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: Henry Bequet [EMAIL PROTECTED]
Sent: Saturday, December 28, 2002 2:44 AM
Subject: Bug report: UNIQUE KEY and DESCRIBE TABLE


===
Bug report -- MySQL v4.06, binary distribution
===

--
Machine specs:
--
Compaq Presario desktop
512 MB RAM
Windows XP Professional SP1


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.

There is an equivalent symptom in the MySQL C API.  In the flags field
of the MYSQL_FIELD structure returned by mysql_fetch_field(), the
MULTIPLE_KEY_FLAG will only be present in the first column.

-
Test script:
-
mysqlUSE test
mysqlCREATE TABLE mytable (a INT NOT NULL, b INT NOT NULL, c INT NOT
NULL, d INT NOT NULL, PRIMARY KEY (a), UNIQUE KEY (b, c));
mysqlDESCRIBE TABLE mytable;

--
Results:
--
+---+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-+---+
| a | int(11) |  | PRI | 0   |   |
| b | int(11) |  | MUL | 0   |   |
| c | int(11) |  | | 0   |   |
| d | int(11) |  | | 0   |   |
+---+-+--+-+-+---+


C test program:


/***
Expected output (according to manual section 8.4.1):

Column `a`: primary=1, unique=0, multiple=0
Column `b`: primary=0, unique=1, multiple=0
Column `c`: primary=0, unique=1, multiple=0
Column `d`: primary=0, unique=0, multiple=0

Actual output:

Column `a`: primary=1, unique=0, multiple=0
Column `b`: primary=0, unique=0, multiple=1
Column `c`: primary=0, unique=0, multiple=0
Column `d`: primary=0, unique=0, multiple=0
***/

#include stdafx.h
#include winsock.h
#include mysql.h
#include stdarg.h
#include stdio.h
#include stdlib.h

MYSQL *db_connect(const char *dbname);
void db_disconnect(MYSQL *db);
void db_do_query(MYSQL *db, const char *query);

const char *server_groups[] = {
  test_libmysqld_SERVER, embedded, server, NULL
};

int main(int argc, char* argv[])
{
  MYSQL *one;

  mysql_server_init(argc, argv, (char **)server_groups);
  one = db_connect(test);

  const char* query = SELECT * FROM mytable;
  mysql_query(one, query);
  MYSQL_RES* res = mysql_store_result(one);
  int numFields = mysql_num_fields(res);
  for (int i = 0; i  numFields; i++)
  {
MYSQL_FIELD* fld = mysql_fetch_field(res);
char* name = strdup(fld-name);
bool isPrimary = ((fld-flags  PRI_KEY_FLAG)  0);
bool isUnique = ((fld-flags  UNIQUE_KEY_FLAG)  0);
bool isMulti = ((fld-flags  MULTIPLE_KEY_FLAG)  0);
printf(column `%s`: primary=%d, unique=%d, multiple=%d\n, name,
isPrimary, isUnique, isMulti);
  }

  mysql_close(one);
  mysql_server_end();

  return 0;
}

static void
die(MYSQL *db, char *fmt, ...)
{
  va_list ap;
  va_start(ap, fmt);
  vfprintf(stderr, fmt, ap);
  va_end(ap);
  (void)putc('\n', stderr);
  if (db)
db_disconnect(db);
  exit(EXIT_FAILURE);
}

MYSQL *
db_connect(const char *dbname)
{
  MYSQL *db = mysql_init(NULL);
  if (!db)
die(db, mysql_init failed: no memory);
  /*
   * Notice that the client and server use separate group names.
   * This is critical, because the server will not accept the
   * client's options, and vice versa.
   */
  mysql_options(db, MYSQL_READ_DEFAULT_GROUP, test_libmysqld_CLIENT);
  if (!mysql_real_connect(db, NULL, NULL, NULL, dbname, 0, NULL, 0))
die(db, mysql_real_connect failed: %s, mysql_error(db));

  return db;
}

void
db_disconnect(MYSQL *db)
{
  mysql_close(db);
}

---
My contact information:
---
Matt Solnit [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,

Re: ADO Error '800a01fb'

2002-12-29 Thread Gelu Gogancea

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]
  [EMAIL PROTECTED]
- Original Message -
From: Michael She [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, December 28, 2002 7:57 AM
Subject: ADO Error '800a01fb'


 Hi all,

 I'm getting this error with MyODBC v2.50 and v3.51.  I'm running MySQL
v4.06:

 Microsoft VBScript runtime error '800a01fb'

 An exception occurred: 'open'

 /mshe/gallery/picture.asp, line 45


 The code for that area is:

 strConn = DSN=binaryio;
 Set objConn = Server.CreateObject(ADODB.Connection)
 objConn.open strConn

 set rs = server.createobject(adodb.recordset)
 strSQL = SELECT * FROM IMAGES WHERE `ID` =   ID
 rs.open strSQL, objConn, 3,1,1

 Nothing out of the ordinary... anyone know why I'm getting this error?
Thanks!
 --
 Michael She  : [EMAIL PROTECTED]
 Mobile   : (519) 589-7309
 WWW Homepage : http://www.binaryio.com/



 -
 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, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: An Idea

2002-12-29 Thread Benjamin Pflugmann

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 even after
 deleting, so I changed it by myself. But then (after deleting the last ID
 was 17, and before 32), next ID was 33, not 18. Is there any function, which
 can change it? If not, mayby you'll try to do something like that. It's
 right, I can do it by myself not using auto_increment, and giving the ID
 number MAX(ID)+1, but if there is such function it would be realy fine.

What you describe was the behaviour in older MySQL versions and it has
been changed because primary keys should never be reused. Never.

If you need it to have no holes, you are abusing the primary key for
something which it is not intended for (visible entry numbering?).

So, yes, you have to either implement it yourself, or, what I would
recommend, have a seperate column for it or calculate it in your
application, whatever makes most sense for your use.

HTH,

Benjamin.


PS: AFAIK, InnoDB still has the old behaviour. Anyhow, it will
change soon enough.


-- 
[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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Storing a SHA1 checksum

2002-12-29 Thread Benjamin Pflugmann

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 influences how comparisons are done
(mainly case-sensivity, but also umlauts, etc...).

Stripping space from VARCHAR is a known deficiency:

  http://www.mysql.com/doc/en/Bugs.html

It also mentions, that the TEXT/BLOB types are save from it.

 That means if the last character of my SHA1 checksum happens to be a
 space, MySQL will corrupt it.
 
 What should I do? It seems I can:
 
 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.

 Advantage: Other application programmers do not need to be aware
 of the hack. After MySQL is fixed, the source doesn't contain
 redundant code.

 2. Make my application pad the checksum out to 20 spaces.
Problem: Increases my code complexity a bit.
 Advantage: Doesn't affect performance (noticeably). The DBA
 doesn't need to be aware of the hack.

 3. Wait for MySQL to fix the strip trailing spaces bug.
Problem: That doesn't provide an immediate solution.

4. Append a non-space at the end, and ignore it on retrieval
   Problem: Same as 2.
   Although 2. looks like the prettier solution, 4. makes easier to
   spot the problem, if the additional handling is forgotten in new
   code.

Well, what you should do? It depends on what you need. It's a
trade-off and no one except you can answer what your priorities are.

If, for example, you have many applications / programmers who access
this stuff, 1. is least intrusive. OTOH, if it is used only in one
place, perhaps in a well-encapsulated object, 2. is the least
intrusive change. And someone (that includes yourself in 1 year)
looking at your SQL dump wouldn't know why you have chosen a BLOB,
while you can have a neat comment in the source about it.

Since any of the solutions involves only minor changes, I would not
bother to waste time on the decision. Simply go with one and rewrite
if it really turns out to become a problem later (which I don't
believe).

HTH,

Benjamin.

-- 
[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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

AW: ADO Error '800a01fb'

2002-12-29 Thread Freddie Sorensen

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 She
Cc: [EMAIL PROTECTED]
Betreff: Re: ADO Error '800a01fb'


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]
  [EMAIL PROTECTED]
- Original Message -
From: Michael She [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, December 28, 2002 7:57 AM
Subject: ADO Error '800a01fb'


 Hi all,

 I'm getting this error with MyODBC v2.50 and v3.51.  I'm running MySQL
v4.06:

 Microsoft VBScript runtime error '800a01fb'

 An exception occurred: 'open'

 /mshe/gallery/picture.asp, line 45


 The code for that area is:

 strConn = DSN=binaryio;
 Set objConn = Server.CreateObject(ADODB.Connection)
 objConn.open strConn

 set rs = server.createobject(adodb.recordset)
 strSQL = SELECT * FROM IMAGES WHERE `ID` =   ID
 rs.open strSQL, objConn, 3,1,1

 Nothing out of the ordinary... anyone know why I'm getting this error?
Thanks!
 --
 Michael She  : [EMAIL PROTECTED]
 Mobile   : (519) 589-7309
 WWW Homepage : http://www.binaryio.com/



 -
 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, e-mail 
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/products/myodbc/manual_toc.html (the manual)
   http://lists.mysql.com/(the list archive)

To unsubscribe, e-mail [EMAIL PROTECTED]
To unsubscribe from Yahoo! Groups version, e-mail
[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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: ADO Error '800a01fb'

2002-12-29 Thread jumpmaster

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 quite abit of overhead...you can use the connection object  to
accomplish the same.  Try this:

strSQL = DRIVER={MySQL ODBC 3.51
Driver};SERVER=localhost;DATABASE=test;USER=root;PASSWORD=root;OPTION=35;

Set Cn1 = CreateObject(ADODB.Connection)
Cn1.Open strSQL
strSQL1 = UPDATE mytable SET data = '  Now()  ' WHERE pkey = 
 1
Cn1.Execute(strSQL1)

Of course, by changing the strSQL1 statement, you can Add and Delete records
from the database also.

HTH,
Kurt

-Original Message-
From: Chien, Shih Chiang [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 29, 2002 10:37 AM
To: jumpmaster; Michael She; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: ADO Error '800a01fb'



Dear ALL.

I have the similar problem...

mysql 3.23 + myodbc 3.51 = OK
mysql 4.07 + myodbc 3.51 = Error

the code list is :


-

strSQL = DRIVER={MySQL ODBC 3.51
Driver};SERVER=localhost;DATABASE=test;USER=root;PASSWORD=root;OPTION=35;

Set Cn1 = CreateObject(ADODB.Connection)
Cn1.Open strSQL
strSQL1 = select * from mytable where pkey =   1
Set rs2 = CreateObject(ADODB.Recordset)
rs2.Open strSQL1, Cn1, 1, 3

If Not rs2.EOF Then
rs2(data).Value = Now
rs2.Update '  Error Line Reported.
##
End If

rs2.Close
Cn1.Close
Set rs2 = Nothing
Set Cn1 = Nothing


-

pls see the attached file for more error msg... tks.

Chiang



- Original Message -
From: jumpmaster [EMAIL PROTECTED]
To: Michael She [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, December 29, 2002 7:39 AM
Subject: RE: ADO Error '800a01fb'


 Michael,

 My guess (and this is *only a guess*) -- for some reason one of the
objects
 is not being created; maybe the recordset object.  I am not sure where you
 are getting that error number from (presumably in you browser) as you do
not
 state it.  i suggest that you check your webserver logs if you have access
 to them.  They might have an extended error message which will pinpoint
your
 problem.

 Also, you can try to 'trap' the error.  I found this tid-bit on the M$
 site...


 On error resume next
 ..
 ..
 ..
 Your problem code goes here
 ..
 ..
 ..
 if err.number  0 then
 Response.Write err.description  BR  err.source  BR
 err.clear
 end if


 Here is the link where I found it:
 http://support.microsoft.com/default.aspx?scid=kb;en-us;299981#7


 One last note...the reason I think it is your recordset object is because
of
 your query...You use single quotes in the wrong place.  Your strSQL
variable
 should be defined as follows:

 strSQL = SELECT * FROM IMAGES WHERE ID = '  ID  '

 Or - if ID is numeric then:

 strSQL = SELECT * FROM IMAGES WHERE ID =   ID

 HTH,
 Kurt

 -Original Message-
 From: Michael She [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, December 28, 2002 6:57 AM
 To: [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Subject: ADO Error '800a01fb'


 Hi all,

 I'm getting this error with MyODBC v2.50 and v3.51.  I'm running MySQL
 v4.06:

 Microsoft VBScript runtime error '800a01fb'

 An exception occurred: 'open'

 /mshe/gallery/picture.asp, line 45


 The code for that area is:

 strConn = DSN=binaryio;
 Set objConn = Server.CreateObject(ADODB.Connection)
 objConn.open strConn

 set rs = server.createobject(adodb.recordset)
 strSQL = SELECT * FROM IMAGES WHERE `ID` =   ID
 rs.open strSQL, objConn, 3,1,1

 Nothing out of the ordinary... anyone know why I'm getting this error?
 Thanks!
 --
 Michael She  : [EMAIL PROTECTED]
 Mobile   : (519) 589-7309
 WWW Homepage : http://www.binaryio.com/



 -
 Before posting, please check:
http://www.mysql.com/products/myodbc/manual_toc.html (the manual)
http://lists.mysql.com/(the list archive)

 To unsubscribe, e-mail [EMAIL PROTECTED]
 To unsubscribe from Yahoo! Groups version, e-mail
 [EMAIL PROTECTED]


 -
 Before posting, please check:
http://www.mysql.com/products/myodbc/manual_toc.html (the manual)
http://lists.mysql.com/(the list archive)

 To unsubscribe, e-mail [EMAIL PROTECTED]
 To unsubscribe from Yahoo! Groups version, e-mail
[EMAIL PROTECTED]




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/

Re: ADO Error '800a01fb'

2002-12-29 Thread Gelu Gogancea

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]
- Original Message -
From: Freddie Sorensen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, December 29, 2002 1:35 PM
Subject: AW: ADO Error '800a01fb'


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 She
Cc: [EMAIL PROTECTED]
Betreff: Re: ADO Error '800a01fb'


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]
  [EMAIL PROTECTED]
- Original Message -
From: Michael She [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, December 28, 2002 7:57 AM
Subject: ADO Error '800a01fb'


 Hi all,

 I'm getting this error with MyODBC v2.50 and v3.51.  I'm running MySQL
v4.06:

 Microsoft VBScript runtime error '800a01fb'

 An exception occurred: 'open'

 /mshe/gallery/picture.asp, line 45


 The code for that area is:

 strConn = DSN=binaryio;
 Set objConn = Server.CreateObject(ADODB.Connection)
 objConn.open strConn

 set rs = server.createobject(adodb.recordset)
 strSQL = SELECT * FROM IMAGES WHERE `ID` =   ID
 rs.open strSQL, objConn, 3,1,1

 Nothing out of the ordinary... anyone know why I'm getting this error?
Thanks!
 --
 Michael She  : [EMAIL PROTECTED]
 Mobile   : (519) 589-7309
 WWW Homepage : http://www.binaryio.com/



 -
 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, e-mail
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/products/myodbc/manual_toc.html (the manual)
   http://lists.mysql.com/(the list archive)

To unsubscribe, e-mail [EMAIL PROTECTED]
To unsubscribe from Yahoo! Groups version, e-mail
[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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Äã21ÊÀ¼ÍµÄ·¢Õ¹»ú»á

2002-12-29 Thread cnyl

Ö©ÖëÍøÍø¿¯-ÌØ¿¯ºÅ£¬»áÔ±·¢Õ¹°æ
  ÒÔÏÂÄÚÈÝ½öÏÞÖÐ¹ú´óÂ½µØÇø£¬ÎÄÖÐËùÉæ¼°Ö®¼ÓÃË½ð¡£ÀÍÎñ½ðµÈ¾ùÒÔÈËÃñ±Ò¼Æ¡£

¿ªÆªÓï

ÄãÏë³É¾ÍÒ»·¬ÊôÓÚ×Ô¼ºµÄÊÂÒµÂð£¿ÄãÏë³ÉÎª21ÊÀ¼ÍµÄ±È¶û¡£¸Ç´ÄÂð£¿ÄãÏë½áÊøÂþÂþ¼¸Ê®ÄêÀ´¾¼ÃÞ×¾Ý¡¢¹¶ÇÒÍµÉúµÄÈÕ×ÓÂð£¿ÄãÏë³¢ÊÔÄÇ±¾Ó¦ÊôÓÚÄãÈ´ÒòÔÒòºÍÄã¾ÃÎ¥ÁËµÄ³É¹¦Âð£¿¾ÍÔÚ½ñÌì--¸Ä±äÃüÔËµÄÊ±¿Ìµ½À´ÁË¡£ÈÃÎÒÃÇ¸øÄã´ïµ½ÀíÏëµÄÇÅÁº£¬ÈÃÎÒÃÇ¸øÄãÔÙ´Î´´ÒµµÄÌìÌÃ¡£

µ±ÄãÕæÕý¶Á¶®£ºÎÒÃüÓÉÎÒ²»ÓÉÌì¡£Õâ¾ä»°µÄÉî³Áº¬ÒåÊ±£¬ÄãÊÇ·ñ»áÓÐ·¢×ÔÄÚÐÄµÄ¸ÐÌ¾£ºÕâÐ©ÄêÎÒ×öµÄÊµÔÚÌ«ÉÙÁË¡£ÈËÉú¼¸»Ø²«£¿³É¹¦ÕÆÎÕÔÚ×Ô¼ºµÄÊÖÖÐ¡£Õâ¸öÊÀ½çÃ»ÓÐÃüÔË£¬¼´±ãÓÐ£¬ËüÒ²»áÔÚ½ñÌìµÃµ½¸Ä±ä¡£

ÉêÇë³ÉÎªÖ©ÖëÍø»áÔ±£¬Äú½«Á¢¿ÌÓµÓÐÎÞÏÞÀ©ÕÅµÄÊµÓÃÐÅÏ¢ºÍ×Ô¼ºµÄ¼ÒÍ¥ÐÅÏ¢´úÀí¹«Ë¾£¡Õâ²»ÊÇÉñ»°£¬À´µ½Ö©ÖëÍø£¬ÈÃÒ»¸öÒÔ´´ÒµÎªÖ÷µÄÊµÁ¦ÐÛºñµÄ´óÐÍ×ÛºÏÍøÕ¾ÓëÄúÏàÔ¼£¬ÈÃÒ»ÇÐ¶¼±äµÃ·á¸»¶à²Ê¡£

ÏÖ´úÍøÂç×¬Ç®·¨ÔòÓë×îÐÂ¿Æ¼¼µÄÍêÃÀ½áºÏ--Ö©ÖëÍø--Ç¿Á¦µÇÂ½ÖÐ¹ú´óÂ½¡£Ò»¸ö¹¦ÄÜÇ¿´óµÄÍøÂç×¬Ç®Èí¼þ£¬Ê¹µÃÖ©ÖëÍøÔÚ¶Ì¶ÌµÄÈý¸öÔÂ·¢Õ¹ÁË3ÍòÓàÃû»áÔ±£¬ÆäÎüÒýÁ¦²»ÄÜÑÔ±í£ºÏµÍ³È«×Ô¶¯µÄ·ÖÅä¼ÓÃË×Ê½ð£¬È«×Ô¶¯µÄÉý¼¶£¬È«×Ô¶¯µÄ¸øÓè»Ø±¨£¬ËùÓÐµÄÒ»ÇÐÈ«²¿ÔÚµçÄÔµÄ¼à¿ØÏÂ½øÐÐ¡£Ã¿Ò»Î»²Î¼ÓÕßÔÚÓÉ£ºÁÙÊ±»áÔ±-¸ß¼¶»áÔ±-»Æ½ð»áÔ±-°×½ð»áÔ±µÄÉý¹ý¼¶³ÌÖÐ£¬Æä»Ø±¨×ãÒÔÈÃÈË¸Ðµ½Õðº³£¬²»½ö½öÈç´Ë£ºÃ¿Ò»Î»»áÔ±»¹¿ÉÒÔµÃµ½8000ÓàÆª¼ÛÖµ¼¸°ÙÍòÔªµÄ¸÷Àà»Æ½ðÐÅÏ¢¡¢Ææ·½ÃîÊõ¡¢ÖÆ¸»¾øÕÐ¡£ÆäÒý½øÇþµÀ¶ÀÁ¢£¬³£Äê²»¶Ï¸üÐÂ£¬¾ø¶Ô³¬Öµ·îÏ×¡£ÍøÕ¾ÄÚËùÓÐÈí¼þ¡¢Ó°ÊÓµÈ¸÷Àà×ÊÔ´ÈÎÒâÏíÓÐ£¬°üÄãÃ¿Ìì¾ªÏ²ÎÞÏÞ¡£

ÔÚ·¢Õ¹ÐÂ»áÔ±µÄ·½Ãæ£¬Áù´óÈ«ÐÂµÄ·¢Õ¹·¨±¦£º£±£µÇÂ¼ËÑË÷ÒýÇæ£²£µç×ÓÓÊ¼þÓªÏú£³£BBSÂÛÌ³·¢Ìù£´£·ÅÖÃÆìÖÄ¹ã¸æ£µ£ÁÄÌìÐû´«£¶-QQ¹ã²¥
 
¼ÓÉÏ´«Í³µÄÍøÂçÐû´«·½Ê½£¬Æä·´À¡ÂÊ¸ß´ï50%£¬Ëæ×ÅÍøÂçÈí¼þµÄ¼¼Êõ¸Ä½øÓë¹¦ÄÜµÄÍêÉÆ£¬ÕâÒ»±ÈÀý²»¶ÎìÉý¡£ÏÖÔÚÓÐÔ½À´Ô½¶àµÄÖÐ¹úÅóÓÑ¼ÓÈë£¬µ«ºÍÅ·ÃÀÏà±È£¬±ÈÀýÊµÔÚÌ«Ð¡£¬Õâ¾ÍËµÃ÷ÆäÖÐÔÌ²Ø×Å¾Þ´óµÄÇ±Á¦£¬Ê²Ã´¶«Î÷¶¼ÊÇÔ½Ôç½éÈëÔ½ÊÕÒæ£¬Õâ¸öÏµÍ³Ò²²»ÀýÍâ£¬ÔçÒ»µã¼ÓÈë£¬¾Í¿ìÒ»µã×¬´óÇ®¡£ÏëÖªµÀÖ©Öë¶¹ÊÇÊ²Ã´Âð£¿ÏëÖªµÀ½ðÇ®ÊÇÔõÃ´ÔÚÄã¿Ú´üÖÐÅòÕÍµÄÂð£¿¿ìµã¼ÓÈë°É£¡ÓÃÖÐ¹úÈËµÄÒ»¾äÀÏ»°À´½²£ºÒ»ÕÐÏÊ£¬³Ô±éÌì¡£ÏÖÔÚÕâÒ»¸öÊÂÒµ»¹ÔÚ·¢Õ¹µÄ³õÆÚ½×¶Î£¬Ç°¾°ÎÞÏÞµÄ¹ãÀ«¡£ÍûÃ¿Ò»Î»ÓÐÊ¶Ö®Ê¿×¥×¡ÕâÒ»¸öÄÑµÃµÄ»úÓö£¬¸Ä±ä×Ô¼ºµÄÃüÔË£¬ÈÃÎÒÃÇµÄÍøÂç¸ü×³´ó£¬ÈÃÎÒÃÇµÄÊÂÒµ¸üºêÎ°£¡

ÔÚ´Ë£¬Ö©ÖëÍøÄÚµÄÍø¹Ü¡¢³ÌÐòÔ±¡¢ËùÓÐ¹¤×÷ÈËÔ±¡¢¹ã¸æ´úÀíÉÌÒÔ¼°È«²¿µÄ»áÔ±£¬¹²Í¬Ó½ÓÄúµÄµ½À´Óë²ÎÓë£¬ÈÃÎÒÃÇÒ»Æð´´ÔìÎÞÏÞÎ°´óµÄÊÂÒµÓë¹â»ÔÎÞ±ÈµÄÇ°³Ì£¡£¡£¡£¡

Ö©ÖëÍø¼ò½é 

Ö©ÖëÍøÊÇ»¥ÁªÍø·¢Õ¹ÖÐ³öÏÖµÄÒ»ÖÖÐÂÐÍ»¥ÖúÍøÕ¾ÁªÃË£¬¾ø¶ÔÖÐÎÄ°æ¡£½¨Á¢ÓÚ2002Äê1ÔÂ25ÈÕ£¬ÎÒÃÇÍÆÏú×Ô¼ºµÄÊµÓÃÐÅÏ¢²úÆ·£¬Ìá¹©ÐÅÏ¢·¢²¼Æ½Ì¨£¬Ìá¹©»áÔ±´´ÒµµÄ»ú»á,»¹ÓÐ¸ü¶àÈí¼þ¿É¹©»áÔ±ÏÂÔØ¡£ÊµÓÃÐÅÏ¢¿â²»¶ÏÔÚÔö¼ÓÊµÓÃÐÅÏ¢£¬Æä¼ÛÖµÔ¶Ô¶³¬¹ýÁË80Ôª¡£ÐÅÏ¢·¢²¼Æ½Ì¨¸øËùÓÐ¸ß¼¶»áÔ±Ìá¹©ÁËÒ»¸ö·¢²¼×Ô¼ºÐÅÏ¢µÄ»ú»á£¬Ã¿Ìì¼¸Ê®ÍòµÄ·ÃÎÊÁ¿£¬ÏàÐÅ»á²úÉúÒâÍâµÄÐû´«Ð§¹û¡£×îÖØÒªµÄÊÇÎÒÃÇÎªËùÓÐ»áÔ±Ìá¹©ÁË´´Òµ×¬Ç®µÄ»ú»á¡£

Ö©ÖëÍøÊÇÒ»¸öÒÔÐÅÏ¢´úÀíÎªÖÐÐÄ£¬Ìá¹©¸÷ÖÖ»áÔ±·þÎñµÄ´úÀíÁªÃË¡£×¢²á³ÉÎªÎÒÃÇµÄ»áÔ±£¬²¢ÇÒ¸¶·ÑÉý¼¶£¬Äú¾Í¿ÉÒÔ»ñµÃÎÒÃÇÕ¾µãÌá¹©µÄ¸÷ÀàÐÅÏ¢ÒÔ¼°¸÷ÖÖÆäËû·þÎñ:±ÈÈçÈí¼þÏÂÔØ¡¢ÐÅÏ¢·¢²¼¡¢´´Òµ×¬Ç®µÈ¡£
¡¡  
´´Òµ×¬Ç®ÏàÐÅÊÇ´ó¼Ò×îÎª¹Ø×¢µÄ£¬ÒÀ¿¿ÍøÂçµÄÁ¦Á¿£¬ÒÀ¿¿´ó¼ÒµÄÁ¦Á¿£¬È¥ÍÆ¹ãÎÒÃÇÌá¹©µÄ·þÎñ£¬²¢ÇÒ»ñµÃ×Ô¼ºÓ¦¸Ã»ñµÃµÄ±¨³ê£¬Õâ¾ÍÊÇÎÒÃÇÕâ¸öÏµÍ³µÄÔË×÷Ä£Ê½¡£
ÄãµÄ¼ÓÈëÖ»ÐèÒª¸¶³ö²»¶àµÄ£¸£°ÔªÇ®£¬Äã¾Í¿ÉÒÔ»ñµÃÎÞÊýµÄÊµÓÃÐÅÏ¢¡¢¾«Æ·Èí¼þ¡¢ÐÅÏ¢·¢²¼¹¦ÄÜ¡£¶øÄãÖ»ÐèÒª·¢Õ¹ÇøÇø¼¸¸ö»áÔ±£¬Äã¾Í¿ÉÒÔÊÕ»ØÄãµÄÍ¶Èë¡£µ±ÄãÍ¨¹ýÅ¬Á¦³ÉÎª°×½ð»áÔ±µÄÊ±ºò£¬Ã¿·¢Õ¹Ò»¸ö»áÔ±¾Í¿ÉÒÔ»ñµÃ£¶£°ÔªµÄ±¨³ê¡£¶øÍ¨¹ýÖ©ÖëÍø»ñµÃÃÎÃÂÒÔÇóµÄ300ÍòÒ²¾ø¶Ô²»ÊÇÉñ»°¡£

ÎÒÃÇµÄÍÅ¶Ó

Ö©ÖëÍø¹ÜÀíÍÅ¶ÓÄ¿Ç°ÓÉ6ÈËÐ¡×é×é³É£¬Ã¿¸öÈË¶¼ÊÇÈÈÑªÇàÄê£¬ÎªÁË´´ÔìÖÐ¹úµÄÍøÂçÆæ¼£¶øÅ¬Á¦¡£¶øÇÒÎÒÃÇÒ»Ö±ÒÔÀ´¶¼ÒÔ»áÔ±µÄÀûÒæ¸ßÓÚÒ»ÇÐÎª×ÚÖ¼£¬¾ø¶Ô²»ÔÊÐíËðº¦»áÔ±µÄÕýµ±ÀûÒæ¡£

ÎÒÃÇµÄ×ÚÖ¼
»áÔ±µÄÀûÒæ¸ßÓÚÒ»ÇÐ!

   ÎÒÃÇµÄÌØµã
  ÎÈ¶¨¸ßÐ§¡¢¹«Æ½ºÏÀí¡¢Ãâ·Ñ¼ÓÈë¡¢¸¶·ÑÉý¼¶¡¢ÓÐ¾Þ´ó·¢Õ¹Ç±Á¦¡¢ÐÂµÄ·þÎñÏîÄ¿ÕýÔÚ²»¶ÏÑÐ·¢!

ÓÃ»§·þÎñÐÅÏä£º[EMAIL PROTECTED]
ÓÃ»§Í¶ËßÐÅÏä£º[EMAIL PROTECTED]

»áÔ±ÖÆ¼°´óÌåÔË×÷·½·¨
  ÎÒÃÇµÄÍøÂçÏµÍ³·ÖÎªËÄÀà»áÔ±£º1.ÁÙÊ±»áÔ± 2.¸ß¼¶»áÔ± 3.»Æ½ð»áÔ± 
4.°×½ð»áÔ±¡£ÆäÖÐ¸ß¼¶»áÔ±¡¢»Æ½ð»áÔ±ºÍ°×½ð»áÔ±¿ÉÒÔÏíÊÜÎÒÃÇÌá¹©µÄÐÅÏ¢·þÎñ£¬´ÓÖÐ»ñÈ¡¼«´óÀûÈó¡£ËÄÀà»áÔ±Çø±ðÈçÏÂ£º
ÁÙÊ±»áÔ±£º
  ÔÚÍøÕ¾ http://www.cnyilang.com 
ÖÐ×¢²á£¬ÌîÐ´Ò»Ð©ºÍ×Ô¼ºÏà¹ØµÄ¼òµ¥×ÊÁÏ£¬±ÈÈç£ºÐÕÃû¡¢ÄêÁäµÈ£¬¼´¿É³ÉÎªÁÙÊ±»áÔ±¡£ÍøÂçÏµÍ³·ÖÅä¸øÁÙÊ±»áÔ±Ò»¸öÕÊºÅ£¬¸½´øÒ»¸öÃÜÂë¡£ÓÃÕâÒ»ÕÊºÅºÍÃÜÂëµÇÂ½ÍøÕ¾£¬ÁÙÊ±»á¿ÉÒÔ¿´µ½Ò»¸öÁÙÊ±»áÔ±½çÃæ£¨Ïàµ±ÓÚÒ»¸öÍøÒ³£©¡£ÔÚÕâÒ»¸ö½çÃæµ±ÖÐ£¬ÁÙÊ±»áÔ±¿ÉÒÔµÃµ½Éý¼¶Îª¸ß¼¶»áÔ±µÄ·½·¨£º¼´Ïò½çÃæÖÐ¸ø³öµÄ¼¸¸ö²»Í¬µÄ¸¶·ÑµØÖ·¸¶·Ñ£¬×Ü·ÑÓÃÎª80ÔªÕû¡£ÓÐÁ½ÖÖ¸¶·Ñ·½·¨¹©Ñ¡Ôñ£º1.ÓÊÕþ»ã¿î
 
2.ÒøÐÐµç×Ó»ã¿î¡£¸¶·Ñºó£¬ÁÙÊ±»áÔ±ÔÚ½çÃæÖÐÌîÐ´¸¶·ÑÈ·ÈÏµ¥£¬µÃµ½ÍøÂçÏµÍ³È·ÈÏºó£¬ÂíÉÏ¿ÉÒÔÉý¼¶Îª¸ß¼¶»áÔ±¡£×¢£ºÁÙÊ±»áÔ±½çÃæÖ»±£Áô2¸öÔÂ£¬ÔÚÕâ2¸öÔÂÄÚÄã¿ÉÒÔ´Ó½çÃæÖÐ»ñµÃÏêÏ¸µÄ°ïÖú£¬2¸öÔÂºó½çÃæ×Ô¶¯Ïû³ý¡£Ò²¾ÍÊÇËµ£º´ÓÉêÇëÎªÁÙÊ±»áÔ±Æð£¬ÐèÒªÔÚ2¸öÔÂÄÚÉý¼¶Îª¸ß¼¶»áÔ±¡£
   
   ¸ß¼¶»áÔ±£º
 
ÁÙÊ±»áÔ±¸¶·Ñ²¢¾ÍøÂçÏµÍ³È·ÈÏ×Ô¶¯Éý¼¶Îª¸ß¼¶»áÔ±¡£¸ß¼¶»áÔ±Ã¿·¢Õ¹Ò»ÃûÐÂµÄ¸ß¼¶»áÔ±¿É»ñµÃÖ©Öë¶¹£¨ºóÓÐÏêÏ¸½éÉÜ£©Ò»Á££»ÀÍÎñ½ð20Ôª¡£ÓÉÏµÍ³×Ô¶¯¼ÇÔØÓë·ÖÅä£¬²¢Ö§³ÖËÄ¼¶½á¹¹¡££¨ÓÉÄãÒÔÏÂËÄ¼¶¸ß¼¶»áÔ±Ã¿·¢Õ¹Ò»ÃûÐÂµÄ¸ß¼¶»áÔ±Äã¶¼¿ÉÒÔ»ñÈ¡ÀÍÎñ½ð20Ôª£¬ÆäÔÀíÓë´«Í³ÉýÎ»ÍøÂç´óÌåÒ»ÖÂ£¬²»Í¬µÄÊÇÀÍÎñ½ðµÄ·ÖÅäÊµÏÖÁË×Ô¶¯»¯£¬ÓÉÈí¼þÀ´´¦Àí¡¢Ö´ÐÐ£¬ÎÞÐëÈË¹¤¸ÉÔ¤¡££©

RE: NPTL and MySQL

2002-12-29 Thread Richard Pijnenburg

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
 
 How will NPTL (http://people.redhat.com/drepper/nptl-design.pdf)
effect
 MySQL?
 Will MySQL break when linked against glibc 2.3.1 which has NPTL built
in?
 Will MySQL be able to take advantage of NPTL to allow more threads on
 Linux systems.
 
 
 
 -
 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, e-mail mysql-unsubscribe-
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Storing a SHA1 checksum

2002-12-29 Thread Stefan Hinz, iConnect \(Berlin\)

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 object. This is in contrast to all
other column types, for which storage is allocated once per column when
the table is opened. (http://www.mysql.com/doc/en/BLOB.html) Reading
between the lines, I would assume using BLOB or TEXT will affect
performance.

To cite once more: There is no trailing-space removal for BLOB and TEXT
columns when values are stored, as there is for VARCHAR columns. So, a
solution would be to use TINYTEXT which can take up to 255 bytes.

To not only cite :) I performed this little test with MySQL 4.0.3 on a
slow Win2K box with InnoDB tables:

mysql DESCRIBE text_tinytext; DESCRIBE text_varchar;
+---+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-+---+
| col   | tinytext | YES  | | NULL|   |
+---+--+--+-+-+---+
1 row in set (0.00 sec)

+---+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-+---+
| col   | varchar(50) | YES  | | NULL|   |
+---+-+--+-+-+---+
1 row in set (0.00 sec)

mysql SELECT COUNT(*) FROM text_tinytext; SELECT COUNT(*) FROM
text_varchar;
+--+
| COUNT(*) |
+--+
|33990 |
+--+
1 row in set (0.16 sec)

+--+
| COUNT(*) |
+--+
|33990 |
+--+
1 row in set (0.20 sec)

Seems like TINYTEXT can be even faster than VARCHAR.

Regards,
--
  Stefan Hinz [EMAIL PROTECTED]
  Geschäftsführer / CEO iConnect GmbH http://iConnect.de
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

- Original Message -
From: Benjamin Pflugmann [EMAIL PROTECTED]
To: Philip Mak [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, December 29, 2002 12:34 PM
Subject: Re: Storing a SHA1 checksum


 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 influences how comparisons are done
 (mainly case-sensivity, but also umlauts, etc...).

 Stripping space from VARCHAR is a known deficiency:

   http://www.mysql.com/doc/en/Bugs.html

 It also mentions, that the TEXT/BLOB types are save from it.

  That means if the last character of my SHA1 checksum happens to be a
  space, MySQL will corrupt it.
 
  What should I do? It seems I can:
 
  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.

  Advantage: Other application programmers do not need to be aware
  of the hack. After MySQL is fixed, the source doesn't contain
  redundant code.

  2. Make my application pad the checksum out to 20 spaces.
 Problem: Increases my code complexity a bit.
  Advantage: Doesn't affect performance (noticeably). The DBA
  doesn't need to be aware of the hack.

  3. Wait for MySQL to fix the strip trailing spaces bug.
 Problem: That doesn't provide an immediate solution.

 4. Append a non-space at the end, and ignore it on retrieval
Problem: Same as 2.
Although 2. looks like the prettier solution, 4. makes easier to
spot the problem, if the additional handling is forgotten in new
code.

 Well, what you should do? It depends on what you need. It's a
 trade-off and no one except you can answer what your priorities are.

 If, for example, you have many applications / programmers who access
 this stuff, 1. is least intrusive. OTOH, if it is used only in one
 place, perhaps in a well-encapsulated object, 2. is the least
 intrusive change. And someone (that includes yourself in 1 year)
 looking at your SQL dump wouldn't know why you have chosen a BLOB,
 while you can have a neat comment in the source about it.

 Since any of the solutions involves only minor changes, I would not
 bother to waste time on the decision. Simply go with one and rewrite
 if it really turns out to become a problem later (which I don't
 believe).

 HTH,

 Benjamin.

 --
 [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, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Anyone have MySQL/PHP running from CD?

2002-12-29 Thread databarn

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 purports to do just what we need, but it's a bit 
steep for a startup on a shoestring budget - $300 for a developer's license.  Haven't 
checked it out yet, so I cannot speak to its effectiveness.

Anyone know of anything else that might do the job, preferably at a lower cost, open 
source or maybe freeware?  It would need to run transparently, i.e., autorun or run 
one executable that would fire up PHP, MySQL, and the default web browser for the 
machine using the CD.  'Twould be nice if it was OS/platform independent, but it'll 
need to run on Windows 9x/NT/2K at the least, and should work with Win ME/XP as well.

'Preciate any aid on this.



Make a good day . . .
 . . . barn
~
Wear a smile and have friends; wear a scowl and have wrinkles.
~



-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: Re: Moving a database accross a platform

2002-12-29 Thread Victoria Reznichenko

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 least if he hasn't used innodb with foreign keys

 AFAIK mysqldump is not clever enough to dump the tables in the right
 order so that referential integrity doesn't stop the reimport of the data

 or maybe I'm to stupid to make it do it the right way

If he used InnoDB with foreign key constraints, he can just use SET 
FOREIGN_KEY_CHECKS=0.


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com





-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: An Idea

2002-12-29 Thread Egor Egorov

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, so I changed it by myself. But then (after deleting the
 last ID was 17, and before 32), next ID was 33, not 18. Is there any
 function, which can change it?

Nope. It's expected behaviour for MyISAM and InnoDB tables.

If not, mayby you'll try to do something
 like that. It's right, I can do it by myself not using auto_increment, and
 giving the ID number MAX(ID)+1, but if there is such function it would be
 realy fine. 

Sure, you can do it, but you should lock table, retrieve max id value, insert 
max+1 value, unlock table.






-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: Re: unable to create File DSN

2002-12-29 Thread Victoria Reznichenko

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 have discovered that I can create a trimmed-down version using notepad:

 [ODBC]
 DSN=foobar

 If I call this file foo.dsn and put it in C:\Program Files\Common
 Files\odbc\Data Sources, foo.dsn shows up in the ODBC Data Source
 Administrator application (aka ODBC manager).  However, in order to
 actually use it, I have to create the System DSN that is specified in the
 File DSN, for this example, foobar.  Using the ODBC manager, if I change
 the File DSN, the System DSN also changes, and vice versa.  Yet, when I
 quit and examine the file foo.dsn, nothing has changed.  It still just has
 the single line DSN=foobar.

 What is the advantage of creating a File DSN if I have to create a System
 DSN?  Why not use the System DSN instead of a File DSN?  Setting up a
 System DSN so that I can create a File DSN leaves me with the feeling that
 something is broken.  Is it Windows' ODBC manager?  Is it MyODBC?  Should I
 be trying MyODBC 3.51?

Yes, it's only supported by MyODBC 3.51, but not by 2.50.


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com





-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: Fulltext search of words 3 chars in 3.23

2002-12-29 Thread Egor Egorov

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 searches on acronyms
 like php.

You can change value of the ft_min_word_len (look at the ft_static.c) and 
recompile MySQL server.



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

View multiple images in a page

2002-12-29 Thread tan tan

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 import=java.io.* %
%@ page import=javax.servlet.* %
%@ page import=javax.servlet.http.* %
%@ page import=javax.servlet.jsp.* %

%
OutputStreamos;
String  fn,sSQL,contentType,JDBC,DBURL,userName,pwd;
int bufferSize=1048576,bytesRead=0;
byte[]  b = new byte[bufferSize];
ServletOutputStream sos;
InputStream is;
int fieldCount=0;
ResultSet   rs;
Connection  conn;
Statement   stmt;
int fieldNo;
Blobblob;
BufferedInputStream bis;
BufferedOutputStreambos;

  JDBC=org.gjt.mm.mysql.Driver;
  DBURL=jdbc:mysql:///imaging;
  userName=root;
  pwd=password;
  sSQL=select Bobject from blobber;
  fn=1;
  contentType=image/gif;


  try
 {Class.forName(JDBC);
 
conn=DriverManager.getConnection(DBURL,userName,pwd);
  stmt=conn.createStatement();
  rs=stmt.executeQuery(sSQL);

  if (contentType==null)
 response.setContentType(image/gif);
  else
 response.setContentType(contentType);
  if (fn==null)
fieldCount=1;
  else
fieldCount=Integer.parseInt(fn);   

rs.next();
  blob= rs.getBlob(1);
  is=blob.getBinaryStream(); 
  bis=new BufferedInputStream(is,2*bufferSize);
  sos=response.getOutputStream();
  bos=new BufferedOutputStream(sos,2*bufferSize);
  bytesRead=bis.read(b,0,bufferSize);
  while (bytesRead!=-1)
{
  bos.write(b,0,bytesRead);
  bytesRead=bis.read(b,0,bufferSize);
} 
  bis.close();
  bos.close();
  is.close();
  sos.close();
  rs.close();
  stmt.close();
  conn.close();
}
 catch (Exception e)
   {
 response.setContentType(text/html);
 PrintWriter out1=response.getWriter();
 out1.println(Servlet BlobHandler error
occur:+e.toString());
   }   

%

__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: An Idea

2002-12-29 Thread Paul DuBois

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, so I changed it by myself. But then (after deleting the last ID
was 17, and before 32), next ID was 33, not 18. Is there any function, which
can change it? If not, mayby you'll try to do something like that. It's
right, I can do it by myself not using auto_increment, and giving the ID
number MAX(ID)+1, but if there is such function it would be realy fine.
Greatings,
MySQL user

Adam Wi´ckowski
GG# :1257924



-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Anyone have MySQL/PHP running from CD?

2002-12-29 Thread Cal Evans

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 language for a static site?
yes, I know right now that's the way it's built but the main reason you have
a database behind a site is because the data will change. If the data is not
going to change (you ARE burning it onto a CD, right?) then I would
re-examine my structure.

If you goal is to provide the existing site on a CD then I would suggest
investing about an hour over at www.freshmeat.net. I bet that you could find
a 'bot' that will spider your existing website and create an 'off-line'
version complete with URL's that point to the off-line version and all
graphics. If this magical bot (and I know they exist but I'm not going to
spend the time looking for one for you) spiders ALL your pages then, unless
you have something like an integrated search engine, you should be able to
burn the off-line content to a CD.  Add an autorun.inf and anyone dumb
enough to leave autorun turned on will see the site whenever the disk is
inserted into the drive.  The advantage of this is that it's cross-platform.
(Linux, Mac and even Windows)

The other option is to write pages that will go on the CD that check for an
internet connection via JavaScript (will this page load, etc.  not hard if
you think it through) and then display default content if no connection is
present but if a connection is present it pulls from her site. The upside to
this is if you are burning the CD's manually, you can add a unique ID to
each of them and track their usage through your web server's log files.

HTH,
=C=

p.s. nothing works WITH WinME.  Some things work in spite of WinME!  :)
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*


-Original Message-
From: databarn [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 29, 2002 9:34 AM
To: MySQL
Subject: Anyone have MySQL/PHP running from CD?


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 purports to do
just what we need, but it's a bit steep for a startup on a shoestring
budget - $300 for a developer's license.  Haven't checked it out yet, so I
cannot speak to its effectiveness.

Anyone know of anything else that might do the job, preferably at a lower
cost, open source or maybe freeware?  It would need to run transparently,
i.e., autorun or run one executable that would fire up PHP, MySQL, and the
default web browser for the machine using the CD.  'Twould be nice if it was
OS/platform independent, but it'll need to run on Windows 9x/NT/2K at the
least, and should work with Win ME/XP as well.

'Preciate any aid on this.



Make a good day . . .
 . . . barn
~
Wear a smile and have friends; wear a scowl and have wrinkles.
~



-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: ADO Error '800a01fb'

2002-12-29 Thread Michael She

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
mysql 4.07 + myodbc 3.51 = Error

the code list is :


-

strSQL = DRIVER={MySQL ODBC 3.51
Driver};SERVER=localhost;DATABASE=test;USER=root;PASSWORD=root;OPTION=35;

Set Cn1 = CreateObject(ADODB.Connection)
Cn1.Open strSQL
strSQL1 = select * from mytable where pkey =   1
Set rs2 = CreateObject(ADODB.Recordset)
rs2.Open strSQL1, Cn1, 1, 3

If Not rs2.EOF Then
rs2(data).Value = Now
rs2.Update '  Error Line Reported.
##
End If

rs2.Close
Cn1.Close
Set rs2 = Nothing
Set Cn1 = Nothing


-

pls see the attached file for more error msg... tks.

Chiang



- Original Message -
From: jumpmaster [EMAIL PROTECTED]
To: Michael She [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, December 29, 2002 7:39 AM
Subject: RE: ADO Error '800a01fb'


 Michael,

 My guess (and this is *only a guess*) -- for some reason one of the
objects
 is not being created; maybe the recordset object.  I am not sure where you
 are getting that error number from (presumably in you browser) as you do
not
 state it.  i suggest that you check your webserver logs if you have access
 to them.  They might have an extended error message which will pinpoint
your
 problem.

 Also, you can try to 'trap' the error.  I found this tid-bit on the M$
 site...


 On error resume next
 ..
 ..
 ..
 Your problem code goes here
 ..
 ..
 ..
 if err.number  0 then
 Response.Write err.description  BR  err.source  BR
 err.clear
 end if


 Here is the link where I found it:
 http://support.microsoft.com/default.aspx?scid=kb;en-us;299981#7


 One last note...the reason I think it is your recordset object is because
of
 your query...You use single quotes in the wrong place.  Your strSQL
variable
 should be defined as follows:

 strSQL = SELECT * FROM IMAGES WHERE ID = '  ID  '

 Or - if ID is numeric then:

 strSQL = SELECT * FROM IMAGES WHERE ID =   ID

 HTH,
 Kurt

 -Original Message-
 From: Michael She [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, December 28, 2002 6:57 AM
 To: [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Subject: ADO Error '800a01fb'


 Hi all,

 I'm getting this error with MyODBC v2.50 and v3.51.  I'm running MySQL
 v4.06:

 Microsoft VBScript runtime error '800a01fb'

 An exception occurred: 'open'

 /mshe/gallery/picture.asp, line 45


 The code for that area is:

 strConn = DSN=binaryio;
 Set objConn = Server.CreateObject(ADODB.Connection)
 objConn.open strConn

 set rs = server.createobject(adodb.recordset)
 strSQL = SELECT * FROM IMAGES WHERE `ID` =   ID
 rs.open strSQL, objConn, 3,1,1

 Nothing out of the ordinary... anyone know why I'm getting this error?
 Thanks!
 --
 Michael She  : [EMAIL PROTECTED]
 Mobile   : (519) 589-7309
 WWW Homepage : http://www.binaryio.com/



 -
 Before posting, please check:
http://www.mysql.com/products/myodbc/manual_toc.html (the manual)
http://lists.mysql.com/(the list archive)

 To unsubscribe, e-mail [EMAIL PROTECTED]
 To unsubscribe from Yahoo! Groups version, e-mail
 [EMAIL PROTECTED]


 -
 Before posting, please check:
http://www.mysql.com/products/myodbc/manual_toc.html (the manual)
http://lists.mysql.com/(the list archive)

 To unsubscribe, e-mail [EMAIL PROTECTED]
 To unsubscribe from Yahoo! Groups version, e-mail
[EMAIL PROTECTED]




--
Michael She  : [EMAIL PROTECTED]
Mobile   : (519) 589-7309
WWW Homepage : http://www.binaryio.com/


-
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, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Anyone have MySQL/PHP running from CD?

2002-12-29 Thread Patrick Sherrill

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 PROTECTED]
Sent: Sunday, December 29, 2002 10:34 AM
Subject: Anyone have MySQL/PHP running from CD?


 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 purports
to do just what we need, but it's a bit steep for a startup on a shoestring
budget - $300 for a developer's license.  Haven't checked it out yet, so I
cannot speak to its effectiveness.

 Anyone know of anything else that might do the job, preferably at a lower
cost, open source or maybe freeware?  It would need to run transparently,
i.e., autorun or run one executable that would fire up PHP, MySQL, and the
default web browser for the machine using the CD.  'Twould be nice if it was
OS/platform independent, but it'll need to run on Windows 9x/NT/2K at the
least, and should work with Win ME/XP as well.

 'Preciate any aid on this.



 Make a good day . . .
  . . . barn
 ~
 Wear a smile and have friends; wear a scowl and have wrinkles.
 ~



 -
 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, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Why unsigned doesn't work?

2002-12-29 Thread Octavian Rasnita

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: [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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: ADO Error '800a01fb'

2002-12-29 Thread Michael She

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 12/29/2002 +0200, Gelu Gogancea wrote:

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 She
Cc: [EMAIL PROTECTED]
Betreff: Re: ADO Error '800a01fb'


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]
  [EMAIL PROTECTED]
- Original Message -
From: Michael She [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, December 28, 2002 7:57 AM
Subject: ADO Error '800a01fb'


 Hi all,

 I'm getting this error with MyODBC v2.50 and v3.51.  I'm running MySQL
v4.06:

 Microsoft VBScript runtime error '800a01fb'

 An exception occurred: 'open'

 /mshe/gallery/picture.asp, line 45


 The code for that area is:

 strConn = DSN=binaryio;
 Set objConn = Server.CreateObject(ADODB.Connection)
 objConn.open strConn

 set rs = server.createobject(adodb.recordset)
 strSQL = SELECT * FROM IMAGES WHERE `ID` =   ID
 rs.open strSQL, objConn, 3,1,1

 Nothing out of the ordinary... anyone know why I'm getting this error?
Thanks!
 --
 Michael She  : [EMAIL PROTECTED]
 Mobile   : (519) 589-7309
 WWW Homepage : http://www.binaryio.com/



 -
 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, e-mail
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/products/myodbc/manual_toc.html (the manual)
   http://lists.mysql.com/(the list archive)

To unsubscribe, e-mail [EMAIL PROTECTED]
To unsubscribe from Yahoo! Groups version, e-mail
[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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/products/myodbc/manual_toc.html (the manual)
   http://lists.mysql.com/(the list archive)

To unsubscribe, e-mail [EMAIL PROTECTED]
To unsubscribe from Yahoo! Groups version, e-mail 
[EMAIL PROTECTED]

--
Michael She  : [EMAIL PROTECTED]
Mobile   : (519) 589-7309
WWW Homepage : http://www.binaryio.com/



-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: An Idea

2002-12-29 Thread Michael She

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 after
deleting, so I changed it by myself.




Don't use the PK for numbering.  Instead, in PHP, ASP, etc, just use a 
counter when looping through your guestbook entries and label them 1, 2, 3, 
etc.


BTW, does MySQL have a RowNumber function?

--
Michael She  : [EMAIL PROTECTED]
Mobile   : (519) 589-7309
WWW Homepage : http://www.binaryio.com/



-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

AW: ADO Error '800a01fb'

2002-12-29 Thread Freddie Sorensen

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  BR  err.source  BR
err.clear
end if

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 ID =   ID

Hth
Freddie

-Ursprüngliche Nachricht-
Von: Michael She [mailto:[EMAIL PROTECTED]] 
Gesendet: Sonntag, 29. Dezember 2002 17:39
An: Gelu Gogancea
Cc: Freddie Sorensen; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Betreff: Re: ADO Error '800a01fb'


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 12/29/2002 +0200, Gelu Gogancea wrote:

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 She
Cc: [EMAIL PROTECTED]
Betreff: Re: ADO Error '800a01fb'


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]
   [EMAIL PROTECTED]
- Original Message -
From: Michael She [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, December 28, 2002 7:57 AM
Subject: ADO Error '800a01fb'


  Hi all,
 
  I'm getting this error with MyODBC v2.50 and v3.51.  I'm running 
  MySQL
v4.06:
 
  Microsoft VBScript runtime error '800a01fb'
 
  An exception occurred: 'open'
 
  /mshe/gallery/picture.asp, line 45
 
 
  The code for that area is:
 
  strConn = DSN=binaryio;
  Set objConn = Server.CreateObject(ADODB.Connection)
  objConn.open strConn
 
  set rs = server.createobject(adodb.recordset)
  strSQL = SELECT * FROM IMAGES WHERE `ID` =   ID
  rs.open strSQL, objConn, 3,1,1
 
  Nothing out of the ordinary... anyone know why I'm getting this 
  error?
Thanks!
  --
  Michael She  : [EMAIL PROTECTED]
  Mobile   : (519) 589-7309
  WWW Homepage : http://www.binaryio.com/
 
 
 
  
  -
  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, e-mail 
  [EMAIL PROTECTED]
  Trouble unsubscribing? Try: 
  http://lists.mysql.com/php/unsubscribe.php
 
 


-
Before posting, please check:
http://www.mysql.com/products/myodbc/manual_toc.html (the manual)
http://lists.mysql.com/(the list archive)

To unsubscribe, e-mail [EMAIL PROTECTED]
To unsubscribe from Yahoo! Groups version, e-mail 
[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, e-mail 
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
http://www.mysql.com/products/myodbc/manual_toc.html (the manual)
http://lists.mysql.com/(the list archive)

To unsubscribe, e-mail [EMAIL PROTECTED]
To unsubscribe from Yahoo! Groups version, e-mail
[EMAIL PROTECTED]

-- 
Michael She  : [EMAIL PROTECTED]
Mobile   : (519) 589-7309
WWW Homepage : http://www.binaryio.com/





-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

AW: ADO Error '800a01fb'

2002-12-29 Thread Freddie Sorensen

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 ID =   ID

Hth
Freddie

-Ursprüngliche Nachricht-
Von: Michael She [mailto:[EMAIL PROTECTED]] 
Gesendet: Sonntag, 29. Dezember 2002 17:39
An: Gelu Gogancea
Cc: Freddie Sorensen; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Betreff: Re: ADO Error '800a01fb'


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 12/29/2002 +0200, Gelu Gogancea wrote:

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 She
Cc: [EMAIL PROTECTED]
Betreff: Re: ADO Error '800a01fb'


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]
   [EMAIL PROTECTED]
- Original Message -
From: Michael She [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, December 28, 2002 7:57 AM
Subject: ADO Error '800a01fb'


  Hi all,
 
  I'm getting this error with MyODBC v2.50 and v3.51.  I'm running
  MySQL
v4.06:
 
  Microsoft VBScript runtime error '800a01fb'
 
  An exception occurred: 'open'
 
  /mshe/gallery/picture.asp, line 45
 
 
  The code for that area is:
 
  strConn = DSN=binaryio;
  Set objConn = Server.CreateObject(ADODB.Connection)
  objConn.open strConn
 
  set rs = server.createobject(adodb.recordset)
  strSQL = SELECT * FROM IMAGES WHERE `ID` =   ID
  rs.open strSQL, objConn, 3,1,1
 
  Nothing out of the ordinary... anyone know why I'm getting this
  error?
Thanks!
  --
  Michael She  : [EMAIL PROTECTED]
  Mobile   : (519) 589-7309
  WWW Homepage : http://www.binaryio.com/
 
 
 
  
  -
  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, e-mail
  [EMAIL PROTECTED]
  Trouble unsubscribing? Try: 
  http://lists.mysql.com/php/unsubscribe.php
 
 


-
Before posting, please check:
http://www.mysql.com/products/myodbc/manual_toc.html (the manual)
http://lists.mysql.com/(the list archive)

To unsubscribe, e-mail [EMAIL PROTECTED]
To unsubscribe from Yahoo! Groups version, e-mail
[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, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
http://www.mysql.com/products/myodbc/manual_toc.html (the manual)
http://lists.mysql.com/(the list archive)

To unsubscribe, e-mail [EMAIL PROTECTED]
To unsubscribe from Yahoo! Groups version, e-mail 
[EMAIL PROTECTED]

-- 
Michael She  : [EMAIL PROTECTED]
Mobile   : (519) 589-7309
WWW Homepage : http://www.binaryio.com/





-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: An Idea

2002-12-29 Thread Cal Evans

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 things about this list. We as a
community of SQL developers (regardless of dialect) need to make a more
concentrated effort to explain the differences between desktop databases and
real database engines. We need to educate people making the changeover
before releasing them into the wild. (Maybe the link to download MySql could
ask a few basic questions to prove you know what you are doing before being
allowed to download!)  :)

I cut my teeth on FoxPro.  The first SQL I wrote was in the FoxPro (2.5/6?)
dialect. I know from whence I speak because I asked these same questions
many years ago.  Luckily, I found people who kindly but firmly pointed me in
the right direction. (You DON'T need gapless sequences for PK's. You
DON'T store images in the actual database without permission from God.
Here's the FAQ we developed so you don't have to waste our time asking
questions that have already been answered. Thank you, come again.) They
showed me the light and occasionally I try to share what little I know with
others.

I guess what I'm trying to say is to those who know something (even if you
are like me and are constantly amazed at what you DON'T know) share kindly
and willingly. To those seeking enlightenment...RTFM you mook! Check the
!*#^ archives and use Google, this issue has been beat to death!

Humbly,
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*


-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 29, 2002 10:02 AM
To: Adam Wi´ckowski; [EMAIL PROTECTED]
Subject: Re: An Idea


Why?


-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Why unsigned doesn't work?

2002-12-29 Thread Cal Evans

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 8:07 AM
To: [EMAIL PROTECTED]
Subject: Why unsigned doesn't work?


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: [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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: ADO Error '800a01fb'

2002-12-29 Thread Chien, Shih Chiang

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.





- Original Message -
From: Michael She [EMAIL PROTECTED]
To: Chien, Shih Chiang [EMAIL PROTECTED]
Cc: jumpmaster [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Monday, December 30, 2002 12:35 AM
Subject: Re: ADO Error '800a01fb'


 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
 mysql 4.07 + myodbc 3.51 = Error
 
 the code list is :
 

---
-
 -
 
  strSQL = DRIVER={MySQL ODBC 3.51

Driver};SERVER=localhost;DATABASE=test;USER=root;PASSWORD=root;OPTION=35;
 
  Set Cn1 = CreateObject(ADODB.Connection)
  Cn1.Open strSQL
  strSQL1 = select * from mytable where pkey =   1
  Set rs2 = CreateObject(ADODB.Recordset)
  rs2.Open strSQL1, Cn1, 1, 3
 
  If Not rs2.EOF Then
  rs2(data).Value = Now
  rs2.Update '  Error Line Reported.
 ##
  End If
 
  rs2.Close
  Cn1.Close
  Set rs2 = Nothing
  Set Cn1 = Nothing
 

---
-
 -
 
 pls see the attached file for more error msg... tks.
 
 Chiang
 
 
 
 - Original Message -
 From: jumpmaster [EMAIL PROTECTED]
 To: Michael She [EMAIL PROTECTED]; [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Sent: Sunday, December 29, 2002 7:39 AM
 Subject: RE: ADO Error '800a01fb'
 
 
   Michael,
  
   My guess (and this is *only a guess*) -- for some reason one of the
 objects
   is not being created; maybe the recordset object.  I am not sure where
you
   are getting that error number from (presumably in you browser) as you
do
 not
   state it.  i suggest that you check your webserver logs if you have
access
   to them.  They might have an extended error message which will
pinpoint
 your
   problem.
  
   Also, you can try to 'trap' the error.  I found this tid-bit on the M$
   site...
  
  
   On error resume next
   ..
   ..
   ..
   Your problem code goes here
   ..
   ..
   ..
   if err.number  0 then
   Response.Write err.description  BR  err.source  BR
   err.clear
   end if
  
  
   Here is the link where I found it:
   http://support.microsoft.com/default.aspx?scid=kb;en-us;299981#7
  
  
   One last note...the reason I think it is your recordset object is
because
 of
   your query...You use single quotes in the wrong place.  Your strSQL
 variable
   should be defined as follows:
  
   strSQL = SELECT * FROM IMAGES WHERE ID = '  ID  '
  
   Or - if ID is numeric then:
  
   strSQL = SELECT * FROM IMAGES WHERE ID =   ID
  
   HTH,
   Kurt
  
   -Original Message-
   From: Michael She [mailto:[EMAIL PROTECTED]]
   Sent: Saturday, December 28, 2002 6:57 AM
   To: [EMAIL PROTECTED]
   Cc: [EMAIL PROTECTED]
   Subject: ADO Error '800a01fb'
  
  
   Hi all,
  
   I'm getting this error with MyODBC v2.50 and v3.51.  I'm running MySQL
   v4.06:
  
   Microsoft VBScript runtime error '800a01fb'
  
   An exception occurred: 'open'
  
   /mshe/gallery/picture.asp, line 45
  
  
   The code for that area is:
  
   strConn = DSN=binaryio;
   Set objConn = Server.CreateObject(ADODB.Connection)
   objConn.open strConn
  
   set rs = server.createobject(adodb.recordset)
   strSQL = SELECT * FROM IMAGES WHERE `ID` =   ID
   rs.open strSQL, objConn, 3,1,1
  
   Nothing out of the ordinary... anyone know why I'm getting this error?
   Thanks!
   --
   Michael She  : [EMAIL PROTECTED]
   Mobile   : (519) 589-7309
   WWW Homepage : http://www.binaryio.com/
  
  
  
   -
   Before posting, please check:
  http://www.mysql.com/products/myodbc/manual_toc.html (the manual)
  http://lists.mysql.com/(the list archive)
  
   To unsubscribe, e-mail [EMAIL PROTECTED]
   To unsubscribe from Yahoo! Groups version, e-mail
   [EMAIL PROTECTED]
  
  
   -
   Before posting, please check:
  http://www.mysql.com/products/myodbc/manual_toc.html (the manual)
  http://lists.mysql.com/(the list archive)
  
   To unsubscribe, e-mail [EMAIL PROTECTED]
   To unsubscribe from Yahoo! Groups version, e-mail
 [EMAIL PROTECTED]
  
  

 --
 Michael She  : [EMAIL PROTECTED]
 Mobile   : (519) 589-7309
 WWW Homepage : http://www.binaryio.com/

Re: Why unsigned doesn't work?

2002-12-29 Thread Ryan Fox


- 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 of the type, and so
needs to be next to the type declaration 'int'.

sql, query, anti-spam splooge.


-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Why unsigned doesn't work?

2002-12-29 Thread Rick Pasotto

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 why doesn't it work?

What is an 'unsigned not null'?

The syntax calls for (col_name type [NOT NULL] ...).

Two of the valid types are 'int' and 'int unsigned'.

Try 'create table aaa(id int unsigned not null, name text);'

-- 
All government is, in its essence, organized exploitation, and
in virtually all of its existing forms it is the implacable enemy
of every industrious and well-disposed man. --- H. L. Mencken
Rick Pasotto[EMAIL PROTECTED]http://www.niof.net

-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: An Idea

2002-12-29 Thread harm

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)

-- 
   The Moon is Waning Crescent (21% of Full)
   nieuw.nl - 2dehands.nl: 58038

-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Why unsigned doesn't work?

2002-12-29 Thread Joseph Bueno

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 is wrong. It should be:
create table aaa(id int unsigned not null, name text);

Please see the manual for more details:
http://www.mysql.com/doc/en/CREATE_TABLE.html

 Thank you.
 
 Teddy,
 Teddy's Center: http://teddy.fcc.ro/
 Email: [EMAIL PROTECTED]
 
Regards,
Joseph Bueno


-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Why unsigned doesn't work?

2002-12-29 Thread Georg Richter

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

-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: AW: ADO Error '800a01fb'

2002-12-29 Thread Michael She

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 exception occurred: 'open'

/mshe/gallery/picture.asp, line 45

: (


At 05:53 PM 12/29/2002 +0100, Freddie Sorensen wrote:
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 ID =   ID

Hth
Freddie

-Ursprüngliche Nachricht-
Von: Michael She [mailto:[EMAIL PROTECTED]]
Gesendet: Sonntag, 29. Dezember 2002 17:39
An: Gelu Gogancea
Cc: Freddie Sorensen; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Betreff: Re: ADO Error '800a01fb'


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 12/29/2002 +0200, Gelu Gogancea wrote:

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 She
Cc: [EMAIL PROTECTED]
Betreff: Re: ADO Error '800a01fb'


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]
   [EMAIL PROTECTED]
- Original Message -
From: Michael She [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, December 28, 2002 7:57 AM
Subject: ADO Error '800a01fb'


  Hi all,
 
  I'm getting this error with MyODBC v2.50 and v3.51.  I'm running
  MySQL
v4.06:
 
  Microsoft VBScript runtime error '800a01fb'
 
  An exception occurred: 'open'
 
  /mshe/gallery/picture.asp, line 45
 
 
  The code for that area is:
 
  strConn = DSN=binaryio;
  Set objConn = Server.CreateObject(ADODB.Connection)
  objConn.open strConn
 
  set rs = server.createobject(adodb.recordset)
  strSQL = SELECT * FROM IMAGES WHERE `ID` =   ID
  rs.open strSQL, objConn, 3,1,1
 
  Nothing out of the ordinary... anyone know why I'm getting this
  error?
Thanks!
  --
  Michael She  : [EMAIL PROTECTED]
  Mobile   : (519) 589-7309
  WWW Homepage : http://www.binaryio.com/
 
 
 
  
  -
  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, e-mail
  [EMAIL PROTECTED]
  Trouble unsubscribing? Try:
  http://lists.mysql.com/php/unsubscribe.php
 
 


-
Before posting, please check:
http://www.mysql.com/products/myodbc/manual_toc.html (the manual)
http://lists.mysql.com/(the list archive)

To unsubscribe, e-mail [EMAIL PROTECTED]
To unsubscribe from Yahoo! Groups version, e-mail
[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, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
http://www.mysql.com/products/myodbc/manual_toc.html (the manual)
http://lists.mysql.com/(the list archive)

To unsubscribe, e-mail [EMAIL PROTECTED]
To unsubscribe from Yahoo! Groups version, e-mail
[EMAIL PROTECTED]

--
Michael She  : [EMAIL PROTECTED]
Mobile   : (519) 589-7309
WWW Homepage : http://www.binaryio.com/





-
Before posting, please check:
   http://www.mysql.com/products/myodbc/manual_toc.html (the manual)
   http://lists.mysql.com/(the list archive)

To unsubscribe, e-mail [EMAIL PROTECTED]
To unsubscribe from Yahoo! Groups version, e-mail 
[EMAIL PROTECTED]

--
Michael She  : [EMAIL PROTECTED]
Mobile   : (519) 589-7309
WWW Homepage : http://www.binaryio.com/



-
Before posting,

Fatal error

2002-12-29 Thread Pikasz Gyorgy

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 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

Thanks

picas





-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: ADO Error '800a01fb'

2002-12-29 Thread Michael She

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 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.


--
Michael She  : [EMAIL PROTECTED]
Mobile   : (519) 589-7309
WWW Homepage : http://www.binaryio.com/



-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Anyone have MySQL/PHP running from CD?

2002-12-29 Thread Michael She

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 Daemon on a business card CD +
 PHP + MySQL.  If I were the employer, I wouldn't even bother installing all
 that stuff just to view the card.

You may have missed the point; I was apparently not clear . . . all this 
must run _from the CD_ w/o installing to the hard drive.  The idea is to 
let anyone who has access to a spindled CD player view the web/products by 
doing nothing more than putting the CD in the player and _possibly_ 
clicking a start file - autorun would be preferable, but some folk may 
have it turned off.  The concept here is not to build web traffic, but to 
build orders grin /.

I understand you want to run all this stuff OFF the CD.  But the reality is 
- all those daemons need to be configured, installed, and executed.  It 
seems a bit excessive for a business card CD ROM.  Also, keep in mind that 
most business card CD ROMs are ~100MB.  If you install MySQL + Apache + PHP 
+ the sites, you're going to hit the limit really quick.

With that many executables, your demo cd will become very complex very 
quickly.  You may have more technical problems than it is worth.

Others have suggested that you spider the websites and place them on the CD 
ROM.  I think that is a very good solution.  At least you're guaranteed 
cross platform compatiblity and it is almost sure fire solution.

Another possiblity is to convert all the application/search logic into Java 
like Macromedia's Help files.

Also... if one does not have internet access, what are the chances that 
they'll view your CD-ROM in the first place?  If you're trying to sell 
websites to businesses who are NOT net savvy, a flashy CD-ROM may not do 
the job...  Instead, pictures, charts, and graphs may do the job better.


--
Michael She  : [EMAIL PROTECTED]
Mobile   : (519) 589-7309
WWW Homepage : http://www.binaryio.com/


-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: altering data structure

2002-12-29 Thread Benjamin Pflugmann


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 has SELECT as part of it, and an
 INSERT command that has SELECT as part of it?

Yes and no. Yes, it is a INSERT with SELECT. No, if I consider what
you write below. I did not mean sub-selects or derived tables.

 Actually I wanted to know how to do the latter but didn't think it
 could be done!  Briefly:
 
   create table ccards
   (
 # ID number
 id smallint not null default 0 auto_increment primary key ,
   ...
 hash tinyblob # hash of the card: have we seen this one before?
   ) ;
   create table clientcards
   (
 # ID number
 id smallint not null default 0 auto_increment primary key ,
 client smallint , # references client.id
 card smallint ,   # references ccards.id (but must be disconnected)
 type smallint ,   # references ccardtypes.id  ### need this here?
 hash tinyblob # references ccards.hash (but must be disconnected)
   ) ;
   ...
   insert into ccards (type,name,number,expdate) values
 ( '1' , 'david thorburn-gundlach' , '1234 5678 9abc def0' , '2003-06-00') ;
   update ccards set hash = md5(number) where id = last_insert_id() ;
   insert into clientcards values
 ( '' , '1' , '1' , '1' , 
   select ccards.hash where ccards.id = last_insert_id() ) ;

That would be something like a derived table, which are only supported
since v4.1 (not considering the fact that the FROM clause is missing :-).

The INSERT ... SELECT which I referred to is a special syntax which is
supported since quite a while (in v3.23 for sure):

  http://www.mysql.com/doc/en/INSERT_SELECT.html
  http://www.mysql.com/doc/en/ANSI_diff_SELECT_INTO_TABLE.html

In your case it would be something like

  INSERT INTO clientcards SELECT '', 1, 1, 1, ccards.hash FROM
  ccard WHERE ccards.id = LAST_INSERT_ID()


And you have variables. If the above wouldn't work you could write:

  SELECT @card_hash := hash FROM ccard WHERE ccards.id = LAST_INSERT_ID();
  INSERT INTO clientcards VALUES ( '' , 1, 1, 1, @card_hash );


Of course, that's only possible if you can live with being
MySQL-specific.

HTH,

Benjamin.


-- 
[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, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Storing a SHA1 checksum

2002-12-29 Thread Adolfo Bello

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-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 influences how comparisons are 
 done (mainly case-sensivity, but also umlauts, etc...).

 Stripping space from VARCHAR is a known deficiency:

   http://www.mysql.com/doc/en/Bugs.html

 It also mentions, that the TEXT/BLOB types are save from it.

  That means if the last character of my SHA1 checksum 
 happens to be a 
  space, MySQL will corrupt it.

  What should I do? It seems I can:

  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.

  Advantage: Other application programmers do not need to be aware
  of the hack. After MySQL is fixed, the source doesn't contain
  redundant code.

  2. Make my application pad the checksum out to 20 spaces.
 Problem: Increases my code complexity a bit.
  Advantage: Doesn't affect performance (noticeably). The DBA
  doesn't need to be aware of the hack.

  3. Wait for MySQL to fix the strip trailing spaces bug.
 Problem: That doesn't provide an immediate solution.

 4. Append a non-space at the end, and ignore it on retrieval
Problem: Same as 2.
Although 2. looks like the prettier solution, 4. makes easier to
spot the problem, if the additional handling is forgotten in new
code.

 Well, what you should do? It depends on what you need. It's a 
 trade-off and no one except you can answer what your priorities are.

 If, for example, you have many applications / programmers who 
 access this stuff, 1. is least intrusive. OTOH, if it is used 
 only in one place, perhaps in a well-encapsulated object, 2. 
 is the least intrusive change. And someone (that includes 
 yourself in 1 year) looking at your SQL dump wouldn't know 
 why you have chosen a BLOB, while you can have a neat comment 
 in the source about it.

 Since any of the solutions involves only minor changes, I 
 would not bother to waste time on the decision. Simply go 
 with one and rewrite if it really turns out to become a 
 problem later (which I don't believe).

 HTH,

   Benjamin.

 -- 
 [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, e-mail 
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: ensuring an instructor, client, or room isn't double-booked

2002-12-29 Thread Benjamin Pflugmann

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 smallint ,  # references places.id
 instr smallint ,  # references personnel.id
 time datetime # when

Don't you need some kind of duration? Or are the times fixed and you
know beforehand when the class starting at x o'clock will end? And
saving a number for the time slot would also work?

   ) ;
 
 I could, for every insert, check
 
   select * from schedule where client = '1' and time = '...' ;
 
 to make sure the client isn't being booked twice, or
 
   select * from schedule where instr = '1' and time = '...' ;
 
 to make sure the instructor isn't double-booked, but 

In the case of time slots, you could create a unique index on
(client,time) and (instr,time) and skip the selects. Simply insert and
check for an duplicate key error.

 that seems like it would get awfully slow as the table grows...

I wonder why you think so. Maybe I do not understand your concern
correctly, but with the right indexes this shouldn't be slow. Do I
miss something?

If not: Whether an index (client,time) or (time,client) is better
depends on your data (few or a lot of client, etc). If you don't have
time slots, even (client) or (time) would help, although not as much.

I you are not sure, simply build all of them and look which one get
used. Then dropped the other ones again. The same applies for instr.

 Is this the sort of thing where a temporary table is advised, or
 should I define a reverse table that shows each instructor and
 his/her bookings, or what?

I am not sure how a temporary table would improve things. So we have
some kind of misunderstanding. Could you post how you would use
temporary tables here? Then I could easier tell, how I would do the
same.

HTH,

Benjamin.

-- 
[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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

MySQL InnoDB

2002-12-29 Thread Andrew B. Sokov

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

 All Actions - work OK - COMMIT  ROLLBACK

 But if i try use every Insert at defferent page (php)

 Like
 Page.php - has FORM ACTION=p1.php 

 p1.php - has
 SET COMMIT;
 INSERT 1

 FORM ACTION=p2 ?

 {go to p2.php}

 INSERT 1
 ROLLBACK;

 - THIS IS NOT WORKED !
 WHY ?
 Who can help me - and answer at my Question ?

 --
Andrew B. Sokov
 
  Web-Media L.t.d. (812) 312-5309 27 äåêàáðÿ 2002 ã. 18:54

  URL:   http://www.Web-Media.ru
  e-mail:[EMAIL PROTECTED]
  ICQ UIN#   83040728
  phone: +7 (812) 312-5309
  fax:   +7 (812) 312-5309



-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Mac OS X 10.2 ?

2002-12-29 Thread Jonas Voss

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

-- 
// Jonas C. Voss // http://verture.net/ //

-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Fatal error

2002-12-29 Thread LeVar Bery

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 error

 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 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

 Thanks

 picas

 -
 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, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Fatal error

2002-12-29 Thread Doug Thompson

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 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 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

Thanks

picas



-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Anyone have MySQL/PHP running from CD?

2002-12-29 Thread David T-G

-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 that should be portable and
lightweight enough to fit in and at least get you going.  I don't think
you'll find platform independence (as you would with simple HTML), but
you could probably get a perl, a mysql, and a php for each OS and put 'em
on the CD -- with perhaps room for some content as well :-)


% 
% 'Preciate any aid on this.

HTH  HAND


mysql query,
:-D
- -- 
David T-G  * There is too much animal courage in 
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED]  -- Mary Baker Eddy, Science and Health
http://www.justpickone.org/davidtg/Shpx gur Pbzzhavpngvbaf Qrprapl Npg!

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.7 (FreeBSD)

iD8DBQE+D1hIGb7uCXufRwARAtOFAJ4hbbozLGG7QOJNJMXXnx1o1rGgBACguUk9
wF3HDtrfOJP3P/ABXVK1UtQ=
=h4EH
-END PGP SIGNATURE-

-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: altering data structure

2002-12-29 Thread David T-G

-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 WHERE ccards.id = LAST_INSERT_ID();
%   INSERT INTO clientcards VALUES ( '' , 1, 1, 1, @card_hash );

Aha!  This is exactly what I sought.  So that's how it's done :-)

Again, in the specific case in mind I'll be entering the single number
and can easily stuff the md5 sum [which I'll calculate just as easily as
mysqld would] into both tables, but ...


% 
% 
% Of course, that's only possible if you can live with being
% MySQL-specific.

Hmmm...  so it's a mysql thing and not a SQL thing.  Well, I'd like to
avoid that, even though I like mysql...


% 
% HTH,
% 
%   Benjamin.
% 
% 
% -- 
% [EMAIL PROTECTED]


Thanks  HAND  HH

:-D
- -- 
David T-G  * There is too much animal courage in 
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED]  -- Mary Baker Eddy, Science and Health
http://www.justpickone.org/davidtg/Shpx gur Pbzzhavpngvbaf Qrprapl Npg!

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.7 (FreeBSD)

iD8DBQE+D1lMGb7uCXufRwARAtDZAJ97FHKovuMjDmRUuEkKX4whVYXhHQCfWowu
oIN0lJ56xASB3HZgvGgN3T4=
=YF2l
-END PGP SIGNATURE-

-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: ADO Error '800a01fb'

2002-12-29 Thread ggelu

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 data is not exist NULL termination string, this error 
occur.This case are happens very frequently in Windows,especially 
when OS remain without memory resources.
In fact is an access violation error, but because error is raised 
in .dll, VB* doesn't know for what reason this error occur.And in 
this case err.description or err.number is no sens(or maybe for bug 
trapping).
For sure is not need to restart MYSQL server.Try to reset the client 
connection/process.

Hope it's help

Regards,
Gelu

 
--- Chien, Shih Chiang [EMAIL PROTECTED] wrote:
 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.
 
 
 
 
 
 - Original Message -
 From: Michael She [EMAIL PROTECTED]
 To: Chien, Shih Chiang [EMAIL PROTECTED]
 Cc: jumpmaster [EMAIL PROTECTED]; 
[EMAIL PROTECTED];
 [EMAIL PROTECTED]
 Sent: Monday, December 30, 2002 12:35 AM
 Subject: Re: ADO Error '800a01fb'
 
 
  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
  mysql 4.07 + myodbc 3.51 = Error
  
  the code list is :
  
 
 ---

 -
  -
  
   strSQL = DRIVER={MySQL ODBC 3.51
 
 
Driver};SERVER=localhost;DATABASE=test;USER=root;PASSWORD=root;OPTION
=35;
  
   Set Cn1 = CreateObject(ADODB.Connection)
   Cn1.Open strSQL
   strSQL1 = select * from mytable where pkey =   1
   Set rs2 = CreateObject(ADODB.Recordset)
   rs2.Open strSQL1, Cn1, 1, 3
  
   If Not rs2.EOF Then
   rs2(data).Value = Now
   rs2.Update '  Error Line 
Reported.
  ##
   End If
  
   rs2.Close
   Cn1.Close
   Set rs2 = Nothing
   Set Cn1 = Nothing
  
 
 ---

 -
  -
  
  pls see the attached file for more error msg... tks.
  
  Chiang
  
  
  
  - Original Message -
  From: jumpmaster [EMAIL PROTECTED]
  To: Michael She [EMAIL PROTECTED]; 
[EMAIL PROTECTED]
  Cc: [EMAIL PROTECTED]
  Sent: Sunday, December 29, 2002 7:39 AM
  Subject: RE: ADO Error '800a01fb'
  
  
Michael,
   
My guess (and this is *only a guess*) -- for some reason one 
of the
  objects
is not being created; maybe the recordset object.  I am not 
sure where
 you
are getting that error number from (presumably in you 
browser) as you
 do
  not
state it.  i suggest that you check your webserver logs if 
you have
 access
to them.  They might have an extended error message which will
 pinpoint
  your
problem.
   
Also, you can try to 'trap' the error.  I found this tid-bit 
on the M$
site...
   
   
On error resume next
..
..
..
Your problem code goes here
..
..
..
if err.number  0 then
Response.Write err.description  BR  err.source 
 BR
err.clear
end if
   
   
Here is the link where I found it:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;299981#7
   
   
One last note...the reason I think it is your recordset 
object is
 because
  of
your query...You use single quotes in the wrong place.  Your 
strSQL
  variable
should be defined as follows:
   
strSQL = SELECT * FROM IMAGES WHERE ID = '  ID  '
   
Or - if ID is numeric then:
   
strSQL = SELECT * FROM IMAGES WHERE ID =   ID
   
HTH,
Kurt
   
-Original Message-
From: Michael She [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 28, 2002 6:57 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: ADO Error '800a01fb'
   
   
Hi all,
   
I'm getting this error with MyODBC v2.50 and v3.51.  I'm 
running MySQL
v4.06:
   
Microsoft VBScript runtime error '800a01fb'
   
An exception occurred: 'open'
   
/mshe/gallery/picture.asp, line 45
   
   
The code for that area is:
   
strConn = DSN=binaryio;
Set objConn = Server.CreateObject(ADODB.Connection)
objConn.open strConn
   
set rs = server.createobject(adodb.recordset)
strSQL = SELECT * FROM IMAGES WHERE `ID` =   ID

Re: ensuring an instructor, client, or room isn't double-booked

2002-12-29 Thread David T-G

-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 primary key ,
%  client smallint ,   # references client.id
%  class smallint ,# references classtypes.id
%  place smallint ,# references places.id
%  instr smallint ,# references personnel.id
%  time datetime   # when
% 
% Don't you need some kind of duration? Or are the times fixed and you

No; everything is one hour.  Two hours is two bookings.

If that changes, I'll have to decide whether to use a datetime for the
end or just a duration...


% know beforehand when the class starting at x o'clock will end? And
% saving a number for the time slot would also work?

Saving a number?  I don't know what you mean here...


% 
...
%select * from schedule where client = '1' and time = '...' ;
...
%select * from schedule where instr = '1' and time = '...' ;
...
% 
% In the case of time slots, you could create a unique index on
% (client,time) and (instr,time) and skip the selects. Simply insert and
% check for an duplicate key error.

Hmmm...  OK; avoiding duplicates is the end goal and so I should probably
learn more about this apparently simple approach.

Um, what next? :-)  This is probably in the mysql doc, so a pointer would
be appreciated but know that I will [try to] look up multi-column indexes
and see how they deal with duplicates.


% 
%  that seems like it would get awfully slow as the table grows...
% 
% I wonder why you think so. Maybe I do not understand your concern
% correctly, but with the right indexes this shouldn't be slow. Do I
% miss something?

Probably not.  Quite on the contrary, I should probably start every post
with I am a newbie and don't know at all what I'm talking about, so
ignore my blatant errors and incorrect suggestions and just read my mind
instead :-)

I figured I'd have to check every record to see if the datetime and
client (or instructor) matched what I have already, and a few years from
now when that table is long it seems like that would take a while
(seconds? minutes? i dunno) to query...  Maybe not at all on such a
simple table (very short fixed-length fields, and not very many of them),
and maybe not with the indexes (hmmm... indices?) you mention above.

I know that mysql (like other databases) can handle umpteen million rows
in oodles of tables and such, perhaps with a bit of performance tuning,
but snappy response is very important for this application and I'll need
to at least design the database well to help ensure that.


% 
% If not: Whether an index (client,time) or (time,client) is better
% depends on your data (few or a lot of client, etc). If you don't have

I don't know exactly, but we're probably looking at a total of 3k or 4k
clients with some .5k actively making frequent bookings, and up to a
dozen instructors (per installation, which for starters will be a little
PII-266 with only 64M of RAM and a 5G IDE disk but will probably settle
on a cheapo PIII-800 with 128M and a 10G IDE disk at each studio).  Is
that a few or a lot?


% time slots, even (client) or (time) would help, although not as much.
% 
% I you are not sure, simply build all of them and look which one get
% used. Then dropped the other ones again. The same applies for instr.

That's a safe approach that should get the questions answered :-)


% 
%  Is this the sort of thing where a temporary table is advised, or
%  should I define a reverse table that shows each instructor and
%  his/her bookings, or what?
% 
% I am not sure how a temporary table would improve things. So we have
% some kind of misunderstanding. Could you post how you would use
% temporary tables here? Then I could easier tell, how I would do the
% same.

I don't even know; see my newbie comment above :-)  I thought that a
temporary table helps to speed up specific queries because the grouping
is already done and then you just select from that, but I dunno :-)


% 
% HTH,
% 
%   Benjamin.
% 
% -- 
% [EMAIL PROTECTED]


Thanks  HAND  Happy Holidays

:-D
- -- 
David T-G  * There is too much animal courage in 
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED]  -- Mary Baker Eddy, Science and Health
http://www.justpickone.org/davidtg/Shpx gur Pbzzhavpngvbaf Qrprapl Npg!

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.7 (FreeBSD)

iD8DBQE+D2d0Gb7uCXufRwARAkA9AJ4/j5DHIoEhMjRcU8HGl71jkGS3JgCgwfGZ
hZCRe+9AqoOV+pb7y/YG8sI=
=NsIe
-END PGP SIGNATURE-

-
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

Re: MySQL InnoDB

2002-12-29 Thread Stefan Hinz, iConnect \(Berlin\)

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
  FORM ACTION=p2 ?
  {go to p2.php}
  INSERT 1
  ROLLBACK;
  - THIS IS NOT WORKED !
  WHY ?

Because of the isolation level of transactions. Thread (client) 1
(p1.php) does not know about the queries / transactions of thread
(client) 2 (p2.php).

I don't know if there is a workaround for this, and even if there is a
need for a workaround. From all I know of your application (which is
little), I believe there's a problem with your application design.
Splitting up a transaction over two different scripts is IMHO no good
idea.

Regards,
--
  Stefan Hinz [EMAIL PROTECTED]
  Geschaftsfuhrer / CEO iConnect GmbH http://iConnect.de
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

- Original Message -
From: Andrew B. Sokov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, December 29, 2002 7:40 PM
Subject: MySQL InnoDB


 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
 
  All Actions - work OK - COMMIT  ROLLBACK
 
  But if i try use every Insert at defferent page (php)
 
  Like
  Page.php - has FORM ACTION=p1.php 
 
  p1.php - has
  SET COMMIT;
  INSERT 1
 
  FORM ACTION=p2 ?
 
  {go to p2.php}
 
  INSERT 1
  ROLLBACK;
 
  - THIS IS NOT WORKED !
  WHY ?
  Who can help me - and answer at my Question ?
 
  --
 Andrew B. Sokov

 

   Web-Media L.t.d. (812) 312-5309 27 äåêàáðÿ 2002 ã. 18:54
 
   URL:   http://www.Web-Media.ru
   e-mail:[EMAIL PROTECTED]
   ICQ UIN#   83040728
   phone: +7 (812) 312-5309
   fax:   +7 (812) 312-5309
 


 -
 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, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: An Idea

2002-12-29 Thread Stefan Hinz, iConnect \(Berlin\)

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-like information, but no real
FAQ.

Instead, we have this in every list mail:

 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

I would keep this shorter, saying Believe in God and do not sin ;-)

But seriously: Anybody here interested in setting up a FAQ on MySQL.com
/ MySQL.de,
- with silly common questions from this list,
- and with answers in small tutorial format (something like
http://www.mysql.com/articles/dotnet/index.html),
- well organized (one person to collect / insert the silly questions),
- easy to search (only search term + search by category),
- easy to maintain (e. g. with user comments, like the English manual),
- even easier to use as a referer than the MySQL manual when answering
questions?

Flame me if there _is_ a FAQ like this. At least I didn't find it at
MySQL.com, which is most probably the first place a new MySQL user would
look for it.

I am the German translator of the official MySQL manual, so I could
offer to translate as much as I can from the FAQ into German.

Regards,
--
  Stefan Hinz [EMAIL PROTECTED]
  Geschäftsführer / CEO iConnect GmbH http://iConnect.de
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

- Original Message -
From: Cal Evans [EMAIL PROTECTED]
To: Paul DuBois [EMAIL PROTECTED]; Adam Wi´ckowski
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Sunday, December 29, 2002 6:00 PM
Subject: RE: An Idea


 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 things about this list. We as a
 community of SQL developers (regardless of dialect) need to make a
more
 concentrated effort to explain the differences between desktop
databases and
 real database engines. We need to educate people making the changeover
 before releasing them into the wild. (Maybe the link to download MySql
could
 ask a few basic questions to prove you know what you are doing before
being
 allowed to download!)  :)

 I cut my teeth on FoxPro.  The first SQL I wrote was in the FoxPro
(2.5/6?)
 dialect. I know from whence I speak because I asked these same
questions
 many years ago.  Luckily, I found people who kindly but firmly pointed
me in
 the right direction. (You DON'T need gapless sequences for PK's.
You
 DON'T store images in the actual database without permission from
God.
 Here's the FAQ we developed so you don't have to waste our time
asking
 questions that have already been answered. Thank you, come again.)
They
 showed me the light and occasionally I try to share what little I know
with
 others.

 I guess what I'm trying to say is to those who know something (even if
you
 are like me and are constantly amazed at what you DON'T know) share
kindly
 and willingly. To those seeking enlightenment...RTFM you mook! Check
the
 !*#^ archives and use Google, this issue has been beat to death!

 Humbly,
 =C=
 *
 * Cal Evans
 * The Virtual CIO
 * http://www.calevans.com
 *


 -Original Message-
 From: Paul DuBois [mailto:[EMAIL PROTECTED]]
 Sent: Sunday, December 29, 2002 10:02 AM
 To: Adam Wi´ckowski; [EMAIL PROTECTED]
 Subject: Re: An Idea


 Why?


 -
 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, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Fatal error

2002-12-29 Thread Stefan Hinz, iConnect \(Berlin\)

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 [EMAIL PROTECTED]
  Geschäftsführer / CEO iConnect GmbH http://iConnect.de
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

- Original Message -
From: Doug Thompson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; Pikasz Gyorgy [EMAIL PROTECTED]
Sent: Sunday, December 29, 2002 8:58 PM
Subject: Re: Fatal error


 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 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 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
 
 Thanks
 
 picas



-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL InnoDB

2002-12-29 Thread Benjamin Pflugmann

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.

[...]
  But if i try use every Insert at defferent page (php)
 
  Like
  Page.php - has FORM ACTION=p1.php 
 
  p1.php - has
  SET COMMIT;
  INSERT 1
 
  FORM ACTION=p2 ?
 
  {go to p2.php}
 
  INSERT 1
  ROLLBACK;
 
  - THIS IS NOT WORKED !
  WHY ?

Because HTTP is a stateless protocol. After p1.php has been processed,
the connection to the MySQL server is closed (by PHP) and the
transaction rolled back automatically. p2.php gets *nothing* of the
state of p1.php, except for what you transfer as GET or POST
parameters (or Cookies).

It would make no difference if you stopped and restarted the Web
server in between your two page accesses. For more details, please
look up a PHP tutorial. I am sure they explain this behaviour.

HTH,

Benjamin.



PS: And no, persistent connections cannot be (mis-)used to get over
   that restriction. They only solve a performance issue.


-- 
[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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

I execute safe_mysqld and it deads

2002-12-29 Thread root

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 PROTECTED]
Originator:root
Organization:
 
MySQL support: none
Synopsis:  
Severity:  serious
Priority:  high
Category:  mysql
Class: sw-bug
Release:   mysql-3.23.54-max (Official MySQL-max binary)

Environment:
System: Linux localhost.localdomain 2.4.3-20mdk #1 Sun Apr 15 23:03:10 CEST 2001 i686 
unknown
Architecture: i686

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i586-mandrake-linux/2.96/specs
gcc version 2.96 2731 (Linux-Mandrake 8.0 2.96-0.48mdk)
Compilation info: CC='gcc'  CFLAGS='-O2 -mpentiumpro'  CXX='gcc'  CXXFLAGS='-O2 
-mpentiumpro -felide-constructors'  LDFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   13 jun 23  2002 /lib/libc.so.6 - libc-2.2.2.so
-rwxr-xr-x1 root root  1216268 feb 21  2001 /lib/libc-2.2.2.so
-rw-r--r--1 root root 26366908 feb 21  2001 /usr/lib/libc.a
-rw-r--r--1 root root  178 feb 21  2001 /usr/lib/libc.so
Configure command: ./configure '--prefix=/usr/local/mysql' '--with-comment=Official 
MySQL-max binary' '--with-extra-charsets=complex' '--with-server-suffix=-max' 
'--enable-thread-safe-client' '--enable-local-infile' '--enable-assembler' 
'--disable-shared' '--with-berkeley-db' '--with-client-ldflags=-all-static' 
'--with-mysqld-ldflags=-all-static' '--with-innodb' 'CFLAGS=-O2 -mpentiumpro' 
'CXXFLAGS=-O2 -mpentiumpro -felide-constructors' 'CXX=gcc'


-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: An Idea

2002-12-29 Thread Peter Lovatt

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 documentation is often technical to point that
it is difficult to understand, even as a reasonably competent database
programmer. I think newbies (and not so newbies) could feel totally
overwhelmed by much of it.

So (taking a deep breath !) I would be prepared to lay the foundations for a
faq / knowledge base aimed specifically at this type of questions and to
manage it.

So, any thoughts? Where do we go from here?

Peter

---
Excellence in internet and open source software
---
Sunmaia
Birmingham
UK
www.sunmaia.net
tel. 0121-242-1473
International +44-121-242-1473
---

-Original Message-
From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]]
Sent: 29 December 2002 22:01
To: Cal Evans; Paul DuBois; Adam Wi´ckowski; [EMAIL PROTECTED]
Subject: Re: An Idea


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-like information, but no real
FAQ.

Instead, we have this in every list mail:

 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

I would keep this shorter, saying Believe in God and do not sin ;-)

But seriously: Anybody here interested in setting up a FAQ on MySQL.com
/ MySQL.de,
- with silly common questions from this list,
- and with answers in small tutorial format (something like
http://www.mysql.com/articles/dotnet/index.html),
- well organized (one person to collect / insert the silly questions),
- easy to search (only search term + search by category),
- easy to maintain (e. g. with user comments, like the English manual),
- even easier to use as a referer than the MySQL manual when answering
questions?

Flame me if there _is_ a FAQ like this. At least I didn't find it at
MySQL.com, which is most probably the first place a new MySQL user would
look for it.

I am the German translator of the official MySQL manual, so I could
offer to translate as much as I can from the FAQ into German.

Regards,
--
  Stefan Hinz [EMAIL PROTECTED]
  Geschäftsführer / CEO iConnect GmbH http://iConnect.de
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

- Original Message -
From: Cal Evans [EMAIL PROTECTED]
To: Paul DuBois [EMAIL PROTECTED]; Adam Wi´ckowski
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Sunday, December 29, 2002 6:00 PM
Subject: RE: An Idea


 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 things about this list. We as a
 community of SQL developers (regardless of dialect) need to make a
more
 concentrated effort to explain the differences between desktop
databases and
 real database engines. We need to educate people making the changeover
 before releasing them into the wild. (Maybe the link to download MySql
could
 ask a few basic questions to prove you know what you are doing before
being
 allowed to download!)  :)

 I cut my teeth on FoxPro.  The first SQL I wrote was in the FoxPro
(2.5/6?)
 dialect. I know from whence I speak because I asked these same
questions
 many years ago.  Luckily, I found people who kindly but firmly pointed
me in
 the right direction. (You DON'T need gapless sequences for PK's.
You
 DON'T store images in the actual database without permission from
God.
 Here's the FAQ we developed so you don't have to waste our time
asking
 questions that have already been answered. Thank you, come again.)
They
 showed me the light and occasionally I try to share what little I know
with
 others.

 I guess what I'm trying to say is to those who know something (even if
you
 are like me and are constantly amazed at what you DON'T know) share
kindly
 and willingly. To those seeking enlightenment...RTFM you mook! Check
the
 !*#^ archives and use Google, this issue has been beat to death!

 Humbly,
 =C=
 *
 * Cal Evans
 * The Virtual CIO
 * http://www.calevans.com
 *


 -Original Message-
 From: Paul DuBois [mailto:[EMAIL PROTECTED]]
 Sent: Sunday, December 29, 2002 10:02 AM
 To: Adam Wi´ckowski; [EMAIL PROTECTED]
 Subject: Re: An Idea


 Why?


 -
 Before posting, please

Re: MySQL 4.0.7 is released

2002-12-29 Thread Ray Kiddy

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 which you are announcing? For example, since 
http://www.mysql.com/downloads/ does not point to the 4.0.7 version, 
which page does?

thanx - ray

On Friday, December 27, 2002, at 12:10 PM, Lenz Grimmer wrote:

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi,

MySQL 4.0.7, a new version of the popular Open Source Database, has 
been
released. It is now available in source and binary form for a number of
platforms from our download pages at http://www.mysql.com/downloads/ 
and
mirror sites.

snip


-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: An Idea

2002-12-29 Thread JamesD

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 breath below :-)

like any book, to drive through it all the way, inch
by inch, and learn, takes some time and focus.

James Danforth,COO
Neovi Data Corp
www.qchex.com


-Original Message-
From: Peter Lovatt [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 29, 2002 4:18 PM
To: Stefan Hinz, iConnect (Berlin); Cal Evans; Paul DuBois; Adam
Wi´ckowski; [EMAIL PROTECTED]
Subject: RE: An Idea


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 documentation is often technical to point that
it is difficult to understand, even as a reasonably competent database
programmer. I think newbies (and not so newbies) could feel totally
overwhelmed by much of it.

So (taking a deep breath !) I would be prepared to lay the foundations for a
faq / knowledge base aimed specifically at this type of questions and to
manage it.

So, any thoughts? Where do we go from here?

Peter

---
Excellence in internet and open source software
---
Sunmaia
Birmingham
UK
www.sunmaia.net
tel. 0121-242-1473
International +44-121-242-1473
---

-Original Message-
From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]]
Sent: 29 December 2002 22:01
To: Cal Evans; Paul DuBois; Adam Wi´ckowski; [EMAIL PROTECTED]
Subject: Re: An Idea


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-like information, but no real
FAQ.

Instead, we have this in every list mail:

 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

I would keep this shorter, saying Believe in God and do not sin ;-)

But seriously: Anybody here interested in setting up a FAQ on MySQL.com
/ MySQL.de,
- with silly common questions from this list,
- and with answers in small tutorial format (something like
http://www.mysql.com/articles/dotnet/index.html),
- well organized (one person to collect / insert the silly questions),
- easy to search (only search term + search by category),
- easy to maintain (e. g. with user comments, like the English manual),
- even easier to use as a referer than the MySQL manual when answering
questions?

Flame me if there _is_ a FAQ like this. At least I didn't find it at
MySQL.com, which is most probably the first place a new MySQL user would
look for it.

I am the German translator of the official MySQL manual, so I could
offer to translate as much as I can from the FAQ into German.

Regards,
--
  Stefan Hinz [EMAIL PROTECTED]
  Geschäftsführer / CEO iConnect GmbH http://iConnect.de
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

- Original Message -
From: Cal Evans [EMAIL PROTECTED]
To: Paul DuBois [EMAIL PROTECTED]; Adam Wi´ckowski
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Sunday, December 29, 2002 6:00 PM
Subject: RE: An Idea


 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 things about this list. We as a
 community of SQL developers (regardless of dialect) need to make a
more
 concentrated effort to explain the differences between desktop
databases and
 real database engines. We need to educate people making the changeover
 before releasing them into the wild. (Maybe the link to download MySql
could
 ask a few basic questions to prove you know what you are doing before
being
 allowed to download!)  :)

 I cut my teeth on FoxPro.  The first SQL I wrote was in the FoxPro
(2.5/6?)
 dialect. I know from whence I speak because I asked these same
questions
 many years ago.  Luckily, I found people who kindly but firmly pointed
me in
 the right direction. (You DON'T need gapless sequences for PK's.
You
 DON'T store images in the actual database without permission from
God.
 Here's the FAQ we developed so you don't have to waste our time
asking
 questions that have already been answered. Thank you, come again.)
They
 showed me the light and occasionally I try to share

reset auto-increment value

2002-12-29 Thread Carlin Anderson

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, 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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Fulltext search of words 3 chars in 3.23

2002-12-29 Thread Frank Peavy

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


-Original Message-
From: JamesD [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 28, 2002 10:48 PM
To: Frank Peavy; [EMAIL PROTECTED]
Subject: RE: Fulltext search of words  3 chars in 3.23


You need to use the REGEXP capability instead of Like in a where clause

select 'field(s)' from 'table' where 'field' REGEXP '^[a-z]{1,3}$';

Jim

-Original Message-
From: Frank Peavy [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 28, 2002 6:55 PM
To: [EMAIL PROTECTED]
Subject: Fulltext search of words  3 chars in 3.23


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 searches on acronyms
like php.
Thanks.


-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL 4.0.7 is released

2002-12-29 Thread Richard Clarke

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 PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, December 30, 2002 12:57 AM
Subject: Re: MySQL 4.0.7 is released

 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 which you are announcing? For example, since 
 http://www.mysql.com/downloads/ does not point to the 4.0.7 version, 
 which page does?

 thanx - ray

 On Friday, December 27, 2002, at 12:10 PM, Lenz Grimmer wrote:

  -BEGIN PGP SIGNED MESSAGE-
  Hash: SHA1

  Hi,

  MySQL 4.0.7, a new version of the popular Open Source Database, has 
  been
  released. It is now available in source and binary form for a number of
  platforms from our download pages at http://www.mysql.com/downloads/ 
  and
  mirror sites.

  snip

 -
 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, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: An Idea

2002-12-29 Thread Peter Lovatt

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 first steps) will be able or want to pay over $40 for a
book (though I agree it is good value if you do)

Peter



---
Excellence in internet and open source software
---
Sunmaia
Birmingham
UK
www.sunmaia.net
tel. 0121-242-1473
International +44-121-242-1473
---

-Original Message-
From: JamesD [mailto:[EMAIL PROTECTED]]
Sent: 30 December 2002 01:35
To: Peter Lovatt; [EMAIL PROTECTED]
Subject: RE: An Idea


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 breath below :-)

like any book, to drive through it all the way, inch
by inch, and learn, takes some time and focus.

James Danforth,COO
Neovi Data Corp
www.qchex.com


-Original Message-
From: Peter Lovatt [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 29, 2002 4:18 PM
To: Stefan Hinz, iConnect (Berlin); Cal Evans; Paul DuBois; Adam
Wi´ckowski; [EMAIL PROTECTED]
Subject: RE: An Idea


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 documentation is often technical to point that
it is difficult to understand, even as a reasonably competent database
programmer. I think newbies (and not so newbies) could feel totally
overwhelmed by much of it.

So (taking a deep breath !) I would be prepared to lay the foundations for a
faq / knowledge base aimed specifically at this type of questions and to
manage it.

So, any thoughts? Where do we go from here?

Peter

---
Excellence in internet and open source software
---
Sunmaia
Birmingham
UK
www.sunmaia.net
tel. 0121-242-1473
International +44-121-242-1473
---

-Original Message-
From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]]
Sent: 29 December 2002 22:01
To: Cal Evans; Paul DuBois; Adam Wi´ckowski; [EMAIL PROTECTED]
Subject: Re: An Idea


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-like information, but no real
FAQ.

Instead, we have this in every list mail:

 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

I would keep this shorter, saying Believe in God and do not sin ;-)

But seriously: Anybody here interested in setting up a FAQ on MySQL.com
/ MySQL.de,
- with silly common questions from this list,
- and with answers in small tutorial format (something like
http://www.mysql.com/articles/dotnet/index.html),
- well organized (one person to collect / insert the silly questions),
- easy to search (only search term + search by category),
- easy to maintain (e. g. with user comments, like the English manual),
- even easier to use as a referer than the MySQL manual when answering
questions?

Flame me if there _is_ a FAQ like this. At least I didn't find it at
MySQL.com, which is most probably the first place a new MySQL user would
look for it.

I am the German translator of the official MySQL manual, so I could
offer to translate as much as I can from the FAQ into German.

Regards,
--
  Stefan Hinz [EMAIL PROTECTED]
  Geschäftsführer / CEO iConnect GmbH http://iConnect.de
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

- Original Message -
From: Cal Evans [EMAIL PROTECTED]
To: Paul DuBois [EMAIL PROTECTED]; Adam Wi´ckowski
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Sunday, December 29, 2002 6:00 PM
Subject: RE: An Idea


 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 things about this list. We as a
 community of SQL developers (regardless of dialect) need to make a
more
 concentrated effort to explain the differences

RE: An Idea

2002-12-29 Thread Cal Evans

Paul's book is an excellent one.

I also recommend (to anyone who asks):
http://froogle.google.com/froogle?q=%22SQL+For+Dummies%22btnG=Froogle+Searc
h
and
http://froogle.google.com/froogle?q=%22SQL+For+Smarties%22btnG=Froogle+Sear
ch


2 more excellent resources.

*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*


-Original Message-
From: JamesD [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 29, 2002 7:35 PM
To: Peter Lovatt; [EMAIL PROTECTED]
Subject: RE: An Idea


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 breath below :-)

like any book, to drive through it all the way, inch
by inch, and learn, takes some time and focus.

James Danforth,COO
Neovi Data Corp
www.qchex.com


-Original Message-
From: Peter Lovatt [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 29, 2002 4:18 PM
To: Stefan Hinz, iConnect (Berlin); Cal Evans; Paul DuBois; Adam
Wi´ckowski; [EMAIL PROTECTED]
Subject: RE: An Idea


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 documentation is often technical to point that
it is difficult to understand, even as a reasonably competent database
programmer. I think newbies (and not so newbies) could feel totally
overwhelmed by much of it.

So (taking a deep breath !) I would be prepared to lay the foundations for a
faq / knowledge base aimed specifically at this type of questions and to
manage it.

So, any thoughts? Where do we go from here?

Peter

---
Excellence in internet and open source software
---
Sunmaia
Birmingham
UK
www.sunmaia.net
tel. 0121-242-1473
International +44-121-242-1473
---

-Original Message-
From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]]
Sent: 29 December 2002 22:01
To: Cal Evans; Paul DuBois; Adam Wi´ckowski; [EMAIL PROTECTED]
Subject: Re: An Idea


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-like information, but no real
FAQ.

Instead, we have this in every list mail:

 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

I would keep this shorter, saying Believe in God and do not sin ;-)

But seriously: Anybody here interested in setting up a FAQ on MySQL.com
/ MySQL.de,
- with silly common questions from this list,
- and with answers in small tutorial format (something like
http://www.mysql.com/articles/dotnet/index.html),
- well organized (one person to collect / insert the silly questions),
- easy to search (only search term + search by category),
- easy to maintain (e. g. with user comments, like the English manual),
- even easier to use as a referer than the MySQL manual when answering
questions?

Flame me if there _is_ a FAQ like this. At least I didn't find it at
MySQL.com, which is most probably the first place a new MySQL user would
look for it.

I am the German translator of the official MySQL manual, so I could
offer to translate as much as I can from the FAQ into German.

Regards,
--
  Stefan Hinz [EMAIL PROTECTED]
  Geschäftsführer / CEO iConnect GmbH http://iConnect.de
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

- Original Message -
From: Cal Evans [EMAIL PROTECTED]
To: Paul DuBois [EMAIL PROTECTED]; Adam Wi´ckowski
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Sunday, December 29, 2002 6:00 PM
Subject: RE: An Idea


 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 things about this list. We as a
 community of SQL developers (regardless of dialect) need to make a
more
 concentrated effort to explain the differences between desktop
databases and
 real database engines. We need to educate people making the changeover
 before releasing them into the wild. (Maybe the link to download MySql
could
 ask a few basic questions to prove you know what you are doing before
being
 allowed to download!)  :)

 I cut my teeth on FoxPro.  The first SQL I wrote was in the FoxPro
(2.5/6?)

Dropping Tables

2002-12-29 Thread Steve Buehler

	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 meant to 
be temporary but can't actually create TEMPORARY tables to do the 
job.  That isn't the problem in itself.  The problem is that sometimes if 
the script is stopped prematurely, it doesn't get to the drop table 
function in it.  All of the tables that are created for this start with an 
a and follow with a random number.  What I need to do is to create a 
script that I can run that will delete all tables that start with an a in 
the database.  Again, since the table name is randomly generated except for 
the starting a, I will need the script to find them and drop them.
	Has anybody done this before?  I would sure appreciate some help here.

Thanks
Steve


--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
ow3


-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: [PHP] Dropping Tables

2002-12-29 Thread Steve Buehler

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 or not?  Will you be
dropping a table that someone is actually using?


I will be shutting down the script at a certain time each day to run some 
things like this for maintenance.  So none of these should be active and if 
they are, it won't hurt anything.   The customer can just wait until the 
maintenance time is over.  Approximately 10 mintues.

At 10:21 PM 12/29/2002 -0500, you wrote:
 Basically just do a a php script the sends the sql show tables;

 Then do a strchr() to see if a is the first letter in the resuts and
if
 so do a delete table.

 Just yo play safe do a dump of your db first.


Or even better, use SHOW TABLES LIKE 'a%' to just get the a* tables and
drop each one.

How do you know whether it's an active a* table or not? Will you be
dropping a table that someone is actually using?

---John W. Holmes...

PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
ow3




--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
ow3


-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Storing a SHA1 checksum

2002-12-29 Thread Paul DuBois

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, 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.


SHA1() returns a string of 40 hexadecimal digits.  There won't be trailing
spaces.

Are you converting the hex string to some other representation before
storing it?



What should I do? It seems I can:

1. Use blob instead of varchar.
   Problem: blob type is slower.

2. Make my application pad the checksum out to 20 spaces.
   Problem: Increases my code complexity a bit.

3. Wait for MySQL to fix the strip trailing spaces bug.
   Problem: That doesn't provide an immediate solution.



-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Storing a SHA1 checksum

2002-12-29 Thread Philip Mak

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 VARCHAR(20), when SHA1() returns a 40-byte
 string.
 
 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.
 
 SHA1() returns a string of 40 hexadecimal digits.  There won't be trailing
 spaces.
 
 Are you converting the hex string to some other representation before
 storing it?

Yes, I'm converting it to a binary representation first, so that it
only takes 20 bytes instead of 40 bytes.

I ended up using a TINYBLOB to store my checksum, since performance
shouldn't be overly critical in my application.

-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Storing a SHA1 checksum

2002-12-29 Thread Paul DuBois

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, but I'm
 curious why you're using a VARCHAR(20), when SHA1() returns a 40-byte
 string.
 
 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.

 SHA1() returns a string of 40 hexadecimal digits.  There won't be trailing
 spaces.

 Are you converting the hex string to some other representation before
 storing it?


Yes, I'm converting it to a binary representation first, so that it
only takes 20 bytes instead of 40 bytes.


Okay.  I see then why you might end up with trailing 'spaces'.



I ended up using a TINYBLOB to store my checksum, since performance
shouldn't be overly critical in my application.


Sounds like a good choice.

-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: An Idea (really: MySQL and Perl for the Web)

2002-12-29 Thread JamesD

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 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-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 breath below :-)

I of course appreciate it when people purchase a copy of the book,
but for those who prefer to take a look at part of it first,
I will point out that there is a sample chapter available online
at:

http://www.kitebird.com/mysql-perl/

It's a 78-page PDF, and it deals with a number of questions that probably
would come up in a FAQ, but in more detail.  For example, it answers the
oft-posed questions: how do I store images in MySQL? and how do I retrieve
images from MySQL for display in a Web page?  The sample code that
implements
the answers to these questions is also available at the URL above, as are
some sample applications. (One of which is an e-card thing that demonstrates
image retrieval and display.)

I guess that's enough shameless plugging for now. :-)

like any book, to drive through it all the way, inch
by inch, and learn, takes some time and focus.

James Danforth,COO
Neovi Data Corp
www.qchex.com

-Original Message-
From: Peter Lovatt [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 29, 2002 4:18 PM
To: Stefan Hinz, iConnect (Berlin); Cal Evans; Paul DuBois; Adam
Wi´ckowski; [EMAIL PROTECTED]
Subject: RE: An Idea

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 documentation is often technical to point
that
it is difficult to understand, even as a reasonably competent database
programmer. I think newbies (and not so newbies) could feel totally
overwhelmed by much of it.

So (taking a deep breath !) I would be prepared to lay the foundations for
a
faq / knowledge base aimed specifically at this type of questions and to
manage it.

So, any thoughts? Where do we go from here?

Peter

---
Excellence in internet and open source software
---
Sunmaia
Birmingham
UK
www.sunmaia.net
tel. 0121-242-1473
International +44-121-242-1473
---

-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: reset auto-increment value

2002-12-29 Thread Paul DuBois

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 table type.

For ISAM tables, if you delete all the records, that will automatically
reset the counter.

For MyISAM tables, you can delete all the records, then use:
ALTER TABLE tbl_name AUTO_INCREMENT = 1
which will reset the counter.

If what you mean is that you want to leave the existing records intact, but
resequence the AUTO_INCREMENT column so that the sequence doesn't
have holes in it, then I'd ask:  why bother?



Thanks
Carlin Anderson




-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Fulltext search of words 3 chars in 3.23

2002-12-29 Thread Paul DuBois

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 wasn't implemented until 4.x.



Mike Hillyer


-Original Message-
From: Frank Peavy [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 28, 2002 7:55 PM
To: [EMAIL PROTECTED]
Subject: Fulltext search of words  3 chars in 3.23


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 searches on acronyms
like php.
Thanks.



-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Fulltext search of words 3 chars in 3.23

2002-12-29 Thread Paul DuBois

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 source modification plus a recompile.  If you can't recompile,
you can't change the word length.




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


-Original Message-
From: JamesD [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 28, 2002 10:48 PM
To: Frank Peavy; [EMAIL PROTECTED]
Subject: RE: Fulltext search of words  3 chars in 3.23


You need to use the REGEXP capability instead of Like in a where clause

select 'field(s)' from 'table' where 'field' REGEXP '^[a-z]{1,3}$';

Jim

-Original Message-
From: Frank Peavy [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 28, 2002 6:55 PM
To: [EMAIL PROTECTED]
Subject: Fulltext search of words  3 chars in 3.23


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 searches on acronyms
like php.
Thanks.



-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: An Idea (really: MySQL and Perl for the Web)

2002-12-29 Thread Paul DuBois

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-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 breath below :-)


I of course appreciate it when people purchase a copy of the book,
but for those who prefer to take a look at part of it first,
I will point out that there is a sample chapter available online
at:

http://www.kitebird.com/mysql-perl/

It's a 78-page PDF, and it deals with a number of questions that probably
would come up in a FAQ, but in more detail.  For example, it answers the
oft-posed questions: how do I store images in MySQL? and how do I retrieve
images from MySQL for display in a Web page?  The sample code that implements
the answers to these questions is also available at the URL above, as are
some sample applications. (One of which is an e-card thing that demonstrates
image retrieval and display.)

I guess that's enough shameless plugging for now. :-)



like any book, to drive through it all the way, inch
by inch, and learn, takes some time and focus.

James Danforth,COO
Neovi Data Corp
www.qchex.com


-Original Message-
From: Peter Lovatt [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 29, 2002 4:18 PM
To: Stefan Hinz, iConnect (Berlin); Cal Evans; Paul DuBois; Adam
Wi´ckowski; [EMAIL PROTECTED]
Subject: RE: An Idea


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 documentation is often technical to point that
it is difficult to understand, even as a reasonably competent database
programmer. I think newbies (and not so newbies) could feel totally
overwhelmed by much of it.

So (taking a deep breath !) I would be prepared to lay the foundations for a
faq / knowledge base aimed specifically at this type of questions and to
manage it.

So, any thoughts? Where do we go from here?

Peter

---
Excellence in internet and open source software
---
Sunmaia
Birmingham
UK
www.sunmaia.net
tel. 0121-242-1473
International +44-121-242-1473
---




-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

replication

2002-12-29 Thread Maxime LEMAIRE

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 server1 for the
same table on the same database. Both server are connected together.
At this point, there's no problem, the two server shares the same identity
and the key grows up with new record.

But, now, suppose that the connection between server1 and server2 is broken
(Two different site for example and the link
between site goes down) during one hour or one day.
On each server, people insert records because both of them continious to see
the server assigned to their site.
When the link go up again, and the server will begin to replicate data.How
the identity created will be reassigned or affected ?

Does both mySQL server had assigned the same key ?
Is there some solution to manage this problem ?
What are you thinking of this problem ?
What are you thinking of Britney Spears ? ;o)

This solution is going to be implemented in high critical environmment, with
100 percent uptime needed, that's why we want to be sure we use the better
solution.

Thanks for your answer.



-
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, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

75 matches

Mail list logo