522 reputation
213
bio website noneatthemoment.de
location Germany
age 33
visits member for 2 years, 7 months
seen 9 hours ago

9h
reviewed No Action Needed Replication MariaDB problem
20h
comment Select products and include all cities it belong to
Don't store comma separated values in one column. Read about normalization.
20h
reviewed No Action Needed Select products and include all cities it belong to
2d
awarded  Custodian
2d
reviewed No Action Needed Achievement Table
Oct
27
revised Using mysql cursor data to do something for each row
improved english - cleaning up apostrophe mess
Oct
27
awarded  Informed
Oct
27
comment Using mysql cursor data to do something for each row
Are you sure that this select text_message into subject_text from incoming_sms... actually yields a row? Also make sure, that you don't use variable names which can be confused with column names (by adding a prefix v_ or whatever).
Oct
27
suggested suggested edit on Using mysql cursor data to do something for each row
Oct
23
comment How to change table with innodb/myisam engine to federated
@Michael-sqlbot Interesting, thanks for your comment.
Oct
23
answered How to group by on two fields and count
Oct
23
revised How to change table with innodb/myisam engine to federated
improved english
Oct
23
comment How to change table with innodb/myisam engine to federated
Don't think so, haven't investigated it much. For writing it may not be so serious.
Oct
23
comment How to change table with innodb/myisam engine to federated
I haven't used the federated engine much, cause from my experience it's painfully slow. But maybe just for my use case.
Oct
23
comment How to change table with innodb/myisam engine to federated
Oh, yes, that's actually a fancy trick. But you have to create the table the other way round than I described in my answer. The federated table on the localhost, and the real table on the remote host, where you want to write data to. Nice.
Oct
23
suggested suggested edit on How to change table with innodb/myisam engine to federated
Oct
23
comment How to change table with innodb/myisam engine to federated
@GeoVIP No, you can't. The concept behind federated is still not clear, isn't it? The federated engine is like a link to another table. You select something from the local federated table, the data comes from the remote whatever-engine-table. You can't use triggers to write data to a remote server.
Oct
23
answered How to change table with innodb/myisam engine to federated
Oct
23
comment How to change table with innodb/myisam engine to federated
Do you want to do this for all tables in a database? If yes, what you actually want is called replication.
Oct
23
comment How to change table with innodb/myisam engine to federated
No offense in asking this, but do you actually know what the federated engine is? I recommend you read the MySQL manual about it. You don't convert a table to federated, you just create it.