|
Replies:
0
-
Pages:
1
|
Threads:
[
Previous
|
Next
]
|
|
Posts:
1
Registered:
8/13/12
|
|
|
|
Mysql Custom Filter incorrect query
Posted:
Aug 13, 2012 12:35 AM
|
|
|
|
|
At the Data compare wizard, in the custom filter section which I can type a SQL query , it gives me error mysql (You have an error in your sql syntax
The query : SELECT firstName from user where id=1 LIMIT 1
Table Name is : user
id firstName lastName
1 Bill Smith
2 John Smith
my Query is fine, tested in phpMyAdmin
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
