Thanks to those who replied. The solution was to drop the table and
then rebuild it. It was originally populated with a negative number
(yes, we know about the negative problem with auto incrementation),
which caused the max value to show up. I did not know that you
cannot simply delete the
Have anyone tried TopLink with MySQL and if so, how does it work?
[EMAIL PROTECTED]
Hi,
I want to uninstall Mysql, cause it's not configured properly. Help me
Ujwol
I would recommend CodeCharge, which allows you to easily create web pages
connected to the database, such as MySQL.
Usually, to create a database-enabled web page or web site, you would need
to write a program, for example in PHP or Perl.
CodeCharge generates such programs in 5 languages (ASP, JSP
hello,
can I log the database queries for a specified user?
Regards
Issam
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request thi
hello,
what is the best configuration and startup arguments for 512MB memory
machine running many many connections for a bulletin board
is the following ok?
safe_mysqld -O key_buffer=64M -O table_cache=256 -O sort_buffer=4M -O
record_buffer=1M
how do I understand what is meant by this??
Regar
Hello,
I am using an auto_increment field, every time I delete from the table, the
counter goes back, is there any way to keep the incrementation regardless of
the number reached after delete
Regards
Issam
-
Before posting, ple
Look up skip_grants in the manual
- Original Message -
From: "Chee-Siong Cheong" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, January 14, 2001 23:02
Subject: Mysql privileges problem
> Hi everyone,
>
> Recently I accidentally modify the user permission of "root" from
> "loc
Checkout:
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Reserved_words
regarding "year"
that may be the reason
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
ht
On Sun, Jan 14, 2001 at 04:13:40PM -0800, Nancy Quesenberry wrote:
> HI,
> I am new to this list and to mySQL.
>
> I am trying to do a simple copy of a table with the create-select
> and it has a problem with my code. I am using version 3.22.23b. My
> code is:
>
> create table newtable select *
HI,
I am new to this list and to mySQL.
I am trying to do a simple copy of a table with the
create-select and it has a problem with my code. I am
using version 3.22.23b. My code is:
create table newtable select * from oldtable;
Am I missing something? I know I can create the new
table and then
Hi,
what might happen is that Solaris (including Solaris 7, but not Solaris 8) does
pageouts of text and data pages of a process in order to increas diskcache. That
means mysqld is able to force itself out of memory by doing io an large tables.
There is something to do about it: in /etc/system yo
Chee-Siong Cheong writes:
> Hi everyone,
>
> Recently I accidentally modify the user permission of "root" from
> "localhost" to "any" with webmin. After I modified, I can no longer connect
> to the database with my machine, the error is
>
> ERROR 1045: Access denied for user: '@localhost'
>
>
Hi,
Thanks for the response !
> Howdy,
>
> On Tue, Jan 09, 2001 at 11:53:12AM +0800, [EMAIL PROTECTED] wrote:
> > I've got a linux server running MySQL 3.22.32 on kernel version
> > 2.4.0-test8.
>
> I'd be tentatively inclined to blame the problems on 2.4.0-test8. Do
> the problems still occur
You can specify field order with the LOAD DATA
command...then you'll never have to worry about the
order of the table columns.
LOAD DATA INFILE 'x' INTO table (field3,field1,field2)
double check the LOAD DATA syntax in the manual.
Brian
--- Marcus Ouimet <[EMAIL PROTECTED]> wrote:
> OK, I am re
You can specify field order with the LOAD DATA
command...then you'll never have to worry about the
order of the table columns.
LOAD DATA INFILE 'x' INTO table (field3,field1,field2)
double check the LOAD DATA syntax in the manual.
Brian
--- Marcus Ouimet <[EMAIL PROTECTED]> wrote:
> OK, I am re
Hi,
I am guessing this is the kind of problem that would be easier to solve with
a sub select
SELECT
simpleparts.category,simpleparts.partnumber,simpleparts.manufacturer,simplep
arts.descrp,ABS(packagesParts.pri) as abPRI,categories.sortorder
FROM ((packagenames LEFT JOIN packagesParts ON packa
I have read through the archives and am still unclear on a few things:
o Does libmysqlclient_r only correct the timeout problem? Or does it
provide thread safe versions of calls like mysql_query()? I do not
need to use timeouts.
o I will definately be using different connections in eac
Oops!
Sorry wrong list, please ignore
>
> I'm generating a page of HTML by reading an entire page of HTML source
into
> a variable, and then doing various functions and str_replace on the
> variable.
>
> However when I finialy write this out to a file the variable containing
the
> HTML sourc
I'm generating a page of HTML by reading an entire page of HTML source into
a variable, and then doing various functions and str_replace on the
variable.
However when I finialy write this out to a file the variable containing the
HTML source is truncated, at about 5800-ish bytes.
Is there a lim
OK, I am really stuck sorry to have to post this. I have searched through the
documentation and maybe I am just searching with the wrong words on the MySQL site. I
am wanting to reorder the fields I have in a table - not the data in the fields (I
have lots of info on this) but the actual fields
Hi everyone,
Recently I accidentally modify the user permission of "root" from
"localhost" to "any" with webmin. After I modified, I can no longer connect
to the database with my machine, the error is
ERROR 1045: Access denied for user: '@localhost'
What can I do to change it back to the origi
Martin, Please check the older mailings before posting in the future, Thanks.
Martin Borg wrote:
> I am trying to install Mysql 3.23.7 on a Red Hat 6.0 Server system. When
> I try to install the binary rpm-distribution i get an error saying that
> bin/usr/perl5 is needed. The perl version insta
Dear ladies and gentlemen,
I intend to develop an J2EE-Application using Allaire's
Applicationserver JRun. The basing Database should be MySql.
Since MySql supports no transaction management, there is a problem to
deploy Entity Enterprise Java Beans, because the applicationserver
needs to se
> Hi. This is a really easy question:
>
> I have an existing table called clients. I have an existing field called
> CPicture. I'm trying to add a default value of "no".
>
> I've tried several times and can't seem to get it right. So, does anyone
> know how I can add a default value of "no"
> I'm about to kill this terminal! I'm using mysql 3.23.24-beta (my
> host's choice, not mine).
>
> I have a table...
> ==
> ===
> mysql> describe users;
> ++--+--+-+-+--
Hi. This is a really easy question:
I have an existing table called clients. I have an existing field called
CPicture. I'm trying to add a default value of "no".
I've tried several times and can't seem to get it right. So, does anyone
know how I can add a default value of "no" to an existing
Hello Readers!
I believe I have a upload or a cache limit set too small in a configuration
file...I just can't seem to place my eyes on which one.
This is what is happening: the bottom portion of any image larger than ~45
Kb, stored as a BLOB in mySQL 2.22.24-shareware-debug server is not
displa
Hi,
I have got a table with an index and apparently it crashed and I cannot
get anymore results :-( with a MATCH AGAINST query. I have tried to
repair the table (which contains only 2 rows) with myisamchk but it
doesn't change anything (maybe I used the wrong options: I used -e and
-r)
One query
I'm about to kill this terminal! I'm using mysql 3.23.24-beta (my
host's choice, not mine).
I have a table...
==
===
mysql> describe users;
++--+--+-+-+--
--+---
Hi!
> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter> Hello bugs,
Peter> Linux. Mysql 3.23.30 (also checked with 3.23.25). Problem appears with
Peter> repear table as well as myisamchk.
Peter> The problem is quite strange. Then repair table or myisamchk repears
Peter> the table
I am trying to install Mysql 3.23.7 on a Red Hat 6.0 Server system. When
I try to install the binary rpm-distribution i get an error saying that
bin/usr/perl5 is needed. The perl version installed is Perl 5.005. Is
this not enough?
Martin, Omnisoft Sweden
---
Edd,
Sounds like a javascript verification.
Open the source to the web page and look around (usually at the top) for a
routine that's called when the form is submitted to confirm validity of form
fields.
Regards,
Nick G.
-Original Message-
From: Texscene_Support [mailto:[EMAIL PROTECTE
Richard,
My suggestions is to use this command:
LOAD DATA INFILE '/home/fpo/htdocs/secure/upload/export-customers.csv'
REPLACE INTO TABLE tempCustomer FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED
BY '"' (customerid, custLastName, custFirstName, custEmail, deliveryDay,
storeid)
The only differen
1) on Windoze:
c:\> mysqldump database_name > tables.sql
2) move tables.sql to your Linux server
3) on Linux:
$ mysql database_name < tables.sql
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
> -Original M
I installed MySQL on Win98 and acessed it from a SmartArrays program
which uses ODBC with this connection string:
DSN=sample-MySQL;DRIVER={MySQL}
This worked. When I asked for the the list of tables, there were not tables.
Is this expected?
Jim
---
Hello,
I have posted several emails to this list during the last few
days because of mysqld crashes and index corruptions. Since
then I have made several modifications to the server but I
still have occasional index corruptions (about one corruption
every two hours, the figure seems to vary with
Database systems Design implementation and management by Rob and Cornel
explains the concept the relational schema prefectly.
I highly recommend it for people starting out in IT and university students
On Sun, 14 Jan 2001, [EMAIL PROTECTED] wrote:
> I am a new user to MySQL.
>
> I am having a
Joseph Bueno writes:
> Sinisa Milivojevic a écrit :
>
> Yes, from MySQL-3.23.30-1.i386.rpm
>
> BTW, are there any known issues with:
>
> - glibc from RedHat 6.2 (I have checked Red Hat site there is
> no update for it)
>
> - MySQL with SMP (I have been told to try with one CPU onl
This problem may not be related to mysql but then again it might be. my web site has
an HTML form which gets visitors data and with the use of PERL-DBI-mysql stores this
data in a database on a remote web server where the web site is.
The form is designed in such a way that some boxes on the f
Hi,
On Wed, Jan 10, 2001 at 02:02:40PM -, Steven Clifford wrote:
> how much higher would you estimate the resource / memory
> consumption of 3.23.30 compared to 3.22.26 ?
> (both from the statically linked Linux i686 binary distribution)
>
> After using 3.22.26 for quite some time now, I fee
Hi David,
On Tue, Jan 09, 2001 at 01:02:34PM +, David Lane wrote:
> I am having major problems with MySQL 3.22.32 running on a
> Linux-Mandrake 7.1 box with RAID 1 drives... Although mysqld is running
> (through safe_mysqld, initiated by /etc/rc.d/init.d/mysql.server start),
> any command li
Howdy,
On Tue, Jan 09, 2001 at 11:53:12AM +0800, [EMAIL PROTECTED] wrote:
> I've got a linux server running MySQL 3.22.32 on kernel version
> 2.4.0-test8.
I'd be tentatively inclined to blame the problems on 2.4.0-test8. Do
the problems still occur under (say) 2.2.18?
> The database server has
Are there some functions to compare two datetimes-fields (like if one if
greater the the other or a function which says, who many seconds are
between two datetimes) ?
Martin
-
Before posting, please check:
http://www.mys
Hello bugs,
Linux. Mysql 3.23.30 (also checked with 3.23.25). Problem appears with
repear table as well as myisamchk.
The problem is quite strange. Then repair table or myisamchk repears
the table, which is empty it grows a index file until it reaches
it's limit 2GB. And then it says t
Hi there,
sorry, I'm a newbee and I didn't found what to do in the manual.
I heard in the maillinglist something about big tables. I want to make a
database with about 2-3 GB. What do I have to do / set / pay attention to
BEFORE I start ?
Thanks in advance !
Martin
---
Hello All,
Problem Synopsis:
I am importing a CSV file and need help with 'line terminated with" syntax or ???
Detail
I have a simple situation and question. I wish to import a comma delimited file (CSV)
from an Excel like file generated by a Windows operating system into a mySQL database
on
47 matches
Mail list logo
