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
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
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
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
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]
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
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
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
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
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]
Ö©ÖëÍøÍø¿¯-ÌØ¿¯ºÅ£¬»áÔ±·¢Õ¹°æ
ÒÔÏÂÄÚÈݽöÏÞÖйú´ó½µØÇø£¬ÎÄÖÐËùÉæ¼°Ö®¼ÓÃ˽ð¡£ÀÍÎñ½ðµÈ¾ùÒÔÈËÃñ±Ò¼Æ¡£
¿ªÆªÓï
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
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.
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
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
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
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
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
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
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
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
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
You just need to snag the website once you have published it or at least
have it running on a server somewhere. The result should be standard html
no need for MySQL or PHP on the CD.
Hope this helps
Pat...
- Original Message -
From: databarn [EMAIL PROTECTED]
To: MySQL [EMAIL
Hi 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:
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
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
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
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 =
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
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
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: 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
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
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)
--
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.
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
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
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
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
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
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
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
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
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 -
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
--
//
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
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
-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
-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
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
-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
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;
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
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
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.
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
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
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
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
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,
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
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];
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
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
*
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
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
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
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),
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
we are all in sales, 24/7. :-)
Jim
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 29, 2002 9:24 PM
To: JamesD; Peter Lovatt; [EMAIL PROTECTED]
Subject: RE: An Idea (really: MySQL and Perl for the Web)
At 17:35 -0800 12/29/02, JamesD wrote:
while
At 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
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
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
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
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
75 matches
Mail list logo