Argh, that was not the one i wanted to send :)
This is the one:
select s.* from store s
where s.id not in
(select t.storeid from trans t
where t.created > date(now()) - interval 1 day);
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
On Tue, April 17, 2007 09:20, Mog
Arg, come on, really.
where t.created <= date(now()));
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
On Mon, April 16, 2007 15:18, Jay Blanchard wrote:
> [snip]
> select s.* from store s
> where s.id not in
> (select t.storeid from trans t where t.created=date(now()));
> [/sn
[snip]
[snip]
select s.* from store s
where s.id not in
(select t.storeid from trans t where t.created=date(now()));
[/snip]
This is close, but it does not exclude previous days. I only want to see
those that have not logged in today.
[/snip]
select store.storeid, store.stname
from store
[snip]
select s.* from store s
where s.id not in
(select t.storeid from trans t where t.created=date(now()));
[/snip]
This is close, but it does not exclude previous days. I only want to see
those that have not logged in today.
--
MySQL General Mailing List
For list archives: http://lists.
How about this:
select s.* from store s
where s.id not in
(select t.storeid from trans t where t.created=date(now()));
--
Later
Mogens Melander
+45 40 85 71 38
+66 870 133 224
On Sat, April 14, 2007 00:22, Jay Blanchard wrote:
> Good day gurus and gurettes!
>
> I have a table;
>
> | tr
It depends on what's in the datetime column.
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
Something like this:
select store.storeid, store.stName
from store left outer join transaction
on(store.storeid = transaction.storeid)
where transaction.created IS NULL
and store.ac
* Roger Baklund
> * Scott Haneda
[...]
> > How do I see the path for defaults-extra-file
>
> That would be in an option file or at the command line when the
> mysql daemon was started.
Sorry, that is not correct. The 'defaults-extra-file' option must be the
first parameter on the command line, see
* Scott Haneda
[...]
> That¹s where I am lost, I can see all these options in show variables;
> However, I only have /etc/my.cnf, I do not have DATADIR/my.cnf, ~/.my.cnf
> and as stated before, there is only a path to my data directory in
> /etc/my.cnf
>
> So I still wonder, where are all my other
on 8/26/03 2:05 AM, Roger Baklund at [EMAIL PROTECTED] wrote:
> * Scott Haneda
> [...]
>> * Roger Baklund
>>> For information on the options files:
>>>
>>> http://www.mysql.com/doc/en/Option_files.html >
> [...]
>
>> Where do all my defaults come from if my.cnf only has
>> datadir=/usr/local/mys
* Scott Haneda
[...]
> * Roger Baklund
> > For information on the options files:
> >
> > http://www.mysql.com/doc/en/Option_files.html >
[...]
> Where do all my defaults come from if my.cnf only has
> datadir=/usr/local/mysql/data
Like the link describes, there are multiple my.cnf files, mysql re
on 8/26/03 1:40 AM, Roger Baklund at [EMAIL PROTECTED] wrote:
> * Scott Haneda
>> I have mysql 3.23.51-entropy.ch
>> I have never used a my.conf file other than to tell it one thing which is
>> datadir=/usr/local/mysql/data
>>
>> I have a gig of memory and only apache runs on this machine. It is
* Scott Haneda
> I have mysql 3.23.51-entropy.ch
> I have never used a my.conf file other than to tell it one thing which is
> datadir=/usr/local/mysql/data
>
> I have a gig of memory and only apache runs on this machine. It is OS X
> 10.1.5. How can I tell how mysql is running, since I don¹t hav
As Victoria says, you can't. However I agree that this syntax is useless
in many real-world situations. You are not the only one who finds this
behaviour annoying. It's about time someone made SQL a 21st century
language...
"Miroslav I." wrote:
>
> Hallo
>
> suppose you have a table with great
On 04-Aug-2003 Miroslav I. wrote:
> You need every field except the 'dateOB' and 'idSCHOOL'
>
> Ordinary select wold be:
>
> SELECT
> id,name,surname,idCITY,idSTATE,sex,idParent1,idParent2,interests,weight,he
> ight,age,auditDate,idAudittor,
> FROM TName
>
> It is too long expression,
I'm writing a function for Perl module I'm writing that will allow you to do
$query = "SELECT".DBIallexcept($dbh,'fred','wilma')."FROM monkey";
If that will help. Let em know and I'll notify you when it's done.
Thanks
Dan
>>
> As Victoria says, you can't. However I agree that this syntax
>
"Miroslav I." <[EMAIL PROTECTED]> wrote:
>
> suppose you have a table with great number of columns (20 or 30),
> and you would like to specify every one but two or tree columns in a SELECT
> statement.
>
> Is there a way to specify only those two or tree columns for omission (which would
> be t
Is your temp directory running out of disk space?
Seth Brundle wrote:
I attempted to optimize a table last night, which usually takes about 5
minutes but I expected to take longer as I had done a slew of deletes.
Well, it took over an hour, and from the last modified dates on the table
and temp f
Will,
Friday, December 06, 2002, 7:01:46 AM, you wrote:
WS> 2 - To back up the db... can I just copy the files in that directory to a
WS> backup device like a CD or floppy?
You can .. but it's not recommended way. For more info about database
backups refer to the manual:
http://www.mysql.
* Will Standley
> 1 - When I create a new db using MySQL...
>
> Can I tell MySQL where (what path & directory) to store the new db files?
No, not at runtime. This can only be changed while the server is not
running. Edit the 'datadir' or 'basedir' parameter in the my.cnf file, or
use a startup opt
On Thu, May 23, 2002 at 10:17:33AM +0200, Per Andreas Buer wrote:
> Hi.
>
> I've got an database-server with 768MB RAM running
> MySQL/InnoDB. There is quite a lot of I/O activity - about
> 7Mbytes/s. I am not quite sure why there is so much I/O - maybe the
> indexes won't fit into memory?
>
> I
On Tue, May 22, 2001 at 06:56:00PM -0700, Nathanial Hendler wrote:
>
> How does one know if their database server needs more memory? I
> have several tables around 600,000+ rows that are being joined. I
> have 512MB of memory. Is there a rule of thumb, or a good way to
> calculate how much mem
21 matches
Mail list logo
