From Navicat Wiki
- How can I do Find and Replace in Navicat?
- Why does Navicat only display MEMO/TEXT in data grid? How can I see the actual text?
- Why I cannot successfully create the foreign keys?
- Is there a way that I can get the table names to be saved in the case that I enter them in?
- How do I insert pictures into my table?
- Can I copy a table by Drag and Drop?
- What's this warning about my table not having a primary key?
- How can I set the number of records displayed per page in the Table view?
- Is it possible to use MySQL functions in the default of a field under TableDesign fields tab in Navicat?
- Can I create foreign key between two tables of different Database in the Design Table Window?
- Why my auto increment field no longer works after row 127?
- Can I view table details by mouse rollover on the table name?
- How to view table structure of a table?
- How to export a table with binary data to a SQL file?
- Can I search for a value in the table without a query?
- Why do the number of rows change everytime when I refresh the Table Main View?
- How to merge two tables that have same table structure?
- How to display special characters properly in MySQL?
- How can I display Unicode in Linux?
- Why I can't change the character set and collation for field, table and database?
- Why the number of row of Oracle table is not updated in Table Main View?
- Why Navicat has only four SQLite data types?
MySQL/MariaDB Error Code
- 1005 - Can't create table 'xxx' (errno: 150)
- 1026 - Error writing file '\WINNT\TEMP\xxx ' (errcode: 28)
- 1146 - Table 'mysql.proc' doesn't exist
- 1577 - Cannot proceed because system tables used by Event Scheduler where found damaged at server start