Hi.
On Mon, Dec 03, 2001 at 11:41:38PM -0800, [EMAIL PROTECTED] wrote:
> These areI thinkpre-built
> Dunno for sure.
>
> # rpm -qa | grep -i glibc
> compat-glibc-6.2-2.1.3.2
> glibc-devel-2.2-5
> glibc-common-2.2.4-13
> glibc-2.2.4-13
> # mysql --version
> mysql Ver 11.6 Distrib 3.23.28
[EMAIL PROTECTED] 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 include
> one of the following words in your message:
>
> database,sql,query,table
Why does this list not include SELECT and INSERT?
...in MySQL, to keep the list filter happy :-(
Hi,
I have several different SELECTs, each of which returns a set of results which
I'd like to combine in a boolean fashion.
So, say I have 4 selects, w, x, y, and z, I might want to do:
((x AND y) OR Z ) AND (NOT w)
What's the best way of going
Hi.
mysql.sock is created by the mysqld process when it is started. The
lack of it usually means that either mysqld doesn't run or that the
file got deleted by an other process. For more info, see
http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html
Bye,
Benjamin.
On Thu, Dec 0
neeraj arora wrote:
>
> Hi,
> I think indexing the column(s) can help you.
Already spent a week figuring how to get the SELECT to work fast when a few
results are returned, os all appropriate columns are indexed ;-)
> u can find more on this page
> http://www.linux-mag.com/cgi-bin/printer.pl?i
Hi!
> "Greg" == Greg Cope <[EMAIL PROTECTED]> writes:
Greg> We use the Sun's cc complier - this is the standard complier here on Spark /
Greg> Solaris.
The problem is that we don't have access to a system to a Solaris 8 system
with SUN cc installed.
(If anyone want to make one available
On Thu, Dec 06, 2001 at 09:08:41AM +, Chris Withers wrote:
> [EMAIL PROTECTED] 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 include
> > one of the following words in your message:
> >
>
On Thu, Dec 06, 2001 at 09:10:38AM +, Chris Withers wrote:
> ...in MySQL, to keep the list filter happy :-(
>
> Hi,
>
> I have several different SELECTs, each of which returns a set of
> results which I'd like to combine in a boolean fashion. So, say I
> have 4 selects, w, x, y, and
On Wed, Dec 05, 2001 at 04:57:42PM -0700, Jon Gardiner wrote:
>
> I can't speak for other table formats but in MyIsam tables you can
> take your database down, rename the table's files (.frm .MYI .MYD),
> and restart the server. I'd make a backup if you are going to try
> it, though.
Watch out i
Jeremy Zawodny wrote:
>
> Hm. It sounds like you just want to combine the WHERE clauses
> (intelligently) and end up with one big query, right?
Yup, but given that each WHERE clause is already pretty hairy, I was hoping
someone would say "oh, sure, here's some set operations to complement UNION
On Thu, Dec 06, 2001 at 11:15:03AM +, Chris Withers wrote:
> Jeremy Zawodny wrote:
> >
> > Hm. It sounds like you just want to combine the WHERE clauses
> > (intelligently) and end up with one big query, right?
>
> Yup, but given that each WHERE clause is already pretty hairy, I was
> hopin
On Thu, Dec 06, 2001 at 09:28:10AM +, Chris Withers wrote:
> neeraj arora wrote:
> >
> Already spent a week figuring how to get the SELECT to work fast when a few
> results are returned, os all appropriate columns are indexed ;-)
>
> > u can find more on this page
> > http://www.linux-mag.co
Hi
check if mysqld is running if not start it and try again.
daniel
josep wrote:
>I get the following message when trying to view a php page
>
>Warning: Access denied for user: 'jupshoes@localhost' (Using password: YES)
>in /home/jupshoes/public_html/guest/index.php on line 27
>Unable to conne
On Thu, Dec 06, 2001 at 09:39:18AM +1000, Arjen G. Lentz wrote:
> Well, you have to realise that the server can only use a one index
> per table (for obvious reasons).
That's far from being obvious to a lot of folks...
> You can actually split a table into multiple identical ones, by
> using ME
Jeremy Zawodny wrote:
>
> > Yup, but given that each WHERE clause is already pretty hairy, I was
> > hoping someone would say "oh, sure, here's some set operations to
> > complement UNION" ;-)
>
> How about, "try out MySQL 4.0 with UNION support"? :-)
Can UNION do boolean AND, NOT and OR combin
Jeremy Zawodny wrote:
>
> SQL_BUFFER_RESULT (http://www.mysql.com/doc/S/E/SELECT.html) my help,
> depending on what the real bottleneck is.
H... I thought temporary tables were bad?
> Sure, change your
>
> SELECT * FROM foo WHERE ...
>
> to
>
> SELECT COUNT(*) FROM foo WHERE ...
>
>
On Thu, Dec 06, 2001 at 11:59:04AM +, Chris Withers wrote:
> Jeremy Zawodny wrote:
> >
> > > Yup, but given that each WHERE clause is already pretty hairy, I was
> > > hoping someone would say "oh, sure, here's some set operations to
> > > complement UNION" ;-)
> >
> > How about, "try out My
Hello,
At seemingly random intervals all of the privileges for every user
in the mysql.user table get set to 'N'. I found the statements below in the
binlog. Is there a way to find out who/what ran these?
Answers to some security questions: There are only three users in
MySQL.
On Thu, Dec 06, 2001 at 12:05:01PM +, Chris Withers wrote:
> Jeremy Zawodny wrote:
> >
> > SQL_BUFFER_RESULT (http://www.mysql.com/doc/S/E/SELECT.html) my help,
> > depending on what the real bottleneck is.
>
> H... I thought temporary tables were bad?
It depends on the problem. In you
On Tue, Dec 04, 2001 at 11:05:52AM +0100, Ornella Fasolo wrote:
> Hallo,
>
> i would like to know if there is a reliability mechanism inside
> mysql. I have a server on a machine and several clients that access
> to the server My problem is to find a way to assure that if the Data
> base machine
On Mon, Dec 03, 2001 at 08:01:11PM -0800, Peschko, Edward wrote:
> hey,
>
> I was wondering if you had any plans to port mysql to os-390, and
> the open edition environment there. I think it would be a really
> cool idea, considering that most shops that have a IBM mainframe are
> looking for way
On Tue, Dec 04, 2001 at 04:37:31PM +0200, Sinisa Milivojevic wrote:
> Hofhauser, Bela writes:
> > Hi,
>
> MySQL 3.23 already has synchronous replication. It is in a
> widespread use already.
I'd call it asynchronous replication. The master really has little
concept of what the slaves are doing m
On Mon, Dec 03, 2001 at 09:28:11AM -0800, Steve Osborne wrote:
>
> I have an existing database with ISAM tables that I would like to
> convert to MyISAM tables. Using phpMyAdmin, I can change the table
> type using a drop-down box, however I do not know the repercussions
> of the table type conve
Jeremy Zawodny writes:
> On Thu, Dec 06, 2001 at 11:59:04AM +, Chris Withers wrote:
> > Can UNION do boolean AND, NOT and OR combination of sets generated
> > by SELECTs?
>
> Hmm...
>
> http://www.mysql.com/doc/U/N/UNION.html
>
> Nope. :-(
>
> Jeremy
> --
> Jeremy D. Zawodny, <[EMAIL PR
Jeremy Zawodny writes:
>
> If you do find someone running MySQL on Linux on the big iron, I'd
> love to hear about it. Heck, if GCC, Perl, and Apache can work on it,
> there's a chance that some hacker at IBM has alredy managed to get
> MySQL working, too. That'd be excellent.
>
> Jeremy
> --
Jeremy Zawodny writes:
>
> I'd call it asynchronous replication. The master really has little
> concept of what the slaves are doing most of the time, right?
>
> Jeremy
> --
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 349-7878 Fax: (408) 349-5454
I'm able to connect to connect to the database but unable to select
elements.
Josep
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To r
On Thu, Dec 06, 2001 at 02:57:15PM +0200, Sinisa Milivojevic wrote:
> Jeremy Zawodny writes:
> >
> > If you do find someone running MySQL on Linux on the big iron, I'd
> > love to hear about it. Heck, if GCC, Perl, and Apache can work on it,
> > there's a chance that some hacker at IBM has alred
Josep
As root you need to log in to the database mysql. You then need to give
whatever priviledges you want to your normal account. See section 6.14 in
the manual (Adding New user Privileges to MySQL).
Dave
>From: "josep" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Subject: howto change db
I've had a few queries that worked strangely worked in Mysql monitor,
but did not work from PHP.
I was able to solve every one of them by ensure that the query in PHP did
not have any line breaks in it. It normally doesn't matter if there are
line breaks in the code, but on occassion, a line
Sinisa Milivojevic wrote:
>
> No, but in 4.1 there will be INTERCEPT and MINUS too, beside
> UNION's (with or without ALL option). Those three combined can
> produce any of the above relational operations.
wooah! *dribble*! :-)
When can I start using this code?
Where can I get it from?
ch
Just a small bit of help...
Before a make this change I would like some help
Am I right in think if in the MySQL database on the db tables there are no
blank host enters then there is no point in having anything in the host
table?
Thanks Simon
Hello
I have installed MySQL in Cobalt Raq 3
Please can sendme info for aneble MySQL to mi customers in cobalt raq?
Please
Beste regards
Pablo martin
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Hi,
I am new to MySQL and installed the Win2000 version on my labtop. I had no
problems until I got to the security part and did the following according to
the docs:
The default privileges on Windows give all local users full privileges to
all databases without specifying a password. To make MyS
Hi,
Did you make contact with Borland Support?
Did you post message in Borland Newsgroup, 'newsgroups.borland.com'?
Edward Valentine wrote:
>
> I downloaded and installed the new patch from Borland that allows Kylix to
> use versions of MySQL 3.23 and newer. Most of the errors on connecti
Jeremy Zawodny writes:
>
> Ah, excellent.
>
> Do you know if he's one any benchmarks with it? Those machines tend
> to have great I/O systems, so I'd expect very good performance.
>
> Any chance I could get his e-mail address via private mail?
>
> Jeremy
> --
> Jeremy D. Zawodny, <[EMAIL PRO
hi,
i just upgrade mysql to newer version 3.23.45 and now the slave that is
just upgraded (the master will be the next to be upgraded but in one
week) return such error:
011206 15:29:41 Slave thread: error connecting to master: Unknown MySQL
Server Host 'hostname' (0) (76), retry in 60 sec
i
:Now, is there any way I can quickly return the length of the
:result set withotu
:actually returning the result set itself?
:
:
:Chris
:
:(MySQL question, obviously ;-)
Dunno if this was answered cause I'm on digest but,
Try SELECT Count(*) from...
erik
st.m
__
On 6 Dec 2001, at 9:08, Chris Withers wrote:
> > database,sql,query,table
>
> Why does this list not include SELECT and INSERT?!
Worse, why do we have to put up with the filtering at all when it's
not doing its job? The Portuguese spam got through yesterday, but
legitimate messages are block
Dear Sirs and Madams,
EMS HiTech company is announcing the next version (1.22) of MySQL
Manager -- A Powerful MySQL Administration and Development Tool for
Windows95/98/ME/NT/2000/XP.
You can download the latest version from
http://www.mysqlmanager.com/download.phtml
What's new in version 1.22
I'm trying to determine the "correct" way of
dealing with a high availability situation,
which might also be a high performance (spread queries
across multiple systems) situation.
I've "googled" for MySQL cluster, and found one
project that last seems last touched a year ago.
1) All data is rea
"DL Neil" <[EMAIL PROTECTED]> on 12/06/2001 12:26:45 AM
Internet mail from:
Please respond to "DL Neil" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
cc: <[EMAIL PROTECTED]>
Subject: Re: select statement group by unusual results
Chip,
> > I have a database with 12 tables. I am running
On Thursday 06 December 2001 03:50 am, Jeremy Zawodny wrote:
> Because it's not yet perfect. ?Perhaps someone at MySQL.com and update
> the filters a bit. ?Sasha, maybe?
It is important to understand that no bot could ever get it right in 100% of
the cases regardless of how sophisticated the rul
> -Original Message-
> From: Barry Roomberg [mailto:[EMAIL PROTECTED]]
A few notes:
> 1) All data is readonly. No write requirement except
> monthly load.
use myisam pack to compress the data / indexs.
Also use -rq --analyse --sort-index as myisam arguments to rebuild the index
Hello,
I want to install mysql on my sun (solaris 2.7). But I have a problem. The
output after configuring is:
loading cache ./config.cache
checking host system type... sparc-sun-solaris2.7
checking target system type... sparc-sun-solaris2.7
checking build system type... sparc-sun-solaris2.7
ch
At 20:25 2001-12-06 +0500, Igor Brynskich wrote:
allo
Is this product free like MYSQLfront?
If it is not free,
Can I considere it as a SPAM
(SPAM is a no sollocited commercial email)
on a Mailling List?
Ray
>Dear Sirs and Madams,
>
>EMS HiTech company is announcing the next version (1.22) of
Can anyone tell me why I am receiving the following error? I am connecting
to a remote server via ssh, and accessed the mysql prompt by typing: mysql
The following is the screen contents after trying to use the ALTER
TABLE command; 'dbname' has been sub'd for actual database name.
Welco
Bettina Ketzmerick wrote:
> Hello,
>
> I want to install mysql on my sun (solaris 2.7). But I have a problem. The
> output after configuring is:
>
> loading cache ./config.cache
> checking host system type... sparc-sun-solaris2.7
> checking target system type... sparc-sun-solaris2.7
> checking
I was wondering if anyone could help me converting some PostgreSQL
queries with sub-queries into a similar form usable (hopefully) by both,
or at least into a form that I can use in place of the PostgreSQL ones.
I'm going to post them - I hope no one minds. If this is the wrong
mailing list for
Hmm
30 days trial then you have to register.
Seems like spam to me
Raymond Abel wrote:
>
> At 20:25 2001-12-06 +0500, Igor Brynskich wrote:
>
> allo
>
> Is this product free like MYSQLfront?
>
> If it is not free,
> Can I considere it as a SPAM
> (SPAM is a no sollocited commercial email)
>
Hi Chip,
> Thanks for the tips. So here's my latest attemp:
>
> select distinct Title, Details, StartDate, StopDate, City, State
> from phpCalendar_Details t1, phpCalendar_Daily t2, phpCalendar_EventLocations t3
> where t1.LocationID = t2.LocationID
> and t1.EventLocationID = t3.EventLocationID
>
I think you are overreacting with your spam thing.
Quoted from the link he gave:
===
This trial version is FULLY functional!
An unregistered copy of the EMS MySQL Manager may be used for evaluation
purposes for a period of 30 (thirty) days following the initial
installation. At the end of the TRI
are you sure you don't want to UPDATE Advertisers SET PACK_KEYS=0;?
Steve Osborne wrote:
>Can anyone tell me why I am receiving the following error? I am connecting
>to a remote server via ssh, and accessed the mysql prompt by typing: mysql
> The following is the screen contents after try
Steve Osborne writes:
> ERROR 2000: Access denied for user: '@localhost' to database 'dbname'
>
> Can anyone give me some insight as to why I cannot do this? Do I require
> root privileges to do this (right now I am logged in as a user, as this
> remote server is an ISP)?
What unix user you a
Hi,
we have a mysql server with a strange behaviour: when we execute a query, it
takes about 5 seconds, even for simple selects which should return almost
immediately.
I run "mysqladmin --sleep=1 processlist" to see what happens, and the
process is in 'sleep' mode for 5 seconds. I never see the
It means you're connecting to the server as an annonymous user.
If you have a username to connect to the server, run the following
query:
mysql> show grants for your_user_name@localhost;
and it will show you all the priveleges that you have for specific
databases and tables. That's the best wa
Has anyone had a similar problem? I can't figure out what I'm doing wrong.
Help!
(database description in previous post)
> THIS QUERY WORKS:
> SELECT * FROM products WHERE (MATCH
> (title,short_desc,long_desc,spec_desc,item_no) AGAINST ('rubber'))
>
> THIS QUERY DOES NOT WORK -- RETURNS NOTH
Hi,
I'm getting Duplicate Keys errors from mysql when i have more than one
application attempting to insert into a table. I've tried using LOCK TABLES
to no avail.
Can anyone describe how the Duplicate Keys error occurs so I can understand
how to code around it ?
regards,
Graeme Wallace
XXI
I don't know how this affects anything, but, I'm running the most recent
version of mySQL for win98.
Why is it that an SQL statement like this (or any variation)...
SELECT * FROM classification
WHERE level1 = "FOO" AND level2 = "NULL";
will return an empty set. I know that there should be resul
"DL Neil" <[EMAIL PROTECTED]> on 12/06/2001 05:27:55 PM
Internet mail from:
Please respond to "DL Neil" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
cc: <[EMAIL PROTECTED]>
Subject: Re: select statement group by unusual results
Hi Chip,
> Thanks for the tips. So here's my latest attem
SELECT * FROM classification
WHERE level1 = "FOO" AND level2 IS NULL;
IS NULL instead of = "NULL"
null is not a value, it's the abscence of value
Etienne
"Ward, Mark" wrote:
>
> I don't know how this affects anything, but, I'm running the most recent
> version of mySQL for win98.
>
> Why is
Hi,
I have a couple of problems with mysql 4.0.
First: I tried to compile a new binary using the online docs. The
configure script (./configure --prefix=/usr/local/mysql) when fine.
After a "make" command, it stops at libmysql stating some kind of
recurssive problem.
I also tried using the bin
Don't use binaries cuz I prefer to roll my own...
# c++ -v
Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
# gcc -v
Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 2731 (Red
Well considering that you are searching for the text 'NULL' and not a null
value
haveyou tried " level2 is null" ?
:-)
- Original Message -
From: "Ward, Mark" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, December 06, 2001 6:37 PM
Subject: NULL Strings
> I don't know
Hi!
Sorry for delay :-(
On Dec 05, Mark J. Degallier wrote:
> >
> > I need a repeatable test case.
>
> CREATE TABLE products (
> id mediumint(6) default NULL auto_increment,
> numOfFileUploads tinyint(2) NOT NULL default '2',
> category_id text NOT NULL,
> item_no varchar(30) NOT NULL d
Okay, got through that NULL problem. Thanks.
My next question is regarding using the DOS prompt. At work, I'm using
Win2000. When I'm using mySQL, if I want to repeat commands, I can just
press the up key without retyping the whole thing. But at home I use Win98.
I can't do the same thing, even t
I can tell you how we solved this problem.
we have a 24/7 op where we need to constantly pull data from mysql
machines. This data can be updated at anytime by our tools, but the
live servers will only be reading data. So we have one machine which is
connected to our tools box, this is wher
I've been using mysqlbinlog to capture a file of inserts/updates/deletes on
numerous servers since the early 3.23.x days. I have 3.23.46-max on a pair
of servers now though where it is exhibiting some strange behavior. Based on
some emailed suggestions I've tried leaving off the "-uroot -ppassword
hum maybe you can cut/paste with the right button of your mouse.
this does not work under winNT4, but on my win2k it does, and you could
try it on your machine.
right click in the screen replaces the ctrl-v used for "paste" and it
automatically cuts any highlighted text (as in mIRC)
HTH
Etienne
I have compiled mySql before on Solaris, and never had this problem.
On this system, configure goes fine, and make chugs along until the 'sql'
directory, at which point the following occurs:
gcc -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti
-fno-implicit-templates -fno-except
Hi, I have just setup a dedicated linux/php/mysql dev box in my office and I
am gearing up to move my databases from a windows box to the linux box.
There are a couple of things I would like to be clear on before I start.
1) when I am logged into linux as "user1" and I create a database, does t
On Thu, Dec 06, 2001 at 04:30:29AM -0800, Jeremy Zawodny wrote:
> On Mon, Dec 03, 2001 at 08:01:11PM -0800, Peschko, Edward wrote:
> > hey,
> >
> > I was wondering if you had any plans to port mysql to os-390, and
> > the open edition environment there. I think it would be a really
> > cool idea,
On Thursday, December 6, 2001, at 02:15 PM, Curtis Gordon wrote:
> Hi, I have just setup a dedicated linux/php/mysql dev box in my office
> and I am gearing up to move my databases from a windows box to the
> linux box. There are a couple of things I would like to be clear on
> before I start
Hello everyone,
I have this create table statement,
drop table IF EXISTS GROUP_CONCLUSION_GROUPING CASCADE;
CREATE TABLE IF NOT EXISTS GROUP_CONCLUSION_GROUPING(
ANALYSIS_RESULT_ID MEDIUMINT(20) PRIMARY KEY REFERENCES
PAD_ANALYSIS_RESULT(ANALYSIS_RESULT_ID),
GROUP_CONCLUSION_IDMEDIU
Just to add a few side notes.
We have 2 MySQL's running on a RH/Linux 6.2 box, and it has proven to be very
stable and very reliable. :)
We have approx., 30+ clients that use the one of the MySQL servers, and we set
up each client with a .my.cnf in each of the respective root directories:
/home
As far as I know, you can't do tht. What you could do instead is
have one Primary Key col and make another one UNIQUE.
I did that several times, and it does work!
--
What they need to teach in school is for people to think for themselves. :-)
-- Larry Wall in <[EMAIL PROTECTED]>
Thank you Eric and Mike, I really appreciate the help!
>From: "Mike(mickalo)Blezien" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: "Curtis Gordon" <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
>Subject: Re: just moved from windows to linux mysql
>Date: Thu, 06 Dec 2001 13:50:52 -0600
>
>Jus
why not use a concatenated Primary key?
create table tname
col_name1 int,
col_name2 int,
PRIMARY KEY (col_name1,col_name2)
you get the drift
On Thu, 6 Dec 2001, sherzodR wrote:
>
> As far as I know, you can't do tht. What you could do instead is
> have one Primary Key col and make
At 2:46 PM -0500 12/6/01, Erik Price wrote:
>On Thursday, December 6, 2001, at 02:15 PM, Curtis Gordon wrote:
>>2) can somebody, anybody offer up some links to a quicky tutorial
>>on loading a database with existing data, and backing up an
>>existing database. I don't mean the ones in the mysql
Hi,
I am having a problem with the configuration of the mysql server or client.
I have a very large query that I need to send to MySQL from Java. The query
has approximately 5000 individual items in the where clause. (i.e. WHERE
i!='AP' AND i != 'J3' AND...to 5000).
When I try to execute the Q
On 6 Dec 2001 [EMAIL PROTECTED] 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 include
> one of the following words in your message:
>
> database,sql,query,table
>
> If you just reply to this message
We are interested in installing MySQL 3.23.46 from source on our Solaris
2.8 machine. However, we could not find berkeley DB 3.2.9a that is
required by MySQL package. Does anyone know where to find it? Thanks.
Since I am not on this mailing list, please send the reply to
[EMAIL PROTECTED]
Thank
Ziying Sherwin <[EMAIL PROTECTED]> writes:
> We are interested in installing MySQL 3.23.46 from source on our Solaris
> 2.8 machine. However, we could not find berkeley DB 3.2.9a that is
> required by MySQL package. Does anyone know where to find it? Thanks.
>
> Since I am not on this mailing li
mysql.sock is created by mysqld and deleted when mysqld stops
-Original Message-
From: David Phoon [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 05, 2001 11:31 PM
To: [EMAIL PROTECTED]
Subject: does mysql.sock come with a linux 323 installation
I'd like to know if mysql.sock come
using primary key (col1, col2) makes no index on col2... which is not
good if you lookup only in col2
primary key (col1),
unique index (col2)
don't forget to add "not null" beside your col2 definition.
Etienne
rc wrote:
>
> why not use a concatenated Primary key?
>
> create table tname
> c
http://www.linux-mag.com/2001-03/mysql_01.html
There ya go, you can't have it better explained, as for the user access
part.
For the data transfer, that I don't know
Etienne
Curtis Gordon wrote:
>
> Hi, I have just setup a dedicated linux/php/mysql dev box in my office and I
> am gearing up t
I found a way to have two primary key, if those keys relate on many
columns.
mysql> create table keytest(
-> col1 int not null,
-> col2 int not null,
-> unique index (id1,id2),
-> unique index (id2,id1)
Query OK, 0 rows affected (0.01 sec)
mysql> describe keytest;
+---+--
for a table in a database (just so my message makes it to the list):
can you make a concatenated primary key, then make the second one an
index?
-
Before posting, please check:
http://www.mysql.com/manual.php (the man
We're having severe problems here. We've been running 2.23.3 on Redhat 6.2
for a while and all has been well. I've also installed mysql several times
with no issues. We had a hard drive go out today, and since then we have not
been able to get mysql to successfully start and accept connections. Ty
Hi,
I need to implement an access/logging system in mysql+php,
which once a user logs in, does not let another
individuals log in using the same user-password. I don´t care if users
share a user-password, the only thing I want to avoid is that this users
sharing the same user-pw combination, don´
Hello,
I have some usernames and passwords. The passwords have had the PASSWORD()
function used on them. I need to set up an area of a site to allow users to
have their passwords e-mailed to them. I can't just say SELECT password
FROM table WHERE email='$email' AND username='$username' because
No - instead, update the password with a new, random one, and e-mail the
random one to the user.
- Jonathan
-Original Message-
From: Tyler Longren [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 06, 2001 1:37 PM
To: MySQL List
Subject: PASSWORD() question
Hello,
I have some userna
Hi,
That may have the desired effect of two unique keys, but you stil only have
one primary key (probably id1,id2). PRI is listed against each column
involved in the Primary key.
Regards
Quentin
-Original Message-
From: Etienne Marcotte [mailto:[EMAIL PROTECTED]]
Sent: Friday, 7 Decemb
Hello, all --
Somehow my simple image file-organizing database has turned into
something huge and frightening. I was hoping that I could get some
input on what I have so far -- it seems correct to me but because it
links so many tables together, I wonder if I'm supposed to be doing this
much
Hi
What about a table with logged in user ids and a timestamp (I use a sessions
table).
Update the timestamp when they access the system. Check when a user tries to
login. If that user id, but a different person, has accessed the system
within the last xx minutes or seconds then consider them lo
Hi,
I get difference of 15 hours when i issue select sysdate(); command on
mysql> prompt and date command on bash shell.
I am using cobalt linux. I change system time from server interface control
panel.
Can anyone tell me what would be the problem.
My time format is ICT.
I changed my forma
HELP PLEASE !!
I have run into a problem where my ISP upgraded their mysql version, and now
the dump files (.sql) from the mysqldump command cannot be restored on my
local server. Unfortunately, I have to wait for our server to be updated,
so the simplest solution is not an option. The error th
> But both these queries produce identical one-row results for me.
> I've tried both 3.23 and 4.0 versions.
> Isn't your MySQL version too old ?
Thanks -- sorry for being a pest!
I was using a beta 3.23 version -- I upgraded and it is fixed.
... a lesson learned :-(
-Mark
---
Hi all,
We have a system in place that is a LAMP application. The
system we have it running on is a FreeBSD 4.3 on a Pentium 3
1Ghz with 500MB of RAM.
A mysqladmin -i5 stat returns:
Uptime: 44254 Threads: 24 Questions: 779657 Slow queries: 531
Opens: 213 Flush tables: 1 Open table
Pack keys is the only flag that we had trouble with when we were upgrading.
As an emergency fix you could use the following to restore:
sed -e "s/PACK_KEYS=1//g" < filename.sql | mysql --user=root -p
backupdatabasename
Jon Gardiner.
> -Original Message-
> From: Steve Osborne [mailto:[E
1 - 100 of 141 matches
Mail list logo
