Recent questions tagged mysql

0 votes

Q: I wish to delete from all the SQL tables that are included in the joins

I get an error stating that there is incorrect syntax near the key word INNER. I wish to delete ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Apr 26, 2022 in Education by JackTerrance

0 votes

Q: mysql update values that end with with another ending

If I have a table with results like this: 0001400OL 0578400OL 354085OL 48679OL and if I wanted to replace ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Apr 26, 2022 in Education by JackTerrance

0 votes

Q: How to generate a prepared MySQL query from a variable array?

My goal is to merge tables from different schema into one single schema so I would like to execute this ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Apr 23, 2022 in Education by JackTerrance

0 votes

Q: Installation of MySQL for Visual Studio 1.2.8 failed

I'm trying to install MySQL for Visual Studio 1.2.8 and Connector/NET 8.0.13 via MySQL Installer ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Apr 21, 2022 in Education by JackTerrance

0 votes

Q: MYSQL update Trigger check changes in all columns and insert values to other table

I've come to this code, but from this i have to manually insert all columns and check it by each ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Apr 16, 2022 in Education by JackTerrance

0 votes

Q: Error Code: 1241. Operand should contain 1 column(s) On Updates and Trigger

I Have a soccer database, and I have a trigger (notas) that is calculating a player rating after ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Apr 2, 2022 in Education by JackTerrance

0 votes

Q: MySQL: "lock wait timeout exceeded"

I am trying to delete several rows from a MySQL 5.0.45 database: delete from bundle_inclusions; The client ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Mar 26, 2022 in Education by JackTerrance

0 votes

Q: Best way to archive live MySQL database

We have a live MySQL database that is 99% INSERTs, around 100 per second. We want to archive the ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Mar 24, 2022 in Education by JackTerrance

0 votes

Q: How to enable inno-db support on MySql 5 installed above MySql 4?

How to enable inno-db support on installed instance of MySql? I have installed mysql-5.0.67-win32. ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Mar 23, 2022 in Education by JackTerrance

0 votes

Q: trying to get the single exp payment

I have a query like this SELECT member_Id , PERIOD_DIFF( DATE_FORMAT(now(),'%Y%m'), DATE_FORMAT( ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Mar 4, 2022 in Education by JackTerrance