The 4th column already exists I just need to fill it depending on what query is run. I need to declare it but im having a mental block as everything I try seems to bring back an error saying syntax is wrong
for example - this does not work
insert into testtable (col1,col2,col3,col4)
set col4 =...
I have a few sql queries that select data from a table on 1 database and stores it in a table on a different database. My problem comes when the table on the second database has an additional column which i want to add text dependant on what query is run. i.e. the name of the query.
example...
Im also getting the
Access denied for user 'amjames_webApp'@'localhost' (using password: YES)
im using C# but know im getting my username and password right
MySqlConnection oConn =
new MySqlConnection("Database=amjames_webApp;Data Source=localhost;User...
Im trying to save form data to mysql database. Do I use an sql connection or an odbc connection as I have searched the net and I have seen both used. (im using c# just incase you need to know)
Also when I used the sql connection I had the following error
Server Error in '/web app' Application...
I logged a ticket to support, after this I have been able to view my .aspx web pages. However I am now receiving
Service Temporarily Unavailable
The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.
Additionally, a...