Forum Replies Created
-
AuthorPosts
-
uyuni
MemberI found the answer myself.
The difference is “bulk insert”. bulk insert is MUCH faster!
uyuni
MemberThen please set a high priority for this. I've been missing this for years.
uyuni
MemberThen please set a high prioritity. It can't be very difficult.
uyuni
MemberThanks!
uyuni
MemberWell it is not real outside the scope. Other programs do this, like for example total commander for its FTP connections.
uyuni
MemberSQLYog 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
uyuni
MemberI mean obfuscation.
It's clear that a professional can crack this. But it's not as simple as just opening a file!
Emilio
uyuni
MemberI 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
uyuni
MemberHave a look at http://SyncTables.com . This program syncs exactly as you require.
Emilio
uyuni
MemberThat's why I like this tool! User suggestions and error fixes are integrated quickly! :-))
uyuni
MemberOK, 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
uyuni
MemberI get the same.
But default CURRENT_TIMESTAMP is too much.
If this is the default value then there is not ON UPDATE !
Emile
uyuni
MemberThere 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
uyuni
MemberThank 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
uyuni
MemberThe same happened again now and a process PLINK was also running!
-
AuthorPosts