0 Reputation Points
100% Quality Score
- Upvotes Received
- 1
- Posts with Upvotes
- 1
- Upvoting Members
- 1
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
3 Posted Topics
Do something like: [code]INSERT INTO table1 (col1, col2, col3) SELECT col1, col2, col3 FROM table2 WHERE col4='some value'[/code]
Re: datetime query
[code]SELECT * FROM date BETWEEN '2008-10-01' AND '2008-12-12'[/code] [url]http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html#operator_between[/url]
Hi, I need to match rows from one table to another table that may or may not have a match on one common column.... the problem begins with bringing back the most recent row in the other table. So, the query I'm starting with is: [code]SELECT * FROM data LEFT …
The End.