I found the following RPMs:
perl-DBD-MySQL-1.2215-1.i386.rpm
perl-DBI-1.14-10.i386.rpm
But they aren't good enough:
rpm -ivh MySQL*3.23.53a-1.i386.rpm perl-DBD-MySQL-1.2215-1.i386.rpm
perl-DBI-1.14-10.i386.rpm
error: failed dependencies:
MySQL-DBI-perl-bin is
Hello,
we are starting a new Projekt and we going to use MySQL with InnoDB
Tables.
Which Version of MySQL should we use? 3.23.53 or 4.0.x? Which is the
best Version for InnoDB-Tables?
Thanks for your help,
Stefan Sturm
-
*This message was transferred with a trial version of CommuniGate(tm) Pro*
I am trying to install mysql.
I have completed 2 steps
1. running the installer
2. putting a my.cnf file in the /library/mysql/var directory
3. Installation has already made a mysql startup file and as per the
Hello,
when I use autoincrement on a field, now can I start the count whith
100?
Thank you,
Stefan Sturm
---
sql, query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I'm logged in to RedHat Linux as an user and I'd like to connect to mysql
with mysql -uroot -p (and then must type the passw), but I could'nt in
this way, only whit this: mysql -uroot, without passw. Why?
picas
-
Before
INSERT INTO your_table(fields_list) VALUES
(record_1),(record_2),...,(record_n);
-Original Message-
From: Ed Reed [mailto:[EMAIL PROTECTED]]
Sent: Saturday, November 30, 2002 3:47 PM
To: [EMAIL PROTECTED]
Subject: Multiple Inserts and updates
Can anyone give me an example of
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello again --
...and then David T-G said...
%
% I would like to create a couple of related tables (just for starters) but
% I can't figure out how to do it; there are lots of CREATE TABLE examples
% in the mysql manual but nothing that shows
Êý¾ÝͨXP--²»Óñà³Ì¼´¿ÉÒÔ¶¨ÖƳöËùÓÐÐÐÒµµÄÐÅÏ¢¹ÜÀíϵͳ¡£
È磺Ʊ¾ÝÌ×´òϵͳ¡¢ÈËʹÜÀíϵͳ¡¢¹¤×ʹÜÀíϵͳ¡¢ÏúÊÛ¹ÜÀíϵͳ¡¢³É¼¨¹ÜÀíϵͳ¡¢¸É²¿ÈÎÃâ¹ÜÀíϵͳ..
Ö÷Ò³µØÖ·:www.oapro.com
Êý¾Ýͨ--ÈÃÄú¹¤×÷¸üÇáËÉ£¡
ÈçÕâ·âÐÅ´òÈÅÁËÄ㣬Ôò±íʾ·Ç³£±§Ç¸£¡
hello,
When I perform a large union query with 11 tables I often get this error:
Lost connection to MySQL server during query
If I shorten the query to say, 3 or 4 tables, I never get that error. The
thing is, the large 11 table union query works sometimes, probably 3 out of
5.
Any ideas?
Description:
I cannot build mysql 3.23.53 with my glibc 2.3.1. It always crash
when doing make test. I have tried this on an Intel Pentium II 233, an
AMD Duron 1200 and an AMD Athlon 1800+. I can build a working mysql
with glibc 2.2.5, but not glibc 2.3.1. Sorry that I
I should also mention that this error is only happening using the mysql C
API ( mysql_query() ). If i use mysql client and paste the exact same query,
i get the proper result everything.
thanks,
paul
hello,
When I perform a large union query with 11 tables I often get this error:
Lost
Hello.
On Sun 2002-12-01 at 12:47:42 +0100, [EMAIL PROTECTED] wrote:
Hello,
when I use autoincrement on a field, now can I start the count whith
100?
See http://www.mysql.com/doc/en/ALTER_TABLE.html (end of page)
Bye,
Benjamin.
--
[EMAIL PROTECTED]
Stefan,
- Original Message -
From: Stefan Sturm [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Sunday, December 01, 2002 1:49 PM
Subject: MySQL and Autoincrement
Hello,
when I use autoincrement on a field, now can I start the count whith
100?
with InnoDB tables you
Stefan,
- Original Message -
From: Stefan Sturm [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Sunday, December 01, 2002 1:33 PM
Subject: MySQL with InnoDB
Hello,
we are starting a new Projekt and we going to use MySQL with InnoDB
Tables.
Which Version of MySQL should
mysql Ver 11.18 Distrib 3.23.53a, for pc-linux-gnu (i686) (and pretty much
any other version from the past 12 months or so)
Speaking from the view of using mysql primarily via Php 4.2.3 (and other
versions) with either bundled libraries or linked against the above version
of MySQL:
It appears
Ignore this query folks, my damn signal timer was causing the problem, why I
was accessing mysql from a signal interrupt, i'll never know.
sorry for wasting anyones time.
thanks,
paul
I should also mention that this error is only happening using the mysql C
API ( mysql_query() ). If i use
Your 'root' password was probably not set hence, you didn't need a password.
Bhavin.
- Original Message -
From: Pikasz Gyorgy [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, October 17, 2002 7:46 AM
Subject: Connecting to mysql
I'm logged in to RedHat Linux as an user and I'd
Did you touch up my.cnf/ini to enable InnoDB?
PB
-
- Original Message -
From: David T-G [EMAIL PROTECTED]
To: mysql users [EMAIL PROTECTED]
Sent: Sunday, December 01, 2002 6:32 AM
Subject: Re: creating related tables
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello again --
I've created a table that contains a column called
recordLastModified and that column uses timestamp
as the data type. Is there a way in MySQL to
automatically update timestamp fields as records are
modified? I want it to be nearly automatic in the
same way that using auto_increment increases
According to the manual, 'timestamp' does exactly what you are asking
for:
The TIMESTAMP column type provides a type that you can use to
automatically mark INSERT or UPDATE operations with the current date and
time. If you have multiple TIMESTAMP columns, only the first one is
updated
Thanks for the response. I tried your example but it doesn't work,
Here's my SQL, can you tell what I'm doing wrong?
Insert Into Table1 (Product, Qty)
Values ((56-56, 5), (27-01, 1), (15-02, 2));
I've tried it with and without the outer parens.
Thanks
Adolfo Bello [EMAIL PROTECTED] 12/1/2002
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Peter, et al --
...and then Peter Brawley said...
%
% Did you touch up my.cnf/ini to enable InnoDB?
No, I didn't; I'm just a user here. I have yet to see details on whether
or not we really have InnoDB support. Is there a way I can tell from the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Peter, et al --
...and then Peter Brawley said...
%
% Did you touch up my.cnf/ini to enable InnoDB?
Oh, yeah -- can I do that on a per-user basis or is that for the whole
database system?
%
% PB
Thanks again HAND
mysql query,
:-D
- --
David
According to your first post, your fields are named ID, PartNum, Qty.
May be replacing 'Product' with 'PartNum' will help.
You should only remove outer parens:
Insert Into Table1 (Product, Qty)
Values (56-56, 5), (27-01, 1), (15-02, 2);
If it does not work, you should also post the error message
I'm working on a project that involves storing a lot of attributes for
individuals (think height, weight, eye color, hair color, skin tone,
etc.) and will later require searching on those attributes (i.e. return
all blue-eyed people with red hair).
I'm trying to figure out how to store all of
David,
From any client...
SHOW VARIABLES LIKE 'version';
or
SELECT @@version;
will show the version.
Search your my.cnf/ini for 'innodb'. If
skip-innodb
is not commented out, do so. If other innodb vars are commented out,
uncomment them.
PB
-
- Original Message -
David,
The server and 8 command-line utilities (mysqladmin, mysqldump, mysqlimport,
mysqlshow, mysqlcheck, myisamchk, mysqlhotcopy and myisampack) read MySQL
option files. Under Linux, they read options from /etc/my.cnf, and under
Windows they read from c:\windows\my.ini and c:\my.cnf, in that
I created a new table called Table1 and did a test with that command. My
test table does have all three fields that I mentioned. The ID field is
an autoincrement. The other fieldnames match what's in my command.
I'm running the command from MySQL-Front and it doesn't return any
error message it
Sorry! My mistake. In MySQL-Front I had the Limit option check and
wasn't seeing the newly inserted records.
I created a new table called Table1 and did a test with that command.
My test table does have all three fields that I mentioned. The ID field
is an autoincrement. The other fieldnames
Description:
I just compiled MySQL from source using the default options on my
Slackware 8.1 system. I then ran the test suite (as the document-
ation said i should) and one of the tests failed. I attempted to
force it to resume, but it seems to lock up (or at least
If you don't have any error message, what make you think it doesn't
work?
FYI, I have run the following commands from mysql client:
mysql use test
Database changed
mysql create table Table1 (Id int not null auto_increment primary key,
Product varchar(80), Qty int);
Query OK, 0 rows affected
I have a few fields in a table that I need to calculate, yesterday I
find out that they don't want it to display as 0.00 if nothing was
entered into the database.
I currently have the fields set to decimal(10,2)
Would any1 suggest a better way to do this to not display the 0.00 if
nothing was
Hi
Thanks for that information. But I think I want to purchase a software
application, due to my lack of knowledge for mySQL. In addition to this, my
ISP doesn't allow that much control over the operating system.
Can anyone recommend a software app. I could buy to be able to dump data and
I am guessing a default value of NULL should do it.
Bhavin.
- Original Message -
From: Chris Kay [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, December 01, 2002 4:54 PM
Subject: Calculation question
I have a few fields in a table that I need to calculate, yesterday I
find out
Hi Haksun,
Cross-join works perfectly on 3.23.53-max-nt under Win2000 SP2, both from
command line and MySQL Control Center 0.8.6-alpha.
Regards,
=dn
Hi all,
I found this join problem using mysql 3.23.53-max-nt (on WinXP).
It works fine on MySQL 3.23.52-log (on Linux).
Could someone
I've got an embarrassing problem. I installed MySQL on my WinXP machine
months ago. Since then, though, I've continued to use the MySQL on a remote
(FreeBSD) host, so I haven't had occasion to use my local version. Now as I
went back to it, I found that I couldn't log in. I can't remember my
well i think i have everything how i want it.. but now i need to add a
column to one of my tables.. and i can't find it in the mysql manual.
anyone know how?
thanks,
Brendan.
-
Before posting, please check:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Neil, et al --
...and then Neil Tompkins said...
%
% Hi
Hi!
%
% Thanks for that information. But I think I want to purchase a software
% application, due to my lack of knowledge for mySQL. In addition to this,
% my ISP doesn't allow that
it only takes a few minutes to uninstall and install...
-Original Message-
From: Amittai Aviram [mailto:[EMAIL PROTECTED]]
Sent: Monday, 2 December 2002 9:37
To: Mysql
Subject: Embarrassing: can't log in
I've got an embarrassing problem. I installed MySQL on my WinXP machine
In the last episode (Dec 02), Brendan Mansell said:
well i think i have everything how i want it.. but now i need to add a
column to one of my tables.. and i can't find it in the mysql manual.
anyone know how?
http://www.mysql.com/doc/en/ALTER_TABLE.html
--
Dan Nelson
[EMAIL
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Peter, et al --
...and then Peter Brawley said...
%
% David,
%
% From any client...
% SHOW VARIABLES LIKE 'version';
% or
% SELECT @@version;
% will show the version.
Ahhh... Thanks!
Well, it looks like we're at 3.23.52. Not all is
In article [EMAIL PROTECTED] you write:
it only takes a few minutes to uninstall and install...
I think running mysqld with --skip-grant-tables (perhaps while pulling
the network cables off from the box) is an even faster (safer?) way.
I am using MySQL 3.23.53 with InnoDB tables on Win2K platform.
My charset is set to latin1 and it works fine when I use Swedish characters
through JDBC. It also works fine if I use them from the mysql command line,
but when I try to use mysql file.sql to load a set of INSERTs into my
tables
I get
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, all --
I'm exploring some software for a client and I expect to need to store
credit card numbers in the system.* How to do it safely, though?
It seems to me that we have four levels of security at hand: the local
employee who should be working
DL,
Thanks for the reply.
Can you give more details please?
If I understand you correctly, you did not reproduce the errors I get.
In other words, your output was exactly the same as
f1 f2 f1 f2
1 2 1 2
1 4 1 2
1 2 1 4
1 4 1 4
If that is the case, is this a Win-XP
Sorry Joseph, you must've missed my next post minutes later. I had the
limit option accidentally set in MySQL-Front and the newly inserted
records weren't appearing.
Another question though, I continued testing this and found that if I
use MSAccess as the front end to the MySQLserver the
Joseph's suggestion works beautifully when I do an
insert statement from the MySQL monitor. Now how can
I avoid getting the string of zeros that shows up when
I use the LOAD DATA INFILE command?
To clarify:
I have three columns in my table: Column1, Column2,
Column3. Column3 is my TIMESTAMP
- Original Message -
From: [EMAIL PROTECTED]
Newsgroups: local.mailgate.mysql.general
To: [EMAIL PROTECTED]
Sent: Sunday, December 01, 2002 6:13 PM
Subject: Re: Embarrassing: can't log in
In article [EMAIL PROTECTED] you write:
it only takes a few minutes to uninstall and install...
Hello.
I am trying to create a table in one of my databases using textbook code,
but it is giving me an error message. Here is how it reads:
mysql create TABLE messages
- (
- id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
- forum int not null,
- author char(255) not null,
In the last episode (Dec 02), Will K. said:
Hello.
I am trying to create a table in one of my databases using textbook code,
but it is giving me an error message. Here is how it reads:
mysql create TABLE messages
- (
- id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
-
Thanks... syslexia ducks...
Wil
---
Hello.
I am trying to create a table in one of my databases using textbook
code,
but it is giving me an error message. Here is how it reads:
mysql create TABLE messages
- (
- id INT UNSIGNED NOT NULL AUTO_INCREMENT
I have an application that currently is using an Access database and am
in the process of converting over to MySQL. I downloaded the ODBC
driver and have been using ADO and have had no problems at all up to
this point. I have a number of parameterized SQL statements that
worked fine in
hi, which date does mysql use to calculate CURDATE()? I have a master
database telling me via the select CURDATE(); command that today is :
mysql select CURDATE();
++
| CURDATE() |
++
| 2002-12-01 |
++
1 row in set (0.00 sec)
even though the linux date is set
Good evening,
I'm in the process of rebuilding a table in MyISAM format. I can see the
plaintext data in the .MYD file just fine. But after running myisamchk
-i table, which reports fine and repairs the index to the correct 388
rows... I go under the command line client and run a standard select
snip I can't find a my.cnf file anywhere on this
FreeBSD 4.5 system!
I know [also from your other reply :-] that I can set various options in
my personal .my.cnf file... Does that include innodb file paths and the
like, or is that only in the system-level file?
IMO it's best to have just
joins and nested where clauses.
Description:
The query analyzer seems to hang while trying to parse/optimize this
particular query if there is data in the table. Trying to understand why
mysql locked up running a complex query, We have been surprised to
find that using EXPLAIN could hang
Hi,
I have a database of albums by a group and I want to be able to search on
this table to find out what songs are duplicated on what albums (there are
36+ albums). The problem is how do I set up the database.
Example:
Album1 has 3 songs. 1.song, 2.song, 3.song, 4.song
Album2 has 4 songs.
*This message was transferred with a trial version of CommuniGate(tm) Pro*
I am trying to install mysql.
I have completed 2 steps
1. running the installer
2. putting a my.cnf file in the /library/mysql/var directory
3. Installation has already made a mysql startup file and as per the
- Forwarded by Jumroen Bhoosawang/Freewill Solutions/TH on 02/12/2002
12:34 -
Jumroen
59 matches
Mail list logo