Forum Replies Created
-
AuthorPosts
-
Shadow
MemberHi Bobnz,
could you tell me at which table did the import stop?
MemberThere is no naming convention in SQLyog, it is MySql and the os on which MySql is running that restricts what characters are acceptable in a db/column/field/index name.
MySql does not allow “/”, “” and “.” in the db names, “/” and “.” in table names. If your os restricts the usage of other characters in directory and file names, then those characters are not allowed either.
MemberActually, there is at least one other db with built-in form designer. It's called Oracle…
It would be nice to have such an app for MySql as well, but I don't really want to mix an end-user data entry app with an admin app (such as SQLyog). Just raises too many questions about security.
MemberWhat can a client do, if MySql refuses to connect via SSL, but connects in the normal way and does not raise any error (may log in in the error log in case log-warnings is specified and you run MySql 4.0.13 or higher) and there is no variable that would indicate that the connection is secured or not?
MemberThe problem is, that MySql provides poor feedback whether SSL connection has been established or not. If you had not set REQUIRE SSL, then MySql would silently connect you in the unencrypted way providing that SSL did not work out. Even if you had set REQUIRE SSL,but your MySql is not open_ssl enabled then MySql would connect you in the traditional way. It is known bug, perhaps 4.0.14 had it already fixed, I'm not sure.
Anyway, no matter what os you speak of, most MySql users have experienced difficulties setting up SSL enabled MySql servers. If I wanted to be sure that I have a secure connection to MySql, I would use an SSH client to tunnel my queries to the server. The trick is to have an SSL client on your machine and on the machine where MySql is running.
To be honest, I never really liked SSL and if security is so important, than administer your DB from localhost because that is the safest way!
MemberSSL was meant to be a transparent protocol, the communicating parties need not be aware of its presence and therefore need not check whether the connection is secured. If an application requires encription under all circumstances then it would be necessary to check whether ssl is enabled or not. I don't consider SQLyog such an application…
MemberOoops, you are right! Well, then you can save the sql commands to the personal store and invoke them later any time you want.
MemberDates must be given in year-month-day order (for example, '99-07-30') and not in month-day-year commonly used in English-speaking areas.
MemberFLUSH is a standard MySQL command, you can read more about it in the MySQL manual's 4.5.3 FLUSH Syntax chapter.
MemberApparently you work on some kind of linux/unix because on Win table names are case insensitive (OS file names are case insensitive). You should consider starting mysqld as: mysqld -O lower_case_table_names=1. This will convert all table names to lowercase. (From version 4.0.2, this option also applies to database names.) Old names, however, need to be converted manually…
MemberExperienced the same behaviour, too!
MemberWhat version of SQLyog do you use? In v3.52 there is a reorder columns function (table menu)…
MemberUnfortunately no. Perhaps this feature will be included in the next release…
MemberYour IT friend was right suggesting to use the third table because books and authors have a many-to-many relationship (a book may have several authors and an author may write several books) and relational dbs do not really like such connections. To resolve such situations (they are quite common) a third table is introduced that hold the primary keys of both tables, thus holding every possible combination of the two primary keys. Actually, I don't understand why you use an autoincrement id column in table_books_authors table, book_id and author_id fields combined may serve as primary key.
How to do it in SQLyog? Just create the table_books_authors table with two columns (book_id, author_id) and mark both columns as primary key.
As you are new to MySql, I would like to point out that MySql is able to use different storage engines for the tables. The default is MyISAM which – currently – cannot handle relationships. If you want to to use relationships then INNODB storage engine should be used.
MemberAfter MySql 5.0 (or 5.1) gets released then it will be possible as MySql does not support views yet. Besides, SQLyog is an admin tool and not an end-user input form for MySql. At least, not yet…
-
AuthorPosts
