select day(`timestamp`) as dayOfMonth, count(`timestamp`) as searchesPerDay
from mytable
where `timestamp` between '2012-05-01 00:00:00' and '2012-05-31 23:59:59')
group by dayOfMonth
order by dayOfMonth asc
iirc, timestamp is a reserved word in MySQL - hence it's enclosed in
ticks above (note
On 6/20/07, [Sunshine Tech Solutions] Ravi Gehlot
[EMAIL PROTECTED] wrote:
I know this question is prolly out topic but he it goes. How do I sort
by the last inserted Id on a sql query?
Ravi.
--
cfquery
Select col names from table
Order By tblID DESC
/cfquery
I'm not really sure what you're asking. You can use the
LAST_INSERT_ID() function to get the last auto-generated ID you've
inserted on your current connection, if that's what you mean?
cheers,
barneyb
On 6/20/07, [Sunshine Tech Solutions] Ravi Gehlot
[EMAIL PROTECTED] wrote:
I know this
Hey Barney,
Yes. Can you provide me with an example in how to use it?
Ravi.
Barney Boisvert wrote:
I'm not really sure what you're asking. You can use the
LAST_INSERT_ID() function to get the last auto-generated ID you've
inserted on your current connection, if that's what you mean?
Oh God...it must be all of that pot I have been smoking. SorryI knew
that...
;-)
Ravi.
Casey Dougall wrote:
On 6/20/07, [Sunshine Tech Solutions] Ravi Gehlot
[EMAIL PROTECTED] wrote:
I know this question is prolly out topic but he it goes. How do I sort
by the last inserted Id on
http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_last-insert-id
On 6/20/07, [Sunshine Tech Solutions] Ravi Gehlot
[EMAIL PROTECTED] wrote:
Hey Barney,
Yes. Can you provide me with an example in how to use it?
Ravi.
--
Barney Boisvert
[EMAIL PROTECTED]
-Talk
Sent: Wed Oct 11 02:18:12 2006
Subject: Re: mySql question
I've always used tinyint, but someone here might have a reason to do
different.
--
Cutter
http://blog.cutterscrossing.com
The Past is a Memory
The Future a Dream
But Today is a Gift
That's why they call
: Dave Watts
To: CF-Talk
Sent: Tue Oct 10 23:52:10 2006
Subject: RE: mySql question
Was wondering what data type one might use for booleans.
Should I use tinyint and insert 0 for false and 1 for true? I
have also heard that you could use enum...What is best?
I think that MySQL 5.0.5 has a BIT
Was wondering what data type one might use for booleans.
Should I use tinyint and insert 0 for false and 1 for true? I
have also heard that you could use enum...What is best?
I think that MySQL 5.0.5 has a BIT datatype available with all table types.
You should use that if possible.
I've always used tinyint, but someone here might have a reason to do
different.
--
Cutter
http://blog.cutterscrossing.com
The Past is a Memory
The Future a Dream
But Today is a Gift
That's why they call it
The Present
Doug Brown wrote:
Was wondering what data type one
phpmyadmin
Doug Brown wrote:
When mySql first came out, if memory serves me correctly it only had a
command line interface. Has things changed with it? Are you able to create
tables etc from a GUI interface?
Doug
~|
Navicat rocks - does that and a whole lot more. Pretty damn cheap too.
-Original Message-
From: Doug Brown [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 07, 2006 3:14 PM
To: CF-Talk
Subject: mySql question?
When mySql first came out, if memory serves me correctly it only
+10
-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 07, 2006 3:19 PM
To: CF-Talk
Subject: RE: mySql question?
Navicat rocks - does that and a whole lot more. Pretty damn cheap too.
-Original Message-
From: Doug Brown [mailto
Doug Brown wrote:
When mySql first came out, if memory serves me correctly it only had a
command line interface. Has things changed with it? Are you able to create
tables etc from a GUI interface?
There are many desktop and web based GUI interfaces to MySQL these days.
One of my
1:16 PM
Subject: Re: mySql question?
phpmyadmin
Doug Brown wrote:
When mySql first came out, if memory serves me correctly it only had a
command line interface. Has things changed with it? Are you able to create
tables etc from a GUI interface?
Doug
Yep, there is a GUI Admin tool, a GUI Query Browser, and more. See
http://dev.mysql.com/downloads/gui-tools/5.0.html.
--- Ben
-Original Message-
From: Doug Brown [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 07, 2006 3:14 PM
To: CF-Talk
Subject: mySql question?
When mySql first
It has both. If you have access to the command line you can work with that.
I'd say though that most people use a GUI. PHPMyAdmin is very popular, as is
MySQL Front.
!//--
andy matthews
web developer
certified advanced coldfusion programmer
ICGLink, Inc.
[EMAIL PROTECTED]
mySQL 5 has GUI tools available:
http://dev.mysql.com/downloads/gui-tools/5.0.html
-Original Message-
From: Doug Brown [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 07, 2006 3:14 PM
To: CF-Talk
Subject: mySql question?
When mySql first came out, if memory serves me correctly
]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Thursday, September 07, 2006 1:19 PM
Subject: RE: mySql question?
Yep, there is a GUI Admin tool, a GUI Query Browser, and more. See
http://dev.mysql.com/downloads/gui-tools/5.0.html.
--- Ben
-Original Message-
From: Doug Brown [mailto
: Thursday, September 07, 2006 12:19 PM
Subject: RE: mySql question?
Navicat rocks - does that and a whole lot more. Pretty damn cheap too.
-Original Message-
From: Doug Brown [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 07, 2006 3:14 PM
To: CF-Talk
Subject: mySql question?
When
:[EMAIL PROTECTED]
Sent: Thursday, September 07, 2006 2:20 PM
To: CF-Talk
Subject: RE: mySql question?
Yep, there is a GUI Admin tool, a GUI Query Browser, and more. See
http://dev.mysql.com/downloads/gui-tools/5.0.html.
--- Ben
-Original Message-
From: Doug Brown [mailto:[EMAIL
Yep...have a look at Navicatnice tool
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com
Navicat is my fav. It rocks!
www.navicat.com
Will
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
phpmyadmin
ahh yes the ugly and klunky as sin and a PITA to secure too...great tool ;-)
just yesterday found a wide open copy with client data easily changed and/or
exported...a true testament to it's greatness
yes..I'm done now ;-)
Bryan Stevenson B.Comm.
VP Director of E-Commerce
So how is the support for mySql and Coldfusion? Version 5...
- Original Message -
From: Will Tomlinson [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Thursday, September 07, 2006 1:18 PM
Subject: Re: mySql question?
Navicat is my fav. It rocks!
www.navicat.com
: Thursday, September 07, 2006 2:34 PM
To: CF-Talk
Subject: Re: mySql question?
Yep...have a look at Navicatnice tool
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web
:30 PM
To: CF-Talk
Subject: RE: mySql question?
Ben...
Can the GUI tools connect from your desktop to a remote database?
!//--
andy matthews
web developer
certified advanced coldfusion programmer ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
PROTECTED]
Sent: Thursday, September 07, 2006 3:47 PM
To: CF-Talk
Subject: Re: mySql question?
So how is the support for mySql and Coldfusion? Version 5...
- Original Message -
From: Will Tomlinson [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Thursday, September 07, 2006
So how is the support for mySql and Coldfusion? Version 5...
Sorry Doug...need clarification ;-)
How is the support from where? from NaviCat for mySQL? from Adobe for mySQL and
CF? other?
version 5 of what? mySQL? or CF? or both?
Cheers
Bryan Stevenson B.Comm.
VP Director of E-Commerce
Who was in this in response to Bryan?
To Doug the original posterwhy?
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com
]
Sent: Thursday, September 07, 2006 2:51 PM
To: CF-Talk
Subject: RE: mySql question?
Sure can. Actually, it always does. You define a server using hostname/ip
address, port, user login, and password. If you specify localhost as the
hostname then it is local.
--- Ben
-Original Message-
From
Ok as far as drivers for mySql for use with CF. Where do you find them at?
Doug
- Original Message -
From: Ben Forta [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Thursday, September 07, 2006 1:53 PM
Subject: RE: mySql question?
No MySQL 4 or 5 drivers included
Stevenson [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 07, 2006 2:56 PM
To: CF-Talk
Subject: Re: mySql question?
Who was in this in response to Bryan?
To Doug the original posterwhy?
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc
Doug Brown wrote:
When mySql first came out, if memory serves me correctly it only had a
command line interface. Has things changed with it? Are you able to create
tables etc from a GUI interface?
Yes, see www.mysql.com for details ;)
2:06 PM
Subject: Re: mySql question?
Doug Brown wrote:
When mySql first came out, if memory serves me correctly it only had a
command line interface. Has things changed with it? Are you able to create
tables etc from a GUI interface?
Yes, see www.mysql.com for details
--//-
-Original Message-
From: Ben Forta [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 07, 2006 2:51 PM
To: CF-Talk
Subject: RE: mySql question?
Sure can. Actually, it always does. You define a server using hostname/ip
address, port, user login, and password. If you specify localhost
...is there a better, faster was to do this in SQL directly,
preferably replacing \s*\r\n\s* so that it replaces the line break and
any leading or trailing whitespace replacing it with one single space
character.
I'm not sure if this will work with the spaces but it seems it might.
Doing a mass
You want to look at the REGEXP operator built into MySQL. You should
be able to do what you wish.
http://dev.mysql.com/doc/refman/5.0/en/regexp.html
On 3/10/06, James Smith [EMAIL PROTECTED] wrote:
One of my fields has had a collection of line breaks inserted in between
first and second names.
REGEXP is a regular expression-compaible LIKE (also known a RLIKE).
That is, it's for matching strings, not for modifying them. I don't
believe there is any way to do a regular expression replace with
MySQL, but I haven't gone looking in a while.
cheers,
barneyb
On 3/10/06, John Paul
Cutter wrote:
The following query is not allowed using my hosts version of MySQL:
cfquery name=GetCustomer datasource=#Request.DS#
username=#Request.user# password=#Request.pass#
SELECT Customer_ID FROM customers
WHERE Customer_ID = (SELECT Customer_ID FROM order_no
WHERE
But what's wrong with it? Is it the sub selects?
Ade
-Original Message-
From: Jordan Michaels [mailto:[EMAIL PROTECTED]
Sent: 24 March 2005 15:26
To: CF-Talk
Subject: Re: MySQL question
Try Query of Query - or ask your host to upgrade to version 4.x of
MySQL. Or... try a PostgreSQL
The following query is not allowed using my hosts version of MySQL:
You could do that with some nasty left join statements (untested):
SELECT cus.Customer_ID
FROM order_no AS ord
INNER JOIN customers AS cus ON (ord.Customer_ID = cus.Customer_ID)
LEFT JOIN users AS us ON (us.Customer_ID
Subject: Re: MySQL question
Try Query of Query - or ask your host to upgrade to version 4.x of
MySQL. Or... try a PostgreSQL database.
-Jordan
Cutter wrote:
The following query is not allowed using my hosts version of MySQL:
cfquery name=GetCustomer datasource=#Request.DS#
username
Tim Blair wrote:
You could do that with some nasty left join statements (untested):
SELECT cus.Customer_ID
FROM order_no AS ord
INNER JOIN customers AS cus ON (ord.Customer_ID = cus.Customer_ID)
LEFT JOIN users AS us ON (us.Customer_ID = cus.Customer_ID)
LEFT JOIN order_no AS
On Tuesday 08 Jun 2004 16:08 pm, Mark Drew wrote:
I like the applicatoin but you MUST remember that it is mainly command
line based.
cough
MySQLCC, also free from MySQL.com
/cough
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger
I meant opposed to MS SQL :)
On Wed, 9 Jun 2004 13:56:15 +0100, Thomas Chiverton
[EMAIL PROTECTED] wrote:
On Tuesday 08 Jun 2004 16:08 pm, Mark Drew wrote:
I like the applicatoin but you MUST remember that it is mainly command
line based.
cough
MySQLCC, also free from MySQL.com
/cough
I do like the MySQL Control Center (MySQLCC). A better tool than Enterprise
Manager for SQL Server!
George
At 08:56 AM 6/9/2004, Thomas Chiverton wrote:
On Tuesday 08 Jun 2004 16:08 pm, Mark Drew wrote:
I like the applicatoin but you MUST remember that it is mainly command
line based.
On Wednesday 09 Jun 2004 13:59 pm, Mark Drew wrote:
I meant opposed to MS SQL :)
See George's reply :-)
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749
You can get all your mysql needs over at http://www.mysql.com
I like the applicatoin but you MUST remember that it is mainly command
line based.
1) get yourself the applicatoin install it
2) go to c:\mysql\bin and run the mysql admin, this will install it as a service
You can do a lot of funky
Eric Creese wrote:
First where do I get a copy of MySQL
http://www.google.com/search?q=download+mysql
and second any pitfalls I need to be concerned about?
Not if you read the manual 3 times from cover to cover. But else:
http://sql-info.de/mysql/gotchas.html
Jochem
[Todays Threads]
If I were you, I would test/develop on the Linux machine right from the start.
- Original Message -
From: Eric Creese
To: CF-Talk
Sent: Tuesday, June 08, 2004 11:04 AM
Subject: MySQL question
Have a client who needs their app developed using MySQL. I have never used it before. Anyway
Does it come with a SQL interface like Query analyzer or SQL Plus?
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
I thought My SQL is free? I can not seem to find a free download on their site.
-Original Message-
From: Mark Drew [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 08, 2004 10:08 AM
To: CF-Talk
Subject: Re: MySQL question
You can get all your mysql needs over at http://www.mysql.com
I like
Does it come with a SQL interface like Query analyzer or SQL Plus?
The included interface is a command line one like iSQL (if you know it)
having said that (and I posted about his before) check out the php
administration for mysql . very powerful and has a lot of very handy
features
thanks and I believe I found the download in the devloper section. I hope this is correct?
-Original Message-
From: Mark Drew [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 08, 2004 10:46 AM
To: CF-Talk
Subject: Re: MySQL question
Does it come with a SQL interface like Query analyzer
http://dev.mysql.com/downloads/index.html
I thought My SQL is free? I can not seem to find a free download on their site.
--
Mark Drew
http://cybersonic.blogspot.com
mailto:[EMAIL PROTECTED]
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
]
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 08, 2004 10:44 AM
To: CF-Talk
Subject: RE: MySQL question
I thought My SQL is free? I can not seem to find a free download on
their site.
-Original Message-
From: Mark Drew [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June
You can user mysqlfront : www.mysqlfront.de
Pat
_
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: June 8, 2004 11:38
To: CF-Talk
Subject: RE: MySQL question
Does it come with a SQL interface like Query analyzer or SQL Plus?
_
[Todays Threads]
[This Message]
[Subscription
==
- Original Message -
From: Eric Creese
To: CF-Talk
Sent: Tuesday, June 08, 2004 10:44 AM
Subject: RE: MySQL question
I thought My SQL is free? I can not seem to find a free download on their
site.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User
Is there a user guide casue I have started this thing and I am having troubles.
-Original Message-
From: CFDEV [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 08, 2004 10:44 AM
To: CF-Talk
Subject: RE: MySQL question
You can user mysqlfront : www.mysqlfront.de
Pat
_
From: Eric
Eric Creese wrote:
Is there a user guide casue I have started this thing and I am having troubles.
http://www.mysql.com/ and type manual in the search box.
Jochem
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Eric
I would be glad to help off list as much as I can
Regards
--
Mark Drew
http://cybersonic.blogspot.com
mailto:[EMAIL PROTECTED]
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Yah I would use DB tool to connect with your MySQL ( I like Chili Source: SQL Console ) For all around multi-database use
- Original Message -
From: Jochem van Dieten
To: CF-Talk
Sent: Tuesday, June 08, 2004 12:24 PM
Subject: Re: MySQL question
Eric Creese wrote:
Is there a user
use DB tool to connect with your MySQL ( I like Chili Source: SQL Console ) For all around multi-database use
- Original Message -
From: Jochem van Dieten
To: CF-Talk
Sent: Tuesday, June 08, 2004 12:24 PM
Subject: Re: MySQL question
Eric Creese wrote:
Is there a user guide casue I
Try this:
SELECT event_id, title, city, state, zip, event_date
FROM Event ev, ref_mma rm
WHERE rm.area_id = 7
AND FIND_IN_SET(ev.zip, rm.zips) 0
AND active_ind = 1 AND private_ind = 0
The FIND_IN_SET function returns the index of the item (ev.zip) if it is
found in the set of comma delimited
65 matches
Mail list logo