Dienstag, 19. Juni 2012

Mysql how to copy/import a table from another Database

Mysql:

Kopieren/Importieren einer Tabelle aus einer DB in eine andere...

1. Drop table in target db if it already exists
 drop table 'targetdb'.'tablename';

2. Create the table
create table 'targetdb'.'tablename' select * from 'sourcedb'.'tablename';

Howto use multiple line html string in append or something like that:

Howto use multiple line html string in append or something like that:

1. define variable:
var tablefooter = '<tfoot><tr>'
tablefooter += '<td><input name="tfoot input" value="Suche" /></td>'
tablefooter += '<td><input name="tfoot input" value="Suche" /></td>'
tablefooter += '<td><input name="tfoot input" value="Suche" /></td>'
tablefooter +=' </tr></tfoot>';


2. use variable
oTable.append(tablefooter);