I am trying to load data into a database table (MYSQL 8.0.28) in my Windows 11 pc through load data local infile command. I have gone through the syntax (https:
hello this is my first post on stackoverflow i am at beginner level at php, mysql and work on a php log in page connected to a mysql database which i did try to
I have the following table table x labref name repeat_status 111 L 1 111 L 1 111 K 1 111 K 1 111
How do I delete all rows that have a field called A that are blank. Lets say I have a table that looks like the following. |ID |A |B |C |1 |Data|Data|D
In a MySQL migration script, I'm trying to drop all the foreign keys of a table without knowing the name of the constraints themselves. I need this because I ca
I'm trying to match two choices. "One or the other" SELECT * FROM course WHERE category='blue' || category='red' ORDER BY id DESC LIMIT 5 That is my first thou
I'm currently struggling with a query and need some help with it. I've got two tables: messages { ts_send, message, conversations_id } conversations {
I'm trying to match two choices. "One or the other" SELECT * FROM course WHERE category='blue' || category='red' ORDER BY id DESC LIMIT 5 That is my first thou
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