d thought this could be handled in mysql, but hey, this
> >works.
>
> I don't see how it *could* work. When the password is given on the
> command line, it must follow the -p with no intervening space.
>
> >
> >rc wrote:
> >>
> >> one way
ed in mysql, but hey, this
> works.
>
> rc wrote:
> >
> > one way would bein bash - edit your .bashrc file to include the
> > following:
> >
> > alias mysql='mysql -u username -p password'
> >
> > On Thu, 21 Feb 20
any reason not to select distinct into a tmp table?
On Sun, 10 Feb 2002, DL Neil wrote:
> Rich,
>
> > How does one go about removing one of two identical records in a MySQL
> > database? My mistake in an earlier database was not applying a unique
> > number to each record (1, 2, 3, ---). I kn
off topic topic of mysql databaseperl
i need to know how to build a linux timestamp from a date given to me in
the following format 01-18-99 (m-d-y) i am using mysql to store this as an
int(11).
i know php has a mktime function, does anyone know if perl has something
similar?
anyone know why i'm getting these spam emails over this list
-- Forwarded message --
Date: Mon, 17 Dec 2001 17:36:59 -0500
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: "SOFTWARE TESTERS & DEVELOPERS CONTRACT TO HIRE"
From:-
Gani Pola
Would you not want to display the last preferences they submitted? In
this case, if you have a timestamp field for each record you could select
last(timestamp) where userid = idvaluefromform.
On Thu, 13 Dec 2001, Steve Osborne wrote:
> Is there a way to SELECT only the first matching row
is there a way to instruct check table to check all tables without listing
each table in the sql statement?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
can't you select the latest timestamp?
On Wed, 12 Dec 2001, Lindstrom Greg - glinds wrote:
> Greetings-
>
> I have a MySQL database with a table (job_table) containing information
> concerning jobs I run. Among the fields on the table are job_id
> (varchar(10)), and timestamp (a timestamp). As
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
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
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
is data a reseverd word in mysql?
On Wed, 31 Oct 2001, Richard W. Wood wrote:
> I've been trying to add the following table to my database, and I keep
> getting the error below.
>
> CREATE TABLE mod_userpage_data (
>id INT(5) NOT NULL default '0',
>title VARCHAR(200) NULL,
>data L
doesn't windows have some control panel that lets you turn sounds off and
on for certain functions and/or events?
On Tue, 30 Oct 2001, Paul DuBois wrote:
> >Paul DuBois wrote:
> >
> >>At 4:34 PM -0500 10/30/01, Benjamin J Pracht wrote:
> >
> >
> >>>Does anyone know how to turn that annoying b
rd PHP functions won't work. (And yes, I did just test it.)
>
> -Original Message-
> From: rc [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 30, 2001 1:58 PM
> To: Matthew Walker
> Cc: [EMAIL PROTECTED]
> Subject: Re: PHP/MySQL Problem
>
> Mysql_Inse
s, I did just test it.)
>
> -Original Message-
> From: rc [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 30, 2001 1:58 PM
> To: Matthew Walker
> Cc: [EMAIL PROTECTED]
> Subject: Re: PHP/MySQL Problem
>
> Mysql_Insert_ID($dbhandle->connection);
>
> gets th
Mysql_Insert_ID($dbhandle->connection);
gets the last id of the last insert statement - if you do any db activity
after the insert, this won't work.
On Tue, 30 Oct 2001, Matthew Walker wrote:
> Does anyone see anything wrong with the following code/query syntax? I'm
> using the PEAR DB class f
indexes.
On Tue, 30 Oct 2001, Jason Parker wrote:
>
> - Original Message -
> From: Jason Parker
> To: [EMAIL PROTECTED]
> Sent: Tuesday, October 30, 2001 9:11 AM
> Subject: improve the speed of update, insert, delete and select queries
> through mySQL
>
>
> Anyone,
> Does anyone know
17 matches
Mail list logo
