Hello, I have created a mySQL database (flightva_reporting) which is stored on the same domain server than the website I want to use a table  created with wpdatatables.

I can use SQL as datasource and query tables within that database. In order to do that, I refer to the table by specifying database.table. I use for example:

SELECT * FROM flightva_reporting.cash_balance

That works to display the table. However, when try to edit the records in this table or add new records, the plugin seems to try to be saving the data to the wrong database. It tells me someting like:

"Cant save to flightva_bea.flightva_reporting.cash_balance.fieldname'

with flightva_bea ... being the wp-standard database on my domain.

So is there a way to edit data in another mySQL database stored on the same server?

Many thanks,

Dirk

Aleksandar, 

Thanks for the reply. I did explore the "separate DB connection" tab, but I read it was discouraged for performance reasons ... if at all possible.

I successfully used it to link to a database on separate domain server, so that's working with your method.

However, can you confirm that this is also the necessary way to go for a a database, stored on the the same domain and registered to the website? I was just wondering, as in that case, the only useful mySQL link supported wihtou a separate connection would be to the WP-databases containing users and posts ... ;-(

Many thanks,

Dirk

PS: Separate question on CRUD ... in a separate ticket.

Alexander, on this one ... maybe I'm making it too compicated. But in my view the custom MySQL tables that contain the data I want to display, sort, edit, delete with wpdatatables could be in three different locations:

1. in distinct tables, but within the same database as the standard and plug-in maintained Wordpress database tables (those typically prefixed by wp_ ...)
2. in a separate database, which is, however stored on the same domain server as the WP post,page,... (etc) tables and accessible with similar user privileges as the wp_ tables 
3. on another ("remote") server (e.g. for data shared with other applications/domains). 

I understand that wpdatatables MySQL queries work perfectly for #1, without much fuzz and assisted by a specific wizard for query building (thanks for that!!) 

I also understand that for databases on other servers (#3) I would need to use a separate connection as you suggested in your initial reply. (and I did that before .... let's say there is a country database or client database or some other shared data). On a side note: I haven't managed to combine tables in both locations in a foreign key relationship across databases. Is that actually possible?

Storing my application custom data in a separate database, but on the same server (i.e. #2), is actually my preferred solution. And that's what my initial question was about: is it possible to do so without a separate DB connection, just by referencing the tables in the form of: database.table 

SELECT * FROM mydatabase.table 1 WHERE 1 

Many thanks,

Dirk

Thanks,