We copy and paste text from Word into a database. What happens when cutting and pasting from Word, it replaces an apostrophe with a question mark so for example "you're" becomes "you?re" in the database. Is there a way to search for all question marks that are not correct in Crystal since...
I have a text file with numerous update statements. The text file is running and it shows the following after it has run each update statement.
Query OK; 1 row affected (0.47 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Is there a way on the command line to show which update statement it has...
rows
id term
1 932
1 934
2 992
2 1008
3 944
3 1014
I want to delete any ids if their first term was less than 992 so in the example above, only the 2 rows for id 2 would remain in the database, since id 2 first term is 992. I'm thinking that I would need a group by and having...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.