 |
|
|
|
Next: My ongoing saga with 'locks' and out of memory.
|
| Author |
Message |
External
Since: Feb 21, 2009
Posts: 3
|
(Msg. 1) Posted: Sun Nov 15, 2009 12:39 pm
Post subject: Select more than just *
Archived from groups: comp>databases>mysql (more info?)
|
|
|
|
|
| Back to top |
|
 | |
External
Since: Aug 21, 2008
Posts: 6
|
(Msg. 2) Posted: Sun Nov 15, 2009 1:21 pm
Post subject: Re: Select more than just * [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
On Nov 15, 3:39 pm, The87Boy wrote:
> Is it possible to run a query like this:
> SELECT *, DATEDIFF(CURDATE(), `updated`) AS `daysSinceUpdate` FROM
> `Admin`
Did you try it?
>
> Or should I let PHP calculate the days since update? |
|
| Back to top |
|
| |
External
Since: Feb 21, 2009
Posts: 3
|
(Msg. 3) Posted: Sun Nov 15, 2009 11:51 pm
Post subject: Re: Select more than just * [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
On 15 Nov., 22:21, toby wrote:
> On Nov 15, 3:39 pm, The87Boy wrote:
>
> > Is it possible to run a query like this:
> > SELECT *, DATEDIFF(CURDATE(), `updated`) AS `daysSinceUpdate` FROM
> > `Admin`
>
> Did you try it?
Actually no >> Stay informed about: Select more than just * |
|
| Back to top |
|
| |
External
Since: Oct 21, 2009
Posts: 4
|
(Msg. 4) Posted: Mon Nov 16, 2009 4:25 pm
Post subject: Re: Select more than just * [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
| Related Topics: | select with regexp - i have a column "path" with values eg. +---------------+ | path | +---------------+ |/path/path/path| +---------------+ |/path/path | +---------------+ |/path | +---------------+ i want to select the row where there are ...
Random select - Hi, When I do a select with a limit I get always the same records. Usually this is the desidered effect. But now I want to do a random select. So every time I do a select I should get a different set of results. What is the best way to achieve this..
Select Query Help - I'm struggling - with my limited knowledge of SQL - to write a query that does what I want it to, and I was hoping that someone here may be able to help out. I have a table with two columns, user1 and user2, which store user ID's. For example: ..
Count lines in select - I have a table t1: id int unique added timestamp and second table t2: eid int id int unique t2.id are IDs from t1. t2.eid with the same value can be found in t2 more than for one entry but they will all have different IDs. I want to: ..
Restoring select databases/tables from an --all-databases .. - I use the --all-databases switch to backup my entire database. Sometimes there's a need to restore individual databases or tables form the backup file. What command should I use for this? Thanks, Raffi |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
