Is it better to open and close a new MySQL connection every time a query is made or to keep the connection open and run multiple queries in a single MySQL sessi
Is it better to open and close a new MySQL connection every time a query is made or to keep the connection open and run multiple queries in a single MySQL sessi
I have user table (e.g. UserMst) is MySQL like UserID FirstName LastName FullName (expression column) ------ --------- -------- -----------------------
I have user table (e.g. UserMst) is MySQL like UserID FirstName LastName FullName (expression column) ------ --------- -------- -----------------------
Hi I have the following query, however it still gives me results that are specified not to give me. what is wrong with this not in ? select taxonomic_units.tsn
I have .txt file that is about 20MB in size. Each Line looks like the following. *,00000000,Binary Zero,Description *,00000001,Binary One,Description *,000000
I'm trying to access a position of a associative array which is inside of another array. Here is my array: Array ( [order_data] => stdClass Object
After changing the data type of a MySql column in order to store Twilio call ids (34 char strings), I try to manually change the data in that column with: upda
Query the name of any student in STUDENTS who scored higher than 75 marks. Order your output by the last three characters of each name. If two or more students
I'm trying to install Joomla 2.5.14 and getting Installation notice INSTL_ERROR_INITIALISE_SCHEMA. Do anyone know the reason for this? Does it required CREATE R
I try to perform this query with Zend DB: $this->db->query(" CREATE EVENT turn_tonormal ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVA
I have multiple csv files generated everyday with same name and they should be imported to Mysql database . I can import a single file to table where I have def
So I need help in trying to make a database field where it's default 7 and each day minuses 1 until its 0 then the day count starts again from 7. Is it possible
I am new to aws. I have a mysql rds instance and I just created 2 read replicas. My application is written in Java, and what I have done up until now is using
I have two database tables. First table: | ID | Sub-Name | Marks | 01 | french | 50 | 01 | russian | 50 | 02 | french | 30 | 02 | russian
I try to create a table using sequelize it goes fine with no error but instead of creating a table is show this message as a result Executing (default): SELECT
enter image description here I am trying to map some entities to tables in MySQL database using Spring Boot JPA. I have a problem with one of the tables because
I'm using MySQL 5.7.12 and this is my query. select objectid, (JSON_EXTRACT(fullobject, '$.mail')) as mail from openidm.managedobjects where objecttypes_id=5 a
I try to create a table using sequelize it goes fine with no error but instead of creating a table is show this message as a result Executing (default): SELECT
What I currently have is: UPDATE card, records IF(records.date_returned == null) THEN SET card.last_seen = records.date_loaned ELSE SET card.last_seen = records