Recent questions tagged mysql

0 votes

Q: MySqlDataReader.Read() "Timeout" when read from a very big table (over 100 million records)

I have a big table which contains about 100 million records in MySQL. I want to read all the ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Aug 1, 2022 in Education by JackTerrance

0 votes

Q: mysql query fails?

Why does this mysql query fail? UPDATE accounts SET motivation = IF(motivation+100...

asked Jul 30, 2022 in Education by JackTerrance

0 votes

Q: What does max_connections really mean?

I'm trying to set the ideal performance setup for MySQL and resources needed on a shared hosting. My ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Jul 30, 2022 in Education by JackTerrance

0 votes

Q: How to set in table for all records with same name the same id number of column

How to set same number 'priority' with one query for Mercedes. +--------------------- ... questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Jul 20, 2022 in Education by JackTerrance

0 votes

Q: Effects of changing datatype of a column from varchar to text

The text data I have for a column in database in an enterprise application (uses hibernate) is huge and ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Jul 3, 2022 in Education by JackTerrance

0 votes

Q: Effects of changing datatype of a column from varchar to text

The text data I have for a column in database in an enterprise application (uses hibernate) is huge and ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Jun 19, 2022 in Education by JackTerrance

0 votes

Q: Effects of changing datatype of a column from varchar to text

The text data I have for a column in database in an enterprise application (uses hibernate) is huge and ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked Jun 16, 2022 in Education by JackTerrance

0 votes

Q: Codeigniter Updating database table

I already can update my data from database but the problem is i just want to update one data, but when I enter the ... all of data in the database table like this this is View:...

asked Jun 2, 2022 in Education by JackTerrance

0 votes

Q: MySQL Remove first two characters of all fields

I have some data that looks like this: C:10 R:200 N/A E:3 N/A N:77 I'm trying to ... questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...

asked May 7, 2022 in Education by JackTerrance

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 May 1, 2022 in Education by JackTerrance