-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Spam Bait wrote:
[snip]
> Does anyone have a link to some docs on the syntax for 'create procedure'?
> I checked on the net for PL/SQL syntax, and found some Oracle and
> Postgres examples, but none of them worked for me.
>
> Just a little example?
H
I'm trying to do some mathematics using a time value in PHP. It's dead
simple in MySQL:
mysql> select date, duration, miles, sec_to_time(time_to_sec(duration)
/ miles) as speed from runs where shoes=6 order by date;
++--+---+--+
| date | duration | miles | spe
> Unfortunately I want my darn PHP web page to do this calculation and
> spit it out with my other run data but I can not find any useful PHP
> function similar to MySQL's sec_to_time() or time_to_sec(). Nor can I
> make mktime() do anything useful here.
You probably want strtotime(), it can do t
Hello,
I have experience using MySQL and SQL commands in
general, but I am going through my first experience
with working with multiple character sets.
I am working on a Russian/English translation project
and I'd like to create a table where column1 contains
words in Russian and column2 contains
I'm writing a SQL query that returns a set of users based each user's mutual matching
preferences. Picture a dating service, where one user is 35 looking to meet 25-35 year
olds, and another (matching) user is 25 looking to meet 30-35 year olds. The relevant
fields in the user table would be:
d
OK, really I should have RTFM closer on this one (at least the tutorial
section). http://www.mysql.com/doc/en/Date_calculations.html even has a part
about computing ages. However, I guess my original question remains, which
is, is there a better, cleaner way to do it than this, which computes the
a
Hi all,
In learning PHP and expanding my (seriously limited) SQL knowledge, I
need to write a query that will look for one or more (can be any number)
of the following fields held in the table:
+---+-+
| Field | Type|
+---+-+
| id| int(6) |
| svc
Did you ORed or ANDed the LIKE clauses?
Please provide the combined statement that didn't return results, the one
with more than one LIKE clauses.
Lian Sebe, M.Sc.
Freelance Analyst-Programmer
www.programEz.net
> -Original Message-
> From: Brown, Chris [mailto:[EMAIL PROTECTED]
> Sent: S
Hi all,
How can I get the output of the DBUG_PRINT (which is everywhere in the code of the
mysql) option to print the output as it is intended? Thanks in advance.
Yonghua
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/
Brown, Chris wrote:
> +---+-+
>> Field | Type|
> +---+-+
>> id| int(6) |
>> svc | varchar(20) |
>> sev | tinyint(1) |
>> dsc | varchar(60) |
>> inits | varchar(20) |
>> dst | date|
>> tst | time|
>> den | date|
>>
El vie, 29-08-2003 a las 22:05, Daniel Clark escribió:
> > select value from tableName where date in (select max(date) from
> > tableName where id = 4);
> >
> > But, it doesn't work with mysql 4.0.
> >
> > Any ideas? Does anybody had this problem before?
>
> What about:
>
> SELECT value, date
> FR
* Boris Villazon
> El vie, 29-08-2003 a las 22:05, Daniel Clark escribió:
> > > select value from tableName where date in (select max(date)
> > > from tableName where id = 4);
> > >
> > > But, it doesn't work with mysql 4.0.
> > >
> > > Any ideas? Does anybody had this problem before?
> >
> > What
Chris,
From: Chris Nolan ([EMAIL PROTECTED])
Subject: InnoDB questions for all!
This is the only article in this thread
View: Original Format
Newsgroups: mailing.database.myodbc
Date: 2003-08-28 16:16:53 PST
> Hi everyone!
>
> My silly questions for today concern the not-silly-at-all InnoDB table
Ok, I've got a problem, I've got an inventory of books they can be
stored in different locations in the warehouse and I need to generate a
booklist, and I want to include the title and an author, I have a table
with the authors in it, and there may be anywhere from 1 to 10 authors
for a particular
14 matches
Mail list logo
