It's an Earth language. But I know what you mean. :-)
The Google translator works great btw.
http://translate.google.com/
Cheers!
~~Fish~~
2011/4/28 Pintér Tibor
> On 04/28/2011 12:40 PM, Johan De Meersman wrote:
>
>> Я предлагаю более отчетливо английски применения :-p
>>
>
> could you guys
I had some coffee and realized that actually, using a UUID might be
something to look at. There have been quite a few discussions about using a
UUID as a unique id and it does have some gotchas. Just Google: mysql uuid
Have a great day
~~Fish~~
On Mon, Sep 13, 2010 at 7:30 AM, Fish
I could be way off here, but how about letting your unique id be a
calculated column of the the server's MAC address concatenated with an
auto-increment id column?
I hope this helps...
~~Fish~~
On Mon, Sep 13, 2010 at 7:26 AM, Johan De Meersman wrote:
> Hmm, that's a very interesting scenario,
I prefer the good old command line.
~~Fish~~
On Jul 1, 2010 7:38 AM, "David Stoltz" wrote:
Hi Folks,
I'm currently using phpMyAdmin to manage the mySQL databases. I'm
wondering what most people like to use? I know there is "mySQL
Workbench", which I haven't really fooled with yet
Can a
A Google video search for "mysql for beginners" found this guy's beginner
tutorials. I only glanced at them but they look pretty helpful.
http://www.youtube.com/user/leanjhuls
I hope this helps.
~~Fish~~
On Wed, Jul 15, 2009 at 9:20 AM, Marcus Bointon
wrote:
> On 15 Jul 2009, at 13:56, sh
Since MAC addreses also contain letters, BIGINT wouldn't work. So, yes, I
would say go with CHAR(12).
On May 14, 2009 9:43 AM, "Ilia KATZ" wrote:
Hi.
Currently I have a table:
1. MAC address defined as BIGINT
2. MAC address set as primary key
Should I consider changing it to CHAR(12)?
Replies
Happy Gnu Year to everyone!!
On Wed, Dec 31, 2008 at 11:30 PM, Prathima Rao wrote:
> HAPPY NEW YEAR
>
>
> - Original Message - From: "John Daisley" <
> john.dais...@mypostoffice.co.uk>
> To: "MySQL General List"
> Sent: Thursday, January 01, 2009 7:25 AM
> Subject: Happy New Year
>
>
>
T only the most recent dateTime and critterXYZ
> for
> each critterName and return one row for each unique critterName.
>
>
> For examples & discussion see "Within-group aggregates" at
> http://localhost/artful/infotree/queries.php.
>
I have a dataset like this:
+++--+-+
|regionName|critterName|critterXYZ|dateTime
|
+++--+-+
|
You may want to have a look at this:
http://www.dhtmlgoodies.com/scripts/drag-drop-custom/demo-drag-drop-3.html
CheersFish
On Sun, Nov 23, 2008 at 6:12 AM, <[EMAIL PROTECTED]> wrote:
> Does it support interaction in terms of allowing user to click on
> individual part of the composite image
Great. Glad to hear you sorted it out.
On Tue, Oct 28, 2008 at 9:02 PM, Dr Michael Daly <[EMAIL PROTECTED]>wrote:
> Hi
> Thanks for your help everyone
>
> I was overwriting the files into the existing database dir. Maybe there
> was some additional files there that were causing a problem. I jus
encourage anyone to chime in who has ideas. :-)
~~Fish~~
On Mon, Oct 27, 2008 at 11:55 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote:
> I sooo hear that now. That is the funniest thing I have heard this month.
>
>
> On Mon, Oct 27, 2008 at 8:36 PM, Fish Kungfu <[EMAIL PROT
For some reason when I started reading this, I heard Humphrey Bogart's voice
speaking it like the beginning of one of his dark and rainy black & white
detective movies. ;-)
On Mon, Oct 27, 2008 at 10:25 PM, Dr Michael Daly <[EMAIL PROTECTED]>wrote:
It all started when I deleted one of the user
Hmmm, that is strange indeed. Hopefully one of the Level 70+ MySQL Wizards
on the list can explain why this might happen.
~~Fish~~
On Sat, Oct 25, 2008 at 4:44 PM, Joe Auty <[EMAIL PROTECTED]> wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Fish Kungfu wrote:
n the *.* part. I hope this fixes it for
you.
CheersFish
~ Second Life addict
On Sat, Oct 25, 2008 at 3:15 PM, Joe Auty <[EMAIL PROTECTED]> wrote:
> Fish Kungfu wrote:
>
>> Would you mind posting what you tried? Did you put single quote
n the *.* part. I hope this fixes it for
you.
CheersFish
~ Second Life addict
On Sat, Oct 25, 2008 at 3:15 PM, Joe Auty <[EMAIL PROTECTED]> wrote:
> Fish Kungfu wrote:
>
>> Would you mind posting what you tried? Did you put single quote
Would you mind posting what you tried? Did you put single quotes around the
wildcard like '%' ?
For example: GRANT ALL ON somedb.* TO 'someuser'@'%';
Also see http://dev.mysql.com/doc/refman/5.0/en/grant.html
CheersFish
On Sat, Oct 25, 2008 at 1:40 PM, Joe Auty <[EMAIL PROTECTED]> w
Has the user been GRANTed PRIVILEGES yet? Look here for how to do that:
http://dev.mysql.com/doc/refman/5.0/en/adding-users.html
Cheers...Fish
On Sat, Oct 4, 2008 at 12:36 PM, David Giragosian <[EMAIL PROTECTED]>wrote:
> On Sat, Oct 4, 2008 at 11:33 AM, Varuna Seneviratna <
> [EMAIL PROTECTE
I would do #3.
On 10/3/08, Alex K <[EMAIL PROTECTED]> wrote:
>
> Hello,
>
> I have a table of a 1 million users. I want to add a flag called
> delete if a user wants to delete his account. Note that this situation
> does not happen a lot.
>
> 1) Should I alter my users table and add a delete fla
HOORAY!!! Thanks for all of yours and Tony's hard work!
CheersFish
-
~~Second Life addict~~
-Original Message-
>From: Stefan Hinz <[EMAIL PROTECTED]>
>Sent: Aug 15, 2008 11:09 AM
>To: mysql@lists.mysql.com
>Subject: PHP Documentation in the MySQL Manual
>
>PHP Do
>
>Maybe what I am seeing in the Query Browser area is in fact a Warning
>message and not an error!!
>
>If so, sorry to have wasted anyone's time
>
>Regards
>
>Roger
>
>
>
>
>
>-Original Message-
>From: Fish Kungfu [mailto:[EMAIL PROTECTE
Hmmm. It works okay for me, without an error when the tabel doesn't exist.
I'm using mysql Server version 5.0.51a-3ubuntu5.1
For example:
*
mysql> use lsldatabase;
Reading table information for completion of table and column names
You can turn off
I agree with Jerry. Take a look at the UUID() function.
http://dev.mysql.com/doc/refman/5.1/en/miscellaneous-functions.html#function_uuid
Second Life (http://secondlife.com) uses UUIDs to track millions and millions
of unique items every day.
CheersFish
-Original Message-
>From: Je
w in set (0.30 sec)
CheersFish
-Original Message-
>From: Roy Lyseng <[EMAIL PROTECTED]>
>Sent: Jul 31, 2008 9:41 AM
>To: Fish Kungfu <[EMAIL PROTECTED]>
>Subject: Re: COUNT returned rows of a SELECT
>
>Hi,
>
>generally you should be able to use the
(dateTime) LIKE CONCAT(DATE(NOW()),'%') GROUP BY aviName) |
+--+
|
11|
+--+
Rob Wultsch wrote:
> On Wed, Jul 30, 2008 at 9:41 PM, Fis
Using MySQL commands only (not PHP's mysql_num_rows), is there a way to
COUNT the number of rows returned from a SELECT.GROUP BY?
My primary SELECT query is this:
SELECT aviName,MAX(dateTime) FROM aviTrackerMain WHERE DATE(dateTime)
LIKE CONCAT(DATE(NOW()),'%') GROUP BY aviName;
And it faith
26 matches
Mail list logo