34 search results

Page 3 out of 4 Pages

• About the SQLyog program: I am already using GUI tools from MySQL. Why should I buy SQLyog?
  
  Answer:   Because in most situations you will find that SQLyog is more simple to use and more intuitive than the tools from MySQL.  During the time ...
  
  
• Data Types and Storage Engines: What Storage Engines are supported by SQLyog?
  
  Answer: Any! (well .. almost)Starting from SQLyog 5.2 the list of available Storage Engines (before MySQL 4.1 named 'Types') is not hard-coded into the program but ...
  
  
• Manipulating data.: Can I use the auto_increment attribute without using that column as a Primary Key.
  
  Answer:   Yes! MySQL allows for that. The rules are:There can only be one auto_increment column in a tableThis column must be defined as a KEYWe ...
  
  
• Using the GUI: The 'remove comment' functionality does not remove all comments.
  
  Answer:   SQLyog GUI provides an option to highlight any set of statements in the Editor and 'comment-out' those statements. And to revert back again (un-commenting) too, ...
  
  
• Using the GUI: Do I need to SET NAMES to display characters of my language?
  
  Answer: No, you won't. SQLyog does all what is required! With the introduction of SQLyog version 6 SQLyog always uses UTF8 internally. Whenever SQLyog communicates ...
  
  
• Using the GUI: How do I define TIMESTAMP properties with SQLyog?
  
  Answer:   The TIMESTAMP datatype is the MySQL datatype that causes most problems. Basically there are three reasons for this * The implementation for the TIMESTAMP type ...
  
  
• SQL Scheduler and Reporting Tool: Can I schedule CSV export and import?
  
  Answer: The CSV export and import functionality of the SQLyog GUI are not directly implemented in the SJA. But both are posible with relative simple SQL ...
  
  
• Database Schema Synchronization: Problem with string default '' (empty string) and Schema Synchronisation
  
  Answer:   You experience that Schema Sync finds no difference for a string type declared NOT NULL default '' (empty string) and NOT NULL (with no default). This ...
  
  
• Data Types and Storage Engines: Does SQLyog support spatial datatypes?
  
  Answer:   Well .. both yes and no! 'spatial' (or 'geometrical'/'geodetical'/'geographical') datatypes are special datatypes used in conjunction with specific types of programs like GIS ('Geograhical Information Systems') ...
  
  
• Working with Views, Stored Procedures and Triggers: I have full privileges to a database but cannot ALTER a routine. Why?
  
  Answer: You experience that you have full privileges to a database (described in GRANT syntax like GRANT ALL PRIVILEGES ON some_database.* TO 'me'@'somehost') but cannot ALTER ...
  
  

<<  previous  1  2  3  4  next  >>