- Forwarded by Jumroen Bhoosawang/Freewill Solutions/TH on 02/12/2002
12:34 -
Jumroen
*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
instruct
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. 4.s
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
> 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
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 *
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
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 Acces
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 PR
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
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,
- 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 inst
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 col
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 command
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
-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
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
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.
---
-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 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
[EMAI
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 machi
-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 much
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:
http://www.mysql.
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
u
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
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
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
ta
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 en
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 (0.
>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
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 mat
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 j
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 ord
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 -
F
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 thes
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 me
-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
-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
m
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]
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 automatical
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" increas
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
>
> Hel
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
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 m
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 t
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 MySQ
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 ta
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]
-
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
>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 ca
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?
Rega
Êý¾ÝͨXP--²»Óñà³Ì¼´¿ÉÒÔ¶¨ÖƳöËùÓÐÐÐÒµµÄÐÅÏ¢¹ÜÀíϵͳ¡£
È磺Ʊ¾ÝÌ×´òϵͳ¡¢ÈËʹÜÀíϵͳ¡¢¹¤×ʹÜÀíϵͳ¡¢ÏúÊÛ¹ÜÀíϵͳ¡¢³É¼¨¹ÜÀíϵͳ¡¢¸É²¿ÈÎÃâ¹ÜÀíϵͳ..
Ö÷Ò³µØÖ·:www.oapro.com
Êý¾Ýͨ--ÈÃÄú¹¤×÷¸üÇáËÉ£¡
ÈçÕâ·âÐÅ´òÈÅÁËÄ㣬Ôò±íʾ·Ç³£±§Ç¸£¡
===
-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 related
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 exampl
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 pos
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)
http://l
*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
instructi
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
-
Befor
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 neede
59 matches
Mail list logo
