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 th
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 date
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]
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 inser
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?
>
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 ques
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.
>
> --
Select col names from table
Order By tblID DESC
~~~
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:
al Message-
From: 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 t
elated)
To: CF-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
Tha
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
> 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. Otherw
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 Quarter
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
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
my
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 co
214.636.6126
-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 Connec
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=
com.mysql.jdbc.log.StandardLogger&useUnicode=true&characterEncoding=UTF8&user=xxx
gt; --//->
>
> -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
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 drive
Ok I think I got it to finally work. I am using the mySql myODBC 3.51. I did
not know about the connection string.
- Original Message -
From: "Josh Nathanson" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Thursday, September 07, 2006 4:54 PM
Subject:
om/cfusion/knowledgebase/index.cfm?id=tn_19170
-- Josh
- Original Message -
From: "Munson, Jacob" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Thursday, September 07, 2006 3:35 PM
Subject: RE: another mySql question...
> I've always used MySQL's JDBC dr
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 Oracle
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, 200
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 Cold
, September 07, 2006 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 interf
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 ;)
~
Just checking. I had asked a question as well. Wasn't sure if you were
answering mine.
-Original Message-
From: Bryan 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 Br
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"
Sent: Thursday, September 07, 2006 1:53 PM
Subject: RE: mySql question?
> No MySQL 4 or 5 drivers
Very nice. I'll have to give them a look. Thank you.
-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,
> 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
~~~
> 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 De
[mailto:[EMAIL 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"
Sent: Thursda
:30 PM
To: CF-Talk
Subject: RE: mySql question?
Ben...
Can the GUI tools connect from your desktop to a remote database?
-Original Message-
From: Ben Forta [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 07, 2006 2:20 PM
To: CF-Talk
Subject: RE: mySql question?
Yep, there is a GUI
Who was in this in response to Bryan?
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: 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-Comm
So how is the support for mySql and Coldfusion? Version 5...
- Original Message -
From: "Will Tomlinson" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Thursday, September 07, 2006 1:18 PM
Subject: Re: mySql question?
> Navicat is my fav. It rocks!
> 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 Develop
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.
http:
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
~~
Ben...
Can the GUI tools connect from your desktop to a remote database?
-Original Message-
From: Ben Forta [mailto:[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
nt: 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
>
t; <[EMAIL PROTECTED]>
To: "CF-Talk"
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
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
-Talk
Subject: mySql question?
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
~|
Introducin
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
r 07, 2006 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 f
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 favorit
+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 [
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 s
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
>
>
~~~
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 Quart
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 Ashenfelte
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 nam
<< ...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
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
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"? Cas
>> 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 be
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'
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 1
if your next 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: "Limi
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.
--
--
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 e
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 orde
gt;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 database.
>
>-Jordan
>
>
>Cutter wrote:
>
>
>
>>The following query is not
> 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
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 Postg
Cutter wrote:
>The following query is not allowed using my hosts version of MySQL:
>
>username="#Request.user#" password="#Request.pass#">
>SELECT Customer_ID FROM customers
>WHERE Customer_ID = (SELECT Customer_ID FROM order_no
>WHERE Order_No = #Order_No#)
>AND Customer_ID NO
The following query is not allowed using my hosts version of MySQL:
SELECT Customer_ID FROM customers
WHERE Customer_ID = (SELECT Customer_ID FROM order_no
WHERE Order_No = #Order_No#)
AND Customer_ID NOT IN (SELECT Customer_ID FROM users)
AND Customer_ID NOT IN (SELECT Custom
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=day&day=03&month=11&year=20
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
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 +0
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 ho
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 beca
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
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 office-humour.co.
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
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.
>
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.
>
>
> MySQLCC, also free from MySQL.com
>
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.
MySQLCC, also free from MySQL.com
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underw
gt; wrote:
>
> 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:
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:
>
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]
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]
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
==
- 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
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
ECTED]
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,
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]
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
> 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 http://www.
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?
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
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
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]
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 t
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 conce
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
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
98 matches
Mail list logo