Should be a simple one for a mysql guru. What is the mysql equivalent of the
following?
select datePart(dd,timestamp) as dayOfMonth, count(timestamp) as
searchesPerDay
from mytable
where (timestamp between '5/1/2012 00:00:00' and '5/31/2012 23:59:59')
group by datePart(dd,timestamp)
order by
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
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.
--
---
Ravi Gehlot.
Sr. Management
Sunshine Technology Solutions, LLC
http://www.sunshinetechsolutions.com/
[EMAIL PROTECTED]
Cell Phone:
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?
Doug
~|
Introducing the Fusion Authority
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
-Original Message-
From: Josh Nathanson [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 07, 2006 5:55 PM
To: CF-Talk
Subject: Re: another mySql question...
AFAIK you *have* to use the JDBC driver with MySQL 4+/CF, you cannot use
the
ODBC driver at all. It's called Connector/J I think, you
Ken Ferguson wrote:
That is a false statement. I'm currently using the ODBC drivers with
MySQL 4.1 and MySQL 5 and CF works fine with both. The only thing is
that you can't use the MySQL ODBC driver that CF has built in to the
admin, as it is only for 4.x versions.
(coldfusion doesn't come
I think Ken means JDBC and I think its just namespace conflict problem with
jLog for which a good classloader will resolve and you can not use a
pageContext based classloader for this. ODBC is a Microsoft technology for
windows only. myODBC is something else altogether. A classloader can put the
Correct, sorry, built-in JDBC is what I meant, the 3.x built-int JDBC
driver. Thanks for the correction.
Thanks,
Ken Ferguson
214.636.6126
-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: Friday, September 08, 2006 9:50 AM
To: CF-Talk
Subject: Re: another mySql
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
~|
Introducing the Fusion Authority
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
]
615.370.1530 x737
--//-
-Original Message-
From: Doug Brown [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 07, 2006 2:14 PM
To: CF-Talk
Subject: mySql question?
When mySql first came out, if memory serves me correctly it only had a
command line interface. Has things
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
Anybody run across this before? The connection fails. I can verify the
datasource in windows but cannot verify in CF. Also I do not see the myODBC
after installing the connector, is that by design?
Update CF Data Source Info
The ODBC data source XXX cannot be edited remotely. The
I've always used MySQL's JDBC driver, not ODBC. If you search Ben
Forta's blog, there's an entry about MySQL 5 in CF, and this has good
directions for getting it to work in the comments.
-Original Message-
From: Doug Brown [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 07, 2006
Yes I've seen a similar error before.
Mine was NaviCat could connect to the DB just fine, but CF would always say the
DB could not be found or was not running. MOst people have easy success with
the connector, but some of us just ran into brick walls.
This is why I use MS SQL Server and
/knowledgebase/index.cfm?id=tn_19170
-- Josh
- Original Message -
From: Munson, Jacob [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Thursday, September 07, 2006 3:35 PM
Subject: RE: another mySql question...
I've always used MySQL's JDBC driver, not ODBC. If you search
://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_19170
-- Josh
- Original Message -
From: Munson, Jacob [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Thursday, September 07, 2006 3:35 PM
Subject: RE: another mySql question...
I've always used MySQL's JDBC driver
Josh Nathanson wrote:
AFAIK you *have* to use the JDBC driver with MySQL 4+/CF, you cannot use the
ODBC driver at all. It's called Connector/J I think, you have to download
it from the MySQL website -- here's the link:
I think you're confused. You cannot use the built in MySQL JDBC driver
--//-
-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
You cannot use the built in MySQL JDBC driver with MySQL 4/5 in Coldfusion -
only 3.23 for 7 I thought they fixed that?
Install mysql-connector-java-5.0.0-beta-bin.jar
then
jdbc:mysql://localhost:3306/?logger=
One of my fields has had a collection of line breaks inserted in between
first and second names. I think I have solved the problem but I now need to
remove all of the line breaks that have been inserted so far.
I could query the db then use CF to replace chr(13) chr(10) with , but
is there a
...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
On 11/3/05, Lewis Sellers [EMAIL PROTECTED] wrote:
A. SELECT TOP 50 doesn't work in mySQL. Top is
only SQL
Server, correct?
B. From Shows Limit 50 returns an error as well.
To further elaborate on your question...
Question: Is it Shows or shows? Case makes a difference (between
Using a mySQL Database with thousands of records. For the query below,
to optimize performance, I'd like to be able to return on the TOP N records.
A. SELECT TOP 50 doesn't work in mySQL. Top is only SQL
Server, correct?
B. From Shows Limit 50 returns an error as well.
1. What's the equal
Les,
1. What's the equal of TOP in mySQL?
LIMIT is the correct syntax, but you just had it in the place:
SELECT * FROM myTable ORDER BY myField LIMIT 10
2. At what point in the query is that actually evaluated?
Right at the end, after any WHERE/ORDER statements etc.
HTH,
Tim.
--
statement to me was to try to hit me up for a
spare copy of tcpclient or something :-P
--min
-Original Message-
From: Lewis Sellers [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 03, 2005 3:13 PM
To: CF-Talk
Subject: Re: Limit or Top and mySQL Question
I believe you've
I believe you've answered yourself in your subject. It's called LIMIT
in mysql, and it's slightly more flexible than using TOP.
SELECT Airdates.ShowID FROM shows LIMIT 30;
shows only the first 30 records returned from the query.
SELECT Airdates.ShowID FROM shows LIMIT 10,30;
shows records
I thought you were dead!!! ;)
-Original Message-
From: Lewis Sellers [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 03, 2005 3:13 PM
To: CF-Talk
Subject: Re: Limit or Top and mySQL Question
I believe you've answered yourself in your subject. It's called LIMIT
in mysql, and it's
A. SELECT TOP 50 doesn't work in mySQL. Top is
only SQL
Server, correct?
B. From Shows Limit 50 returns an error as well.
To further elaborate on your question...
Question: Is it Shows or shows? Case makes a difference (between
platforms). As a general rule it's best to have all
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 Order_No =
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
Why does in the CF7 Admin show the MySQL driver as MySQL (3.x) , does
this signify the lowest version supported or that only 3 is supported?
The later cannot be true as I'm running a 4.x db. Is there another
MySQL driver that's recommended for 4?
Cheers,
Ian
--
Bored? Check out
You have to install the v4 driver yourself, and I believe there is
already a technote on how to do so (as well as being blogged by Steven
Erat).
I'm sure someone from MM will pip in with the reasons as to why the v4
driver wasn't shipped :-)
On Wed, 9 Feb 2005 10:49:06 +, Ian Winter [EMAIL
Andy Allan wrote:
You have to install the v4 driver yourself, and I believe there is
already a technote on how to do so (as well as being blogged by Steven
Erat).
I'm sure someone from MM will pip in with the reasons as to why the v4
driver wasn't shipped :-)
More than likely its because the
Hmm, OK. I saw Steven's post when it came out. I'll go back and have a
re-read. Would be nice to know why it didn't ship though.
On Wed, 9 Feb 2005 10:56:58 +, Andy Allan [EMAIL PROTECTED] wrote:
You have to install the v4 driver yourself, and I believe there is
already a technote on how
That would be reasonable, does the 3.x in the admin in fact refer to
the driver version then rather than DB ver's supported? Might be worth
that being changed just to MySQL, it's never shown a version number
before. Just being fussy, but, people might get confused.
On Wed, 09 Feb 2005 11:05:11
Stephen Moretti (cfmaster) wrote:
Andy Allan wrote:
You have to install the v4 driver yourself, and I believe there is
already a technote on how to do so (as well as being blogged by Steven
Erat).
I'm sure someone from MM will pip in with the reasons as to why the v4
driver wasn't
On Feb 9, 2005, at 6:10 AM, Ian Winter wrote:
Hmm, OK. I saw Steven's post when it came out. I'll go back and have a
re-read. Would be nice to know why it didn't ship though.
I'll save some of you the Google search:
http://www.talkingtree.com/blog/index.cfm?
mode=dayday=03month=11year=2004
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
Have a client who needs their app developed using MySQL. I have never used it before. Anyway I need to get a copy of it and run it on Windows2000. Then When I am done developing I will be putting it on a Linux machine.
First where do I get a copy of MySQL and second any pitfalls I need to be
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
I have a simple question regarding LIKE clauses in MySQL.
I have a table that contains a comma-delimited list of zip codes. I have another table that contains addresses. I would like to pull all the records from the second table where the zip code is contained in the zip code field of the first
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
98 matches
Mail list logo
