The problem is that he has it as a primary key, so he wants it to be unique as well as
indexed. The best solution (and MUCH MUCH MUCH more efficient) would be to hash each
of the four columns, and create a primary key on that. Integer keys are much faster
and memory-efficient than string
Hi,
This evening I'd download the complete packet of NuSphere what contains also
MySQL.
In the tutorial what comes with it, it say that you can make a txt file and
save it. With this txt file you can LOAD it in MySQL by using the command:
LOAD DATA LOCAL INFILE txt_name.txt INTO TABLE
I share most of these conventions, and I think the key is consistency.
Consistency makes the database usable, without guessing or having to refer
back to notes or other uses of the table or field.
My golden rules are
1. Key names are unique within the database this avoids any confusion
I've used pam-mysql with redhat linux and am very pleased with
it. I love being able to authenticate to a db.
Ernie Hershey
[EMAIL PROTECTED]
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 19, 2001 2:00 AM
To: Chris Aitken
Cc: [EMAIL
Does anyone know how to delete double quotes from my entries ''.
I thing you can use regular expressions.
Dexter,
The following resources may be of interest to you:
The MySQL Manual, particularly:
7.1 Literals: How to Write Strings and Numbers,
7.4 Functions for Use in Select and Where
Olav Wirtz writes:
LOAD DATA LOCAL INFILE txt_name.txt INTO TABLE table_name;
But it does not tell me where I have to save this txt file. I tried it in
several directories, but MySQL cannot find the file.
Did you by any chance specify an incorrect path to the
file in the query? Don't
Hi
Maybe it is in the manual, but i can´t find it in the way i need.
Does anybody know where to find a complet list of MySQL error codes with
number and descripcion in order to make a library for handling and
reporting alerts to users in php
Thanks a lot
Hi
Maybe it is in the manual, but i can´t find it in the way i need.
Does anybody know where to find a complet list of MySQL error codes with
number and descripcion in order to make a library for handling and
reporting alerts to users in php
Hola Javier,
Yes it is in the manual - but try
Get the pdf version from php.net.
At 01:02 P 21/10/01, DL Neil wrote:
Hi
Maybe it is in the manual, but i can´t find it in the way i need.
Does anybody know where to find a complet list of MySQL error codes with
number and descripcion in order to make a library for handling and
reporting alerts
Thanks a lot, as you know, I need to translate error codes (such as
duplicate references) to the future (i hope) program operator. The error
codes are for operators (those who write data into the catalog), not for
public, I know PHP error reporting functions with MySQL, but i would like
to
- Original Message -
From: [EMAIL PROTECTED]
To: Barbara Ferrell [EMAIL PROTECTED]
Sent: Sunday, October 21, 2001 7:52 AM
Subject: Re: where can find a lisy of keystroke commands for mysql?
Your message cannot be posted because it appears to be either spam or
simply off topic to our
Hi
How I can use transaction with MySQL API ( C and C++)
Best Regards
Jordan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
i am two days new in learning MYSQL and am designing a table. i can't
get back to the beginning of the table when i notice a typo and also even
back to the beginning of my line without overwriting everything. i have
spent forever looking everywhere .. i can't even backspace past the .
Thanks, that worked. However, it appears that each time I execute an alter
table command (such as addng a new index), I'll have to repeat the process of
creating the index, moving the file, then again defining the symlink.
MySQL does not seem to respect the link with new DDL commands like
Hello Mike,
I just would like to know, did you mean in your message the EMS MySQL
Manager or something else? In first case your words sound very strange
to me: no one of our users had write us something like this, and many of
them are praises our product. Some opinions of our users about EMS
Hi,
I am trying to install the latest mySQL 4.0.0. alpha on my Suse linux box
Version 6.3.
However the comile run failes. What am I doing wrong? Is it in general
possible to install it? Has anyone succeeded so far on Suse Linux 6.3?
Best regards
Andreas Berner
[EMAIL PROTECTED]
Hello All,
When repairing a MySql table, I keep getting following error:
'mydatabase.MYD' doesn't have a correct index definition
What exactly does this mean or what needs to be done to correct it?
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Control-A and control-E are good ones.. ^A will go to the
begginning of a line and ^E goes to the end. Also, ESC-b and ESC-f will
go back/forward word by word.
You can also type \e to load your current statement into an editor,
which lets you harness the navigation/text-control power of
Hi all,
I'd like to thank Gordon Burditt for responding to my question. (Original question
below.)
It seems I was invoking myisamchk incorrectly. Rather than doing:
# myisamchk mailtable
...I was specifying both the data and index files, like this:
# myisamchk mailtable.MYD
Dear Sir/Madam.
I have written a Management Information System that has a MySQL db running
on a Linux server.
There is quite a small number of tables.
However these tables are growing quickly and the queries executed will
require LEFT OUTER JOIN between tables.
Example:
A sample query over 4
- Original Message -
From: Zachary Denison [EMAIL PROTECTED]
To: MySQL ListServe [EMAIL PROTECTED]
Sent: Sunday, October 21, 2001 11:11 AM
Subject: shared datafiles.
I know this is probably a recipe for disaster, but
would I be able to have 2 instances of mysql running,
both pointing
- Original Message -
From: Bernard Davis [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, October 21, 2001 12:50 PM
Subject: Absolute beginner moving from Access
I've been able to get the basic website working although God
knows how, but to develop other services on the web site
Hi everyone,
There's been some discussion recently on the need for a FAQ and posting
guidelines for the MySQL list. I got to thinking about that... :
I belong to another list, called the SunMangers list. (I'm sure there's other
SunMangers members here. Hi! : ) The SunManagers list is a
Hi there!
I have a question. I've created a page in PHP4 which displays the result of
the following query:
select event_detail.id, event_detail.startdate, event_detail.enddate,
event_detail.title,
event_detail.comment, event_detail.active, event_detail.subscription_open,
event_main.url
from
Robert Alexander wrote:
- Replies are directed to the POSTER and not to the list. This keeps traffic
and clutter down.
- Those who don't post a SUMMARY are likely to find future questions
going unanswered.
So answers to questions go directly to the poster and are not cc'd to the
Hi!,
I tried to install from mysql-3.23.43.tar.gz.
i configured using ./configure
--prefix=/usr/local/mysql
--localstatedir=/usr/local/mysql/data
and then make and make install
changed all the permissions.
Then on starting safe_mysqld i get this error in .err
file
In the last episode (Oct 19), Barbara Ferrell said:
We have 3.3 million text documents ( U.S. Patents) that we can put
into any format needed to import into any database needed. Would
Mysql be able to handle fast FULLTEXT searching? Each document has
several fields that would need to be
Hi!
On Oct 21, Mark Maunder wrote:
Ben Edwards wrote:
I have a bit of a problem with using freetext indexes because there are a
LOT of important 3 letter words in my database and as I am using shared
hosting so do not have the option to recompile MySql. Can't quite figure
why 3 is
Is there a way to get mysql to change the default from 3 to 2 letter words (or
less) that are ignored in fulltext indexes?
I'm running version 4 alpha. I checked the TODO and it's not listed. Is it
possible to make this a config.h option?
As I said I am on a shared host and don't have the
I have a bit of a problem with using freetext indexes because there are a
LOT of important 3 letter words in my database and as I am using shared
hosting so do not have the option to recompile MySql. Can't quite figure
why 3 is not the default (car, dog, cat war, man, bed, ). Maybe so
Ben Edwards wrote:
I have a bit of a problem with using freetext indexes because there are a
LOT of important 3 letter words in my database and as I am using shared
hosting so do not have the option to recompile MySql. Can't quite figure
why 3 is not the default (car, dog, cat war, man,
- Original Message -
From: Robert Alexander [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, October 21, 2001 1:29 PM
Subject: Proposed Guidelines for Posting to the MySQL list
There's been some discussion recently on the need for a FAQ and posting
guidelines for the MySQL list.
Re: Proposed Guidelines for Posting to the MySQL list
- Replies are directed to the POSTER and not to the list.
This keeps traffic and clutter down.
This I think is the only point that I have an issue with. If you look above,
there are two (at least right now) replies posting that this is a
PLEASE CC ME BECAUSE I'M NOT IN THE LIST... Thanks!
I'm having a problem:
ERROR 1017: Can't find file: './mysql/adminedit.frm' (errno: 13)
I've searched in the archive and find a solution. It says that is a
permission problem and to make all the files owned by mysql.mysql. This
works, but I
On Sun, Oct 21, 2001 at 08:41:45PM +0100, Ronan Minogue wrote:
Dear Sir/Madam.
I have written a Management Information System that has a MySQL db
running on a Linux server. There is quite a small number of tables.
However these tables are growing quickly and the queries executed
will
Robert Alexander wrote:
- Replies are directed to the POSTER and not to the list. This keeps traffic
and clutter down.
At 22:12 +0100 2001/10/21, Mark Maunder wrote:
Other authors wont be able to participate in a discussion and there wont
be the public aggregation of viewpoints - just a
This is kind of nuts! list blocking stuff without a VERY narrow number of
words in it. Doesn't even contain MySQL in the list ;)
At 07:35 P 21/10/01, you wrote:
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must
On Sun, Oct 21, 2001 at 04:29:45PM -0400, Robert Alexander wrote:
Hi everyone,
I belong to another list, called the SunMangers list. (I'm sure
there's other SunMangers members here. Hi! : ) The SunManagers list
is a wonderful resource for getting timely help for those times when
you're
From http://www.mysql.com/doc/n/o/node_567.html
For the connection specified by mysql, mysql_errno() returns the error code for the
most recently invoked API function that can succeed or fail. A return value of zero
means that no error occurred. Client error message numbers are listed in the
On Sat, Oct 20, 2001 at 01:11:30PM -0700, Mike E wrote:
I've been having this debate in my mind and alternated my method on
the past few projects I've worked on, and now I ask you, the MySQL
community.
What is the best way to have a preferences table?
Here's what I've been doing:
Something that is not entirely clear about the mysql binary logs in the
documentation is whether the mysql daemon itself begins to write logs with
different names at different points in time, or if it simply writes to .001
and your logrotate daemon (perhaps as directed by mysql's bundled
Hi Sir/Madam,
Your email address has abeen entered into our database of persons
interested in receiving a free God Bless America bracelet. If this is a
mistake ignore this email or reply with Remove in the subject line.
If this is not a mistake reply to this link: [EMAIL PROTECTED] with
I downloaded MySql v3.23.43 binaries to see if I could make use of the
system for my database 'stuff'. I have several tables that when loaded will
be 2gb and the concept of raid support would be appealing.
Raid does not seem to be enabled on the default download. Because of this I
downloaded
ummm, is there any thing wrong with using the Naming Convention devloped by
Stan Leszynski and Greg
Reddick, authors of Access 97 books?
Their conventions would creat this:
tblNews
intpkNewsID
intfkUsersID
datPosted
varSubject
txtContent
blnBoolean
tblUsers
intpkUsersID
intfkNewsID
varName
pk
On Sun, Oct 21, 2001 at 09:40:16PM -0400, howard gramer wrote:
ummm, is there any thing wrong with using the Naming Convention
devloped by Stan Leszynski and Greg Reddick, authors of Access 97
books?
Their conventions would creat this:
tblNews
intpkNewsID
intfkUsersID
datPosted
Thanks for the thoughts...
I changed the or, if you are using MSVC, add USE_RAID to the defines in
the IDE. This created a new set of problems when I did as well.
On the Unix version the instructions are rather clear and they work (I have
turned Raid on Linux already). There are no specific
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
Release:
H Jeremy!
tblNews
intpkNewsID
intfkUsersID
datPosted
varSubject
txtContent
blnBoolean
Wow, that's rather cluttered. I'd rather use a readable standard.
Won't it be a bit strange when you run SHOW TABLES and you get a bunch
things back all that being with tbl?
So make them
Hi June!
How can i connect mysql client to the mysql server? Does mysql need to be
installed on the client as well?
Mysql -is- the client. Mysqld is the server. The client can talk to any
server anywhere -if- it has appropriate permissions. You do not need to
have mysqld installed locally to
On Sun, Oct 21, 2001 at 11:40:05PM -0400, jim barchuk wrote:
The point of all this is to make it it easier to read -later-. A
tbl_ is clearly a table and a b_ is clearly a boolean without having
to think about it or 'remember' or look it up elsewhere. Such as 'I
need to test this variable
Hi,
after some testing on a new db, I have this status:
[root@rachab /root]# mysqladmin e | grep "onn\|pen.*es"
| Aborted_connects | 12 |
| Connections | 150194 |
| Max_used_connections | 24 |
| Open_tables | 0 |
|
- Original Message -
From: [EMAIL PROTECTED]
To: Yiu Wing [EMAIL PROTECTED]
Sent: Sunday, October 21, 2001 9:52 PM
Subject: Re: Re: Field Naming Standards
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you
On Sun, Oct 21, 2001 at 05:59:47PM -0700, Jesse Thompson wrote:
Something that is not entirely clear about the mysql binary logs in
the documentation is whether the mysql daemon itself begins to write
logs with different names at different points in time, or if it
simply writes to .001 and
I just installed mysql-3.23.43, apache-1.3.22, and php-4.0.6 all from source
this evening (on freebsd-4.4-r). When I try to run safe_mysqld I get this;
mysqld started
Fatal error: Can't change to run as user 'mysql' ; Please check that the user
exists!
Aboring
I see in the file passwd that
There's been some discussion recently on the need for a FAQ and posting
guidelines for the MySQL list. I got to thinking about that... :
cut
Both already exist:
FAQ: http://www.bitbybit.dk/mysqlfaq - although not created and
maintained by MySQL AB, I believe it does answer most of the
Hello,
Hi, I need some help on something here. I need to know the best way to set
up this database.
I have a site with a bunch of images/reviews. What i want is for registered
users to rate and leave reviews themselves. I'm not sure how I should set
up this database though.
Now, I have a
56 matches
Mail list logo