sql

The essence of the problem: In Qt, a file is parsed that contains Emoji characters. After that, the data is written to a MySQ ... uestion: How, working with Qt, as with a MySQL client, to achieve full support for Emoji characters, when writing to a table?

There is an sql query select oi.order_item_name , oi.order_item_id, oim.meta_key ,oim.meta_value from idlf.wp_woocomm ... of the request is as follows How do I make _product_id, _qty, and _line_total appear on the same line for the same product?

Tell me why SELECT CAST(12 AS CHAR) +'12';//24 SELECT CAST(12 AS CHAR) +cast('12' AS CHAR)";//24 How do I convert to a string??

Hello. There is a MySQL query: $mysqli->query("INSERT INTO `test_table` (`name`) VALUES ('test')"); Structure of the test ... is, the ID will be set automatically for this request. How do I know it? That is, I need to find out the Id that was set.

Created the database via SQLiteStudio (3.2.1). CREATE TABLE ranobes ( ranobe_id INTEGER PRIMARY KEY AUTOINCREMENT, ... ALUES, id, and manually registered it, now the record was added, but without taking into account AUTOINCREMENT. What's wrong?

Created an empty project in intelijiIdea "Hello, Word", decided to connect to the server via the side panel DataBase - > + ... stackoverflow, but everything is unchanged. Workbench version 8.0 MySQL version 8.0 IDEA version 2019.1.3 Java version 12.02

When performing CP, sometimes this error appears: SQL> CALL MY_PROC(); CALL MY_PROC() * ERROR at line 1: ORA-00936: о ... U sometimes works without errors, and sometimes it gives this error. How do I display additional information about the error?

How do I make a query that returns a conditional chessboard image? The column headings must contain the Latin letters a,b,c, ... ution is not correct, but I have not yet come up with another one. How can I display a chessboard and fill it with 1s and 0s?

I have a table: id order timeStamp 0 1 0 1 1 23 2 1 98 3 2 2 4 2 40 5 2 65 I nee ... 98 5 2 65 I suspect that here it is necessary to use the MAX function, but I do not understand how. Please help me

I make a request to get an int value.Is it possible to assign the result of this query to a variable? declare @enddate int; S ... o.Date_Dim.ID FROM dbo.Date_Dim WHERE dbo.Date_Dim.DateOper = '2013-06-27'; This design does not work.Is this even possible?

The Firebird DBMS has an exclusive mode (shutdown), in which only the administrator can connect to the database, and no more ... rnal stored procedure - if the database is not in exclusive mode to throw an exception. Is it possible, and if Yes, then how?

There are two tables Create table [employees] (Persona_id, Name, Dates_birthday, Job_position, Experience, Location_Id) Cr ... ] e where e.Dates_Birthday = ( Select Dates_Birthday = min (Dates_Birthday) from employees ) Help me finish the query!!!

Please explain how to add an entry in SQL БД to two tables with a one-to-one relationship? The obvious option is to add INSE ... nother. But it looks, to put it mildly, not very optimal - as many as three requests. And if more related tables are added?..

When you log in to Microsoft SQL Management Studio, you must enter the server name. What to enter there? I tried local, but there is no connection. Mistake: network path not found.

The question arose, what is the easiest way to import a PDF to the columnBLOB? I thought to implement this logic: import BLO ... ze, dest_offset => l_dest_offset, src_offset => l_src_offset); DBMS_LOB.fileclose(l_bfile); COMMIT; END;

There is a code that returns an error message if the value is invalid. I would like to return an error message if the given ... ue>7200000)) THEN ... Free translation How can you tell if a value is not numeric in Oracle? from member @Kyle Williamson

I wish you good health, colleagues! Tell me, is it possible (and how it can be done) to add (concatenate) the values of cell ... e request, I want to get two strings of the type (for example): zz | aaaaa bbbbb xx | ccccc ddddd Thank you for the hints!

There is a table: CREATE TABLE table ( start_range varcahar2(10), end_range varcahar2(10), val_range NUMBER(10) ); At ... erent table table2 with rows in the range between start_range and end_range? To make it look like this: (a1, a2, a3, a4, a5).

There is such a table: PeopleID | Name | Father | Mother ----------------------------------- 1 | Vasia | null | ... r) AS value_occurrence FROM FAMILY F1 GROUP BY F1.Father HAVING COUNT(F1.Father) > 1 ORDER BY value_occurrence DESC;

Good afternoon, everyone.Tell me how to implement the main news parser of the news portal.So that all the main news of this s ... (array[2]) textp=array[3] cursor.execute(sql,(str(title),str(text),str(date),str(textp))) print ("Connect successful!")