VALUES ('1', '04/13/2002', '10:46:19');
INSERT INTO blah_events_power VALUES ('1', '07/28/2002', '11:51:19');
**
Should return 6 dates:
'04/13/2002'
'04/14/2002'
'05/13/2002'
'05/24/2002'
'06/21/2002'
'07/28/2002'
--
Mark Wilson, Computer Programming Unlimited
syntax. Check the manual that corresponds to your
MySQL server version for the right syntax to use near 'SELECT MAX(
plan_submission_number )
FROM 'artifacts'
WHERE p
---
What am I missing? Thanks
- Mark
--
Mark Wilson, Computer Programming Unlimited (cpuworks.com)
Web
' AND plan_submission_number = '2')
--
Mark Wilson, Computer Programming Unlimited (cpuworks.com)
Web : http://cpuworks.com Tel: 410-549-6006
Email: [EMAIL PROTECTED] Fax: 410-549-4408
Quoting Mark Wilson [EMAIL PROTECTED]:
I have an app for which people can submit plans.
Each plan
Er, I _used_ a basic SQL tutorial, which specifically said that should work.
The problem seems to be a limitation of MySQL, not general SQL operation.
That being said, are there any clever one-query options (using JOINs, etc?) or
is this basically a 2-step process in MySQL?
--
Mark Wilson
Is it possible to rename a MySQL table? If so, how?
If not, is there a simple query syntax to copy a table?
I don't have access to the command-line version,
just a web interface, and no, not anything nice like PhpMyAdmin! :-(
--
Mark Wilson, Computer Programming Unlimited (cpuworks.com)
Web