Forum Replies Created
-
AuthorPosts
-
uyuniMember
I found the answer myself.
The difference is “bulk insert”. bulk insert is MUCH faster!
uyuniMemberThen please set a high priority for this. I've been missing this for years.
uyuniMemberThen please set a high prioritity. It can't be very difficult.
uyuniMemberThanks!
uyuniMemberWell it is not real outside the scope. Other programs do this, like for example total commander for its FTP connections.
uyuniMemberSQLYog saves all passwords. When my notebooks gets stolen I have a problem. But I don't want to remember all individual passwords. When SQLYog has one password for opening all connections then stealing my notebook doesn't help anyone to get into my servers.
Emilio
uyuniMemberI mean obfuscation.
It's clear that a professional can crack this. But it's not as simple as just opening a file!
Emilio
uyuniMemberI just detected a bug in this functionality: Duplicate Table Structure/data
The history is not correct. When there is an autoincrement field in the source table, the SQL in the history does not show any auto_increment!
Emilio
uyuniMemberHave a look at http://SyncTables.com . This program syncs exactly as you require.
Emilio
uyuniMemberThat's why I like this tool! User suggestions and error fixes are integrated quickly! :-))
uyuniMemberOK, this is no real problem,
BUT
when I insert a row into this table in the SQLYog-GUI then the timestamp column will be 0000-00-00 00:00:00 because SQLYog inserts
insert into `_ts`(`id`,`ts`) values ( '3','CURRENT_TIMESTAMP')
and that is definitely WRONG!
Emile
uyuniMemberI get the same.
But default CURRENT_TIMESTAMP is too much.
If this is the default value then there is not ON UPDATE !
Emile
uyuniMemberThere is still an error:
When I change a timestamp-column to no default, NOT NULL
and then open the ALTER TABLE-window again, then it shows
default=CURRENT_TIMESTAMP and NULL
Emile
uyuniMemberThank you Peter for your many posts with explanations.
The alternative with an integer is an option but then you may only change the database through PHP and not with e.g. SQLYog!
Emile
uyuniMemberThe same happened again now and a process PLINK was also running!
-
AuthorPosts