Devart Forums

I checked for the latest version. I closed the connection, and dbForge Studio then restarted. All I'm trying to do is change the name of a table from `wapello county rentals new` to `w`. I tried using Rename and Edit Table. Neither will allow it. I get a syntax error on line 1.

When I click the >>| button, it displays the last record number as 7623, but scrolls to the bottom of the list, and the unique key, incremented REC# shows 15,387.

Also, I attempted to run a SELECT statement on the 15,387 records. I click Text, I appended to the end such that the statement now reads

"SELECT * FROM `iowacounties`.`wapello county rentals new` WHERE `wapello county rentals new`.`House Number` <> `wapello county rentals new`.`Mail to Address`"

I click execute, I get no errors, but the records that are displayed are the exact same set as before the query. Is there a beginners tutorial that I missed? I'll keep searching YouTube but ... I think I'm doing everything correctly.

I checked for the latest version. I closed the connection, and dbForge Studio then restarted. All I'm trying to do is change the name of a table from `wapello county rentals new` to `w`. I tried using Rename and Edit Table. Neither will allow it. I get a syntax error on line 1.

Please make sure you are performing renaming rather than refactoring. Please refer to the 'Refactoring Overview' for details.

If that's still not the problem, could you please provide us the following information:
1. Screenshot of the error message.
2. Version of the MySQL server.
3. Version of dbForge Studio for MySQL.
4. CREATE TABLE statement of the table (right-click the table in Database Explorer and select 'Generate Script As -> CREATE' from the popup menu).

When I click the >>| button, it displays the last record number as 7623, but scrolls to the bottom of the list, and the unique key, incremented REC# shows 15,387.

Could you please provide us a screenshot of this? There might have been displayed 7623+ which means that in fact there were more than 7623 rows. Please also provide us the result of the following query:

SELECT count(*) FROM `iowacounties`.`wapello county rentals new`

I click execute, I get no errors, but the records that are displayed are the exact same set as before the query.

Could you please provide us the result of the following query:

SELECT * FROM `iowacounties`.`wapello county rentals new` WHERE `wapello county rentals new`.`House Number` = `wapello county rentals new`.`Mail to Address`

You can send the reply straight to our support system at supportATdevartDOTcom, so we will keep further correspondence with you on this issue via that system.

Is there a beginners tutorial that I missed?

Please refer to the product's Help documentation and the following material on our website:

http://www.devart.com/dbforge/mysql/studio/demos.html
http://www.devart.com/dbforge/mysql/stu ... -more.html
http://blogs.devart.com/dbforge/tag/mysql