Hi i cant use INSERT UPDATE function with this class: MySQLiDB. Im trying write data to mysql and if exists this data then need update. So i use INSERT ... ON D
I have two tables CREATE TABLE person AS ( id INTEGER, sa VARCHAR2 ) CREATE TABLE sampletest AS ( sa VARCHAR2, cell VARCHAR2, pd
Still a mySQL beginner. I have two tables, follows and events, that have these columns: FOLLOWS user | profile EVENTS user | profile | other_stuff I want to
How would one fix this query? IF EXISTS (SELECT * FROM links WHERE age='10') SELECT * FROM links WHERE age = '10' ORDER BY ELSE SELECT * FROM links ORDER BY
id_detail_item id_item id_detail_item_name 1 1 abc 2 1 abcd 3 1 cde 4 3 z
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