-
I have a MySQL table with the layout like below: ---------------------------------------| ID | TITLE | VALUE | PART NO |---------------------------------------| 1 | width (mm) | 12 | ......
-
I'm fairly new to MySQL.Put simply, I want to turn each "meta_key" value into a column of the resulting table.I've got two tables with the following schema:CREATE TABLE `frmt_form_entry` (......
-
I have three tables:feature_valuefeature_productproductMy goal is to get all the feature_value that don't belong to any product. I had an idea consisting in using LEFT JOIN so that I get all ......
-
[context] I need to return rows that describe the current state of all machines in a table that records changes in that machine's state:Raw data:TimestampMachine IDfkDataTypeData Value2021-02-......
-
I have a WordPress website, and in AdSense, I get this error:That is the income I get from that site; it usually goes to 10 Euro/DayThis is mydomain.com/robots.txt:User-agent: *Disallow: /cgi-bin/......
-
Bug description:This error is reported when a web-app container in docker accesses the mysql(version 8) container.Error log:java.sql.SQLNonTransientConnectionException: Could not create ......
-
i want to create trigger to convert (s_start) value from (s_timezone) to (Africa/Cairo) Timezone and stored in new column (s_start_Cairo) for example....
-
I have mysql table which consists of fields (from_time, to_time) having time data type. Here is below my table description and some data from that table.I want to migrate mysql data to clickhouse. ......
-
in my MySQL database I have the following view (originally combining 2 data tables) called MYDATA.TABLE MYDATAusermyDateitems172020-01-011.0222020-01-016.0172020-01-023.2172020-01-......
-
I am doing an online course from coursera where they tolm me to install phpmyadmin.NOW I am a total beginner in this thing so I am not able to do much research upon that and now somehow, after I ......
-
Hey community,I have two tables with three columns and would like to output the name based on the ID's.Clienttablecreated_by_userupdated_by_userdeleted_by_user142Usertableidname1......
-
I have really dumb question...,for what are exactly relationships in databases?If I selecting data from two tables for example:SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDateFROM ......
-
We've come up against a tricky scenario that we probably created ourselves, and we're looking for the best path forward. Here are what I think are the relevant details:We have a rather large MySQL ......
-
I am curious what technique developers use to remove duplicate JSON entries in a JSON Array. For example:[{"name":"philip"},{"name":"steve"},{"name":&......
-
I need to get the value of an id when I insert a row in my database. $query = DB::insert('scenarioeco', array('utilisateur_id', 'nom', 'prixAchatN', 'prixAchatP', 'prixAchatK', 'prixSemence', )) ......