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
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
* 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
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
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|
>>
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/
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,
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
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
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
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
> 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
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
-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
14 matches
Mail list logo
