Chris Bolt wrote:
>>Assuming any SQL statement that causes the mysqld to go away is a bug:
>>
>>Assume table foo has a column bar bigint(20);
>>
>>select * from foo where bar = 0x7fff;
>>
>>The above works fine. The below crashes the server:
>>
>>select * from foo where bar = 922337
Good afternoon,
We have an not-so-unusual problem where people are accessing a database from
different countries (in this example, Germany and the UK). One of the search
terms commonly used is: gehäuse (housing), which the UK types in as gehause
and Germany (rightly of course) insists the word is
In the last episode (Jun 15), Jeremy Zawodny said:
> The manual (http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html) states:
>
> If an in-memory temporary table exceeds this size, MySQL will
> automatically convert it to an on-disk MyISAM table. Increase the
> value of tmp_table_size if you d
> Assuming any SQL statement that causes the mysqld to go away is a bug:
>
> Assume table foo has a column bar bigint(20);
>
> select * from foo where bar = 0x7fff;
>
> The above works fine. The below crashes the server:
>
> select * from foo where bar = 9223372036854775807;
>
> They
At 11:55 PM -0500 6/15/01, Rory O'Connor wrote:
>I am using a PHP script and a separate perl script, and they are
>operating on the same MySQL database. I am fairly new to MySQL (and
>programming in general), and I'm wondering if this could cause any
>problems - especially during peak traffic tim
Hi.
Do you have an index SIC? If so, I don't know any reason which would
explain such a slow server for such a simple query (on a table with
only 9.000 records), no matter what the configuration is.
If SIC is one of those unidexed decimals, the speed may be expected,
depending on the database si
Hello Benjamin.
I forgot to mention that there could be items from multiple posters in each folder so
the query you sent worked on those cases just like the old query. However looking at
your nicely formatted example made me realize what I needed to do.
By concatenating the poster_name in fron
On Fri, Jun 15, 2001 at 05:51:11PM -0600, Chris Cameron wrote:
>
> I compiled MySQL 3.23.37 myself with -O6's -march-i586 and various
> ./configure options I don't remeber. The database I'm using has 3
> tables of about 9 thousand entries, un-indexed decimal(5,8)'s, and a
> few tinytext's. There
Hi.
On Fri, Jun 15, 2001 at 02:13:27PM +0530, [EMAIL PROTECTED] wrote:
[...]
> update travel set nome_hotel=hotel.id where
> hotel.hotelname=travel.nome_hotel.
>
> It does not work. What would be the corret way?
>
> > SELECT t.id, h.hotelname from travel t, hotel h where t.nome_hotel =
> > h.h
Hi,
I have Visual Fox Pro and I can acces MySql Databases using view's - MyODBC,
all works fine, but I hear about access MySql without using ODBC for better
result (speed), So, Can I do this from Visual Fox Pro? and How?
thanks.
jevr.-
--
Hello.
On Thu, Jun 14, 2001 at 11:33:42AM +0530, [EMAIL PROTECTED] wrote:
> Hi Benjamin,
>
> On Wed, 13 Jun 2001, Benjamin Pflugmann wrote:
>
> > Sounds as if you have to install a newer MySQL package. Use
>
> Seems like. Which is the stable version now?
I don't know of any major problems si
On Fri, Jun 15, 2001 at 04:22:55PM -0400, Seth wrote:
>
> Just wondering if there is a way to limit the number of connections
> to a particular database without starting up another server to run
> that database specifically.
This isn't exactly what you want, but you CAN limit the number of
connec
When I do the following query I get seemingly arbitrary results for most of the
columns.
SELECT f.folder_name, COUNT(g.post_id), n.poster_name, p.file_name
FROM users u, folders f, users_to_files g, posts p, posters n
WHERE f.user_id = u.user_id AND u.user_id = 1 AND g.folder_id=f.folder_id
I am using a PHP script and a separate perl script, and they are
operating on the same MySQL database. I am fairly new to MySQL (and
programming in general), and I'm wondering if this could cause any
problems - especially during peak traffic times. Are there measures I
should be taking to minimi
The manual (http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html) states:
If an in-memory temporary table exceeds this size, MySQL will
automatically convert it to an on-disk MyISAM table. Increase the
value of tmp_table_size if you do many advanced GROUP BY queries and
you have lots of memor
Hello.
On Fri, Jun 15, 2001 at 01:54:19AM +0800, [EMAIL PROTECTED] wrote:
[...]
> > And if you compile it with a compiler straight from CVS, this is infinite
> > trouble. I am surprised it ran at all... :-)
>
> The guys in debian-devel said the CVS gcc ( unlike the one in Redhat 7.0 )
> will
Hi all
What is useful for mysql.sock in the tmp directory?
Could I delete it?
and
Do you know where I can get mysql odbc and JDBC? Are they free?
tks
regards
Peter
-
Before posting, please check:
http://www.mysql.com/man
Hello Sam.
On Fri, Jun 15, 2001 at 03:54:55PM -0700, [EMAIL PROTECTED] wrote:
>
> When I do the following query I get seemingly arbitrary results for most of the
>columns.
>
> SELECT f.folder_name, COUNT(g.post_id), n.poster_name, p.file_name
> FROM users u, folders f, users_to_files g, posts
Assuming any SQL statement that causes the mysqld to go away is a bug:
Assume table foo has a column bar bigint(20);
select * from foo where bar = 0x7fff;
The above works fine. The below crashes the server:
select * from foo where bar = 9223372036854775807;
They are equivalent.
Hello Simon.
On Fri, Jun 15, 2001 at 05:08:18PM -0400, [EMAIL PROTECTED] wrote:
> Could not find a bug report form. So I am telling y'll...
>
> Platform: FreeBSD 4.3 (I do not think it matters)
>
> After creating a new database, I ran:
>
> update user set password = 'SomeJunk' where user = '
>> In a slight change of this question (since I have no data to
>> currently test this with, as my ISP is using too old a
>> version of mysql), does anyone know what something like
>> this would do?
>>
>> SELECT * FROM theTable ORDER BY RAND(), date LIMIT 5;
>
> Exactly the same as SELECT * FROM
[EMAIL PROTECTED] wrote:
> Hello all,
>
> Without explicitly creating foreign keys, what is the most common
method to
> create a truly relational database that enforces referential
integrity?
>
> Any responses to this question are greatly appreciated!
>
> Sincerely,
>
> N. Silverwise
>
Referenti
Hi all,
I downloaded the both
mysql-3.23.39-sun-solaris2.7-sparc.tar.gz
mysqlgui-solaris-2.7-sparc-static-1.6
a few days ago.
While the sql server is running fine, I cannot get the gui to work.
I gunziped it and made it executable using chmod u+x filename. After
that when I try to run it in a
I'm currently using a 166 UNIX machine for a dedicated MySQL database,
and I'm interested in knowing what kind of speed I should be expecting
from it. I ask because right now it's at a point of being unusable even
for development on some of the larger queries.
I compiled MySQL 3.23.37 myself with
I'm using Visual Basic with DAO 3.6 and I try to execute this query
dim rsPersonen as dao.recordset
Set rsPersonen = db.OpenRecordset( _
"SELECT Mitglieder.* FROM Mitglieder " + _
"WHERE Mitglieder.geb='1978-08-26'")
Here I get an Error-Message:
"Runtime-Error 3464, ..."
If I use any other SQL
> Gotcha. So is there any way to return 5 (some number) rows, chosen
> randomly, and then sort them by date (or name or whatever). So the final
> result is a list, sorted by date, but of rows chosen randomly from the
> table.
CREATE TEMPORARY TABLE temptable TYPE=HEAP SELECT * FROM theTable ORD
it also was my first idea to check /var/log/messages
immediately, but nothing in there.
we now run our servers as diskless machines over nfs
on the netapp filer for +6 month and no errors at all,
on any of the machines.
regards
Sven Huster
Senior IT Systems Engineer
> -Original Message--
Hello Support
I'm new comer in MySQL and its ODBC driver. I tried connect MySQL into
Access and Visual Basic with MyODBC. I'm not change any option on MyODBC,
but its table can't updateable. Can I use this table to add or remove
records? How?
Thanks
Lucia
--
> After creating a new database, I ran:
>
> update user set password = 'SomeJunk' where user = 'root';
>
> This inserts the string 'SomeJunk' literally into the database,
> unencrypted. This is SQL expected but the result is a database
> lockout (not to mention the security breach of having the c
>I'm using Visual Basic with DAO 3.6 and I try to execute this query
>
>dim rsPersonen as dao.recordset
> Set rsPersonen = db.OpenRecordset( _
> "SELECT Mitglieder.* FROM Mitglieder " + _
> "WHERE Mitglieder.geb='1978-08-26'")
>
>Here I get an Error-Message:
>
>"Runtime-Error 3
PLEASE read the manual. you need to
set password = password('SomeJunk')
And the bug report form can be obtained by running mysqlbug, the instructions
for which are also found in the manual.
Thank you.
j- k-
On Friday 15 June 2001 13:08, Simon Shapiro wrote:
> Could not find a bug r
Could not find a bug report form. So I am telling y'll...
Platform: FreeBSD 4.3 (I do not think it matters)
After creating a new database, I ran:
update user set password = 'SomeJunk' where user = 'root';
This inserts the string 'SomeJunk' literally into the database,
unencrypted. This is S
That should work.
What OS, kernel, version, compiler are you using?
kitty79 wrote:
> hi folks,
> i have the following table (table_name=comment)
> +-+--+--+-++
> +
> | Field | Type | Null | Key | Default| Extra
Greg Stienstra <[EMAIL PROTECTED]> writes:
> I have been unsuccessful doing a make for mysql-3-23.29 using redhat 7.1 on an
> Intel Pentium with 64 megabytes. There seems to be a problem with file db.h. I
> am doing the install from the source tarball mysql-3.23.39.tar.gz , not the RPM.
It compi
On Fri, Jun 15, 2001 at 12:53:04PM -0600, Chris Bolt wrote:
> > Is this machine basically dedicated to MySQL? If so, I'd try bumping
> > up the record_buffer to 16 or 32MB and see what that does. I've got it
> > set at 32MB on a server with 1GB of RAM.
>
> I'm looking at my-huge.cnf included with
Just wondering if there is a way to limit the number of connections to a
particular database without starting up another server to run that database
specifically.
-
Before posting, please check:
http://www.mysql.com/manual.ph
> In a slight change of this question (since I have no data to
> currently test this with, as my ISP is using too old a
> version of mysql), does anyone know what something like
> this would do?
>
> SELECT * FROM theTable ORDER BY RAND(), date LIMIT 5;
Exactly the same as SELECT * FROM theTable O
Is there a particular reason why you want the images in a mysql database.
It would be faster if you put that path to the images in a table then the
actual images.
Mat
- Original Message -
From: "Kevin Pratt" <[EMAIL PROTECTED]>
To: "Mysql List" <[EMAIL PROTECTED]>
Sent: Friday, June 15,
This topic has been covered many times - check the PHP-General mailing list
archives (http://marc.theaimsgroup.com/?l=php-general)
--zak
- Original Message -
From: "Kevin Pratt" <[EMAIL PROTECTED]>
To: "Mysql List" <[EMAIL PROTECTED]>
Sent: Friday, June 15, 2001 12:25 PM
Subject: PHP a
Why would you want to do that? That's what filesystems are for.
> Can any one tell me how place images in to a mysql database and then
> retrieve them later?
-
Before posting, please check:
http://www.mysql.com/manual.php
http://marc.theaimsgroup.com/?l=mysql&m=99213870412899&w=2
http://marc.theaimsgroup.com/?l=mysql&m=99214323317893&w=2
http://www.bolt.cx/misc/thread.txt
> hi,
>
> how can i make recursive querys in mysql?
> i want to show a tree.
>
> my table:
> tree (id int, parent int, name char(10));
...
> t
Dan,
I see. My automake/autoconf script currently checks if there
exists fdatasync, and if not then it uses fsync. So we know
now that it calls fsync. I wrote to Steve and asked him to compile
a version where he sees the error number from fsync.
Thank you for the FreeBSD info.
Heikki
-Orig
Hello
I created a perl script that might help. Because I like to have a full backup
of my databases and table backups (I know I can split the full backup, but
I'm too lazy ;), I created a perl script that queries MySQL for the table
names in the database and then creates a shell script with in
I have been unsuccessful doing a make for mysql-3-23.29 using redhat 7.1 on an
Intel Pentium with 64 megabytes. There seems to be a problem with file db.h. I
am doing the install from the source tarball mysql-3.23.39.tar.gz , not the RPM.
Here is an excerpt from the session:
(lines cut, inclu
> Is this machine basically dedicated to MySQL? If so, I'd try bumping
> up the record_buffer to 16 or 32MB and see what that does. I've got it
> set at 32MB on a server with 1GB of RAM.
I'm looking at my-huge.cnf included with mysql 3.23.39 and it has a
record_buffer of 1M. Are the example confi
hi folks,
i have the following table (table_name=comment)
+-+--+--+-++
+
| Field | Type | Null | Key | Default| Extra
|
+-+--+--+-++
+
| id | s
I am writing a small perl script that will write data to a Mysql
database. The SQL will need to be different based on whether or not the
e-mail address already exists in the database though. I coded something
that works, but I would like some feedback as to whether or not this is
the best way.
In a slight change of this question (since I have no data to currently test
this with, as my ISP is using too old a version of mysql), does anyone know
what something like this would do?
SELECT * FROM theTable ORDER BY RAND(), date LIMIT 5;
I'd like to be able to pull out a certain number of row
In the last episode (Jun 15), Heikki Tuuri said:
> of course InnoDB could catch the error and send the error message to
> the client. But the problem is that we have to get NFS to flush the
> files, otherwise we may very easily get database corruption in case
> of a crash.
>
> MyISAM does not cal
Can any one tell me how place images in to a mysql database and then
retrieve them later?
Thanks
Kevin
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
Dan,
of course InnoDB could catch the error and send the error
message to the client. But the problem is that we have to
get NFS to flush the files, otherwise we may very easily get
database corruption in case of a crash.
MyISAM does not call f(data)sync at all, but then you may have
to run repa
In the last episode (Jun 15), Heikki Tuuri said:
> Sven,
>
> line 637 in mysql/innobase/os/os0file.c asserts that
>
> TRUE == os_file_flush(file)
>
> If you look at about line 557, you see how InnoDB does
> the file flush: the default is to call fdatasync.
>
> To solve the problem we should loo
> Hi folks!
>
> I would like to know if it's possible that some have read access
> to MySQL cvs repository? If yes, how may i have read acces (like
> an anonymous account).
Check out the CVS link on http://sourceforge.net/projects/mysql/
--
Look up myisampack in the mysql manual at http://www.mysql.com/doc/. The
only drawback is you can't modify the table.
> I have a table that has massive amounts of text. Just plain text, stuff
> that would compress REALLY well. Does mysql have any sort of compression
> internally for the table d
SELECT cont.msg_id, cont.msg_text, CONCAT_WS(', ', a1.address, a2.address)
FROM CONTENT AS cont, ADDRESS AS a1, ADDRESS AS a2 WHERE cont.msg_id =
a1.msg_id AND cont.msg_id = a2.msg_id;
Many thanks to salle in efnet #mysql for teaching me this trick ;-)
> Hello,
>
> I am relatively new with MySQL
> I don't think the answer has changed since last week :-)
>
> IMHO it's not "really slow and inefficient", anyway - this script:
(clipped)
> produces a table with 1 rows each containing an integer. Then we do:
>
> mysql> SELECT * FROM mytable ORDER BY RAND() LIMIT 5;
(clipped)
> 5 rows in set
In the last episode (Jun 15), SDiZ Cheng said:
> When i use mysqldump,
> seems that MySQL will open all the tables in the database.
> But, what i have is: a database will over 10,000 tables ..
> I get a "Too much opened file" error on this..
> I think increasing open_file_limit is not possible,
>
I'm using Visual Basic with DAO 3.6 and I try to execute this query
dim rsPersonen as dao.recordset
Set rsPersonen = db.OpenRecordset( _
"SELECT Mitglieder.* FROM Mitglieder " + _
"WHERE Mitglieder.geb='1978-08-26'")
Here I get an Error-Message:
"Runtime-Error 3464, ..."
If
Hola a todos.
Que metodo hay que hacer para poder traerse una bd de Informix a Mysql???
Por la Atencion Gracias :)
Hugo orta
I had the same problem and what I did is located the mysql.sock which was
located in /var/lib/mysql/mysql.sock
and then I just created a sym link from the temp dir and it worked fine.
ln -s /var/lib/mysql/mysql.sock mysql.sock
mysql.sock -> /var/lib/mysql/mysql.sock
Mike
-Original Message--
On Fri, Jun 15, 2001 at 10:44:57AM -0300, Gustavo Vieira Goncalves Coelho Rios wrote:
> Hi folks!
>
> I would like to know if it's possible that some have read access to
> MySQL cvs repository? If yes, how may i have read acces (like an
> anonymous account).
MySQL users BitKeeper. See the manual
Hi!
> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter> Hello mysql,
Peter> I'm planing to use transactions in application written in PHP, which
Peter> of course uses pconnect to optimize perfomance.
Peter> Few time ago I had to stop using "lock tables" as this lead to
Pete
Hi,
Does anyone know
1) if MySQL / Linux supports the use of Group By ROLLUP?
2) If not (as I suspect), are there plans for such an implementation?
Thanks everyone,
-Jim
-
Before posting, please check:
http://www.mysql.com
You asked this earlier this week.
The answer has not changed.
Matt Heaton wrote:
> Hi all, trying to do something and have it be as efficient as possilble. My
> question is if I have a table with say 10,000 rows in it, and I issue
> a command like this
>
> select * from table where number=1 o
update your php.ini file to define the proper socket file.
Marek Mahdal wrote:
> Hi,
> I have a problem with MySQL.
> I am running Redhat Linux 6.1, MySQL 3.23.38 and PHP 4.0.
> The command line client mysql is working perfectly. But if i try to connect to the
>MySQL server from a web site u
Hi Folks
I am having trouble connecting to a MySQL table using the DBI->connect()
call from a Perl CGI script. The error message I get is:
Can't connect to database: Access denied for user: 'web504@localhost'
(Using password: YES)
The web504 account and password are defined in the user table fo
perror 134 says:
134 = Record was already deleted (or record file crashed)
So, either your script is trying to delete a non existant record, or you
need to run [my]isamchk on your files.
Patrice d'OZEO wrote:
> Hi,
>
> Here's the error -> 1030 : Got error 134 from table handler
>
> We have
I don't think the answer has changed since last week :-)
IMHO it's not "really slow and inefficient", anyway - this script:
---start---
end
produces a table with 1 rows each containing an integer. Then we do:
mysql> SELECT * FROM mytable ORDER BY RAND() LIMIT 5;
+-+
| myfi
Marek Mahdal wrote:
>
> Hi,
> I have a problem with MySQL.
> I am running Redhat Linux 6.1, MySQL 3.23.38 and PHP 4.0.
> The command line client mysql is working perfectly. But if i try to connect to the
>MySQL server from a web site using PHP I get this error message:
>
> Warning: MySQL Con
I have a table that has massive amounts of text. Just plain text, stuff
that would compress REALLY well. Does mysql have any sort of compression
internally for the table data that it stores? A simple gzip wouldn't add
too much overhead to the system, and you could still have clear-text index
this is as close as I could come to what you want.
it involves 2 steps
set a variable
set @var:= '';
then query
select address.msg_id, content.msg_text,
@var:= CONCAT_WS(',',@var,address.address) as addresses
from content, address
where content.msg_id = address.msg_id;
this returns a list but
hi,
how can i make recursive querys in mysql?
i want to show a tree.
my table:
tree (id int, parent int, name char(10));
id parent name
--
1 0 joe
2 1 mike
3 1 jim
4 2 george
5 3
I've downloaded the mysql++ api and I'm trying to compile the examples
but I keep getting these warnings I don't understand. When I compile ,
using the Makefile provided I get the following warnings:
custom1.cc:8:1 : warning: pasting "~" and "stock" does not give a
valid preprocessing token
Never mind. This was simply my mistake. mysqld had a different copy of
the table in it's cache, so the problem went away when I restarted the
server process.
Thanks anyway,
Kyle Cronan
<[EMAIL PROTECTED]>
-
Before posting, pl
Jochen Wiedmann writes:
>
> Hi,
>
> does the MySQL client library contain any support for
> a proper stringification of the MySQL specific data
> types like my_ulonglong? IMO they are depending on the
> operating system and I should not use ltoa() or similar
> functions.
>
> Thanks,
>
> Jochen
Hi all, trying to do something and have it be as efficient as possilble. My
question is if I have a table with say 10,000 rows in it, and I issue
a command like this
select * from table where number=1 order by rand() limit 1;
If 1000 rows would match this command does mysql first find all 1000
Sehr géehrtes MySql-Team,
Ich habe schwiereigkeiten mit der MySql Gui anwendung und kann keine FAQ oder hilfe
Seiten finden, ich währe ihnen Dankbar für technischen supprot.
Mit freundlichen Grüßen
Volker Menten
[EMAIL PROTECTED]
Hello all,
I was getting the following error trying to clean out a large table of
call logs for a long distance billing system:
mysql> delete from calls where calltime<'2001-02-01';
ERROR 1034: Incorrect key file for table: 'calls'. Try to repair it
But then myisamchk finds nothing, even using
At 10:39 AM +0200 6/15/01, Sven Huster wrote:
>On Thu, Jun 14, 2001 at 07:30:01PM -0500, Paul DuBois wrote:
>> *This message was transferred with a trial version of CommuniGate(tm) Pro*
>> At 1:36 AM +0200 6/15/01, Sven Huster wrote:
>> >Hi there
>> >
>> >can i somehow easily recreate the aut
Hi folks!
I would like to know if it's possible that some have read access to MySQL cvs
repository? If yes, how may i have read acces (like an anonymous account).
Other question:
Which CVS TAGS MySQL uses for production environment? STABLE , CURRENT? (FreeBSD
Project uses STABLE for productio
I want to use mySQL with websphere as my webserver. Does anyone has done it
successfully?
Is mySQL compatible with websphere? Any help is greatly appreciated.
Thanks
Harjot
-
Before posting, please check:
http://www.mysql.com
I have a query regarding the use of procedures in MySql.
I am using ASP as frontend and MySQL version 3.23 as backend. I wish to
write Stored Procedures.
However, MySql 3.23 does not support Stored Procedures.
I would like to know the work around to do this.
Do I need to write the logic (for
Hello,
Due to the widespread advertisement of the 3.23.33 MySQL release as
stable and production quality, I had done extensive testing of the
3.23.33 release.
In order to prevent replication of that extensive testing effort,
I would be very grateful if you would continue to leave the
following
Hello mysql,
I'm planing to use transactions in application written in PHP, which
of course uses pconnect to optimize perfomance.
Few time ago I had to stop using "lock tables" as this lead to
locked system then somehow the php script was aborted before unlock
tables.
With transacti
Hi,
I have a problem with MySQL.
I am running Redhat Linux 6.1, MySQL 3.23.38 and PHP 4.0.
The command line client mysql is working perfectly. But if i try to connect to the
MySQL server from a web site using PHP I get this error message:
Warning: MySQL Connection Failed: Can't connect to lo
So sprach Mette Møller Madsen am Fri, Jun 15, 2001 at 01:46:06PM +0200:
> Hi there!
>
> When I try to insert more than 127 rows/records in a table I get this error:
>
> ERROR 1062: Duplicate entry '127' for key 1
> (the key is an auto incremented primary key)
I suppose the auto_inc column is ju
And since it's auto_increment, use something like int unsigned because you
don't need to store negative numbers...
Bill "Elvis" Gibbs
goEbusiness.com - putting e-motion in your business
email - [EMAIL PROTECTED] work - 301-668-5090 cell - 301-748-6938
-Original Message-
From: Bruce Stewa
This is a forwarded message
From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
To: Dvoøáèek Michal <[EMAIL PROTECTED]>
Date: Friday, June 15, 2001, 1:24:16 PM
Subject: Can only create 127 records in a table :o(
get back, due post not cointains some key words:
database
===8<==Original messa
Hi,
> When I try to insert more than 127 rows/records in a table I get this error:
> ERROR 1062: Duplicate entry '127' for key 1
> (the key is an auto incremented primary key)
> Does anyone know how to store _more_ than 127 rows in a table?
> My guess is that I need to change to settings of my db
Thank you for your help but this is not quite what I wanted. I tried
your solution, but it raises the following problem:
It would return
1 | Hello World | Foo
1 | Hello World | Bar
and if I neglect to look at the msg_id in the first column (which I
Your autoincrement column is of type TINYINT. This type is specifically
designed to only hold numbers from 0 to 127. For best results, use an
INTEGER - they can accept numbers up to 999 IIRC.
HTH
Jon
-Original Message-
From: Mette Møller Madsen [mailto:[EMAIL PROTECTED]]
Sent: 1
How many positive integers do you expect a tinyint to hold?
Change it to an int or greater, and your problem should disappear.
You realize, though, that this is pure conjecture, since you did not
supply any information.
Mette Møller Madsen wrote:
> Hi there!
>
> When I try to insert more than
Hi,
does the MySQL client library contain any support for
a proper stringification of the MySQL specific data
types like my_ulonglong? IMO they are depending on the
operating system and I should not use ltoa() or similar
functions.
Thanks,
Jochen
--
Check your AUTO_INCREMENT column. You probably have it set to a TINYINT
(0-128). Use ALTER TABLE to change it to an INT or BIGINT.
I hope this helps.
Pat...
- Original Message -
From: "Mette Møller Madsen" <[EMAIL PROTECTED]>
To: "mysql listserver" <[EMAIL PROTECTED]>
Sent: Friday, Jun
Mette Mřller Madsen wrote:
>
> Hi there!
>
> When I try to insert more than 127 rows/records in a table I get this error:
>
> ERROR 1062: Duplicate entry '127' for key 1
> (the key is an auto incremented primary key)
>
Change type of your primary key column to something bigger than tinyint
--
Hi
is possible to create FULLTEXT index on column which is varchar(100)
binary ???
trying this i got:
"ERROR 1005: Can't create table './xxx/#sql-19b_444.frm' (errno: 140)"
i need column which can be fulltext searchable and case-sensitive
(therefore column is binary)
i alter column to normal (
Simon Chan wrote:
> Hey Everybody,
>
> I noticed that a lot of people experience problems when they try to start the mysql
>server by
> typing this:
>
> $ bin/safe_mysqld --user=mysql &
>
> In the Mysql/msql O'Reilly book, it says to type this to start the daemon:
>
> bin/safe_mysqld --lo
Hi
WHat is your hardware configuration ?
I had such problem with Alpha/Linux (RedHat 5.2)
Regards
Daniel £a
e-direct Polska sp. z o.o.
WWW: http://www.e-direct.pl
E-mail: [EMAIL PROTECTED]
45-072 Opole ul. Reymonta 45
tel. +48 77 44 26 073
fax. +48 77 44 26
>Description:
With mysql-test-run when the "rpl01.test" is reached it run
indefinately. I have to stop the test with ctrl-c.
On an iMac with MacOS X 10.0.3 and Apple developer tools 10.0.1, I
download, untar, configure and make MySQL 3.23.39
begin terminal copy without all comma
Change the datatype of your primary key from TINYINT to something larger,
like SMALLINT, MEDIUMINT, or INT.
-Original Message-
From: Mette Møller Madsen [mailto:[EMAIL PROTECTED]]
Sent: Fri, 15 June 2001 13:46
To: mysql listserver
Subject: Can only create 127 records in a table :o(
Hi
1 - 100 of 133 matches
Mail list logo
