C# SQL database access – Phpmyadmin
I need your help. I'm trying to get into servers on my own. I was searching yesterday about it a bit, I saw one code here and also tried one from a YT video. Not exactly sure what I'm doing.…
sql prepared statment don't work with WHERE <column> IN clause – Phpmyadmin
So I have this sql preparted statment: SELECT carName, modelName FROM cars INNER JOIN model ON cars.idCar = model.idCar WHERE carName IN (?)` $input = " 'toyota','honda' " I am trying to put this into the sql statment, but it…
PHP MySQL imbricate SELECT statements return null – Phpmyadmin
I tried to execute the query, but the result was null, I executed the same query in PhpMyAdmin and returns the result. The problem is when the query contains SELECT inside another SELECT statement (imbricate), so when the query contains…
Create a timestamp from variables in SQL and format string to time – Phpmyadmin
I have a table containing 100's of entries - I have since after import, updated the columns to include a timestamp. The data is given to me by XMl and imported into DB I have 3 columns in the data.…
add 2 words to query call insertIntoWPPOSTMETA – Phpmyadmin
I am using the below query for a single word in phpmyadmin: call insertIntoWPPOSTMETA('episode 2'); But when I try to use it like this, it does not work: call insertIntoWPPOSTMETA('episode 2','episode 2'); How can I use 2 words or more…
query returns nothing php – Phpmyadmin
I attempt to get the result of a very simple query with the function query but nothing appears. If I execute the query in PHPMyAdmin, with the same data, I have a result. There is my code : $sql =…
Update column value that has one or more same values of other column – Phpmyadmin
I have this statement: UPDATE `tblAllocatedLeads` SET tblAllocatedLeads.fldAllocatedStatus = CASE WHEN tblAllocatedLeads.fldAllocatedStatus = 'Allocated' AND (SELECT COUNT(*) FROM (SELECT * FROM `tblAllocatedLeads`) AS tblallocate WHERE AND tblallocate.fldAllocatedLeadId = tblAllocatedLeads.fldAllocatedLeadId) > 1 THEN 'Outstanding' END What I wanted is that update…
How to export a CSV file from the MySQL command line – Phpmyadmin
I have a MySQL database containing a single table which is used as a temporary storage point for manipulating and querying data sets and is periodically deleted and replaced with new data. What I would like to be able to…
How to optimize the following SELECT query – CentOS
We have the following table id # primary key device_id_fk auth # there's an index on it old_auth # there's an index on it And the following query. $select_user = $this->db->prepare(" SELECT device_id_fk FROM wtb_device_auths AS dv WHERE (dv.auth= :auth…
How do I get related data in PostgreSQL table? – Debian
In my PostgreSQL database I have table with such structure: | organization_id | organization_name | parent_organization_id | tree_organization_id | |-----------------|-------------------|------------------------|----------------------| | 1 | Alphabet | | | | 2 | Google | 1 | 12 | | 3 | Google…