> 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 table that holds the user info. Should I create a new table
> for each image, which holds th
Hi!
I look this warning messages on compile mysql-4.0.0.
My OS - FreeBSD 4.4
my_tempnam.c: In function `my_tempnam':
my_tempnam.c:103: warning: assignment from incompatible pointer type
my_tempnam.c:109: warning: assignment from incompatible pointer type
../mysys/libmysys.a(my_tempnam.o): In fun
Jeremy,
Firstly thank you for the reply.
On the MySql web site there are benchmark response times provided for the
execution of queries on NT 4.
e.g. reading 2,000,000 rows by index requiring 367 seconds.
Are you aware of any comparable test on Linux?
Regards,
Ronan
-Original Message
How about select max(floor(field)) from table ?
TK
> -Opprinnelig melding-
> Fra: Kraa de Simon [mailto:[EMAIL PROTECTED]]
> Sendt: 22. oktober 2001 08:44
> Til: Php-General (E-mail); MySQL (E-mail)
> Emne: Max int value of char field? How to find...
>
>
> Hello all,
>
> How can I find t
Hello all,
How can I find the highest integer value in a result set like:
1
10
11
2
3
a
ab
abc
I'm looking for the value 11.
The statement 'select max(field) from table' gives me 'abc' so this won't
do.
Any ideas for a SQL statement that will do the trick?
I'm using PHP / MySQL.
Thanks!
Si
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 tab
> 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... :>
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
common
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 the
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 a
- 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
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 |
| Open_fi
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 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 t
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"
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: my
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
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
> datPo
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
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 t
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 "B
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 logrotate
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:
>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 M
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'
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
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
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
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 wan
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
- 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
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!,
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
---
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
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 eve
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 wond
- 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 we
- 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
Help!
I've been using SQL in Access and related programs using ODBC
for some years now. Basic stuff but I find it quite straightforward.
I've now moved over, (against my will) to a PHP/MySql setup on a
web site.
I've been able to get the basic website working although God
knows how, but to
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 t
On Sun, Oct 21, 2001 at 10:13:41AM -0400, tony.icuc wrote:
> 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.
Oh, r
I know this is probably a recipe for disaster, but
would I be able to have 2 instances of mysql running,
both pointing to the same set of datafiles?
Before you ask, my reasoning for doing this would be
so that I could get some sort of underlying shared
mirrored filesystem and this way I could ha
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 mailtable.MYI
>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 op
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
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
P
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]
I've recently had a couple different problems with 3.23.32 hanging under
RedHat Linux when trying to shutdown or restart the database. I also know
at least one other guy who was having the same problem on a different
distro of Linux. In my case sometimes I've had to kill -9 mysql processes
and del
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
> > wh
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,
Thanks DL,
Seems there was double quotes at the begining of each field due
to importing data into a table using the "Load infile" statement with the
import file being DOS format rather than Unix.
As all know unix lines end with a '\n' only. When I did a test in a
row and deleted the '"' , it wo
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 MySQ
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 th
> 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 >
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 reque
- 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
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 wri
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 a
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 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
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
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 you
> 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 Cla
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 P
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 when
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 table_na
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 keys
The problem is that you're setting all the rows to "%". The % symbol is only
recognized as a wildcard in like expressions, as documented in the manual. Try this
instead:
UPDATE words_bak1 SET word = LEFT(word, LENGTH(word) - 1) WHERE word LIKE "%s";
Steve Meyers
> -Original Message---
67 matches
Mail list logo
