Why is this SQLquery in Matlab returning repeated records?

2 views (last 30 days)
I used JDBC driver to connect to the mySQL DB in Matlab. The connection works. However, when I used following SQLquery in Matlab to get data:
SQLquery = ['SELECT * FROM db_XYZ WHERE Col_Name=' '''Col_A'''];
I got repeated (always three times) results shown as below:
1 Col_A CA SFO 1 Col_A CA SFO 1 Col_A Ca SFO
There is only row of "1 Col_A Ca SFO" in the database table.
Why? Thanks...

Answers (0)

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!