625 questions
I installed MySQL 5.7.23 and set the character code in /etc/my.cnf with the following settings: [mysqld]character-set-server=utf8mb4[client]default-character-set=utf8mb4The environment is Virtualbox (...
What do you want to doI want to get attendance per student on MySQLQuery ConditionsAttendance, absenteeism, lateness, and absenteeism (one absence out of three) are obtained in the SELECT statement.If...
CREATE TABLE `users`( `id`CHAR(36) NOT NULL, `tenant_id`CHAR(36) NOT NULL, `email_address`VARCHAR(254) NOT NULL, PRIMARY KEY(`id`), INDEX`email_idx`(`email_address`ASC))In the case of the above table,...
Call other stored procedures (B) from stored procedures (A).(B)We would like to receive the result of the select statement we called in (A).Is this possible in the first place?Please tell me how to wr...
What do you want to doI want Rails to aggregate values by group (SUM) and each group's aggregate results to be defined as variables in the controller*After that, we plan to add the defined values to J...
I am developing an API with Visual Studio 2013 c#.I'm going to use StoredProcedure to select the data in the table.I don't know how to get the retrieved data with C# code.I am using ObjectParameter, b...
Thank you for your help.Please let me know.We create sites using Mysql, php, and smarty.On the page (smarty) to be displayed for each Proudct_id, I would like to use the table tbl_product_check below ...
I wrote sql to meet the following conditions, but it doesn't work.What's wrong?·Created (DATETIME type) is 2016-02 or 2016-01 (in 2016-01, we have embedded $_GET variable)·The value of bill is 0 or mo...
Suppose you are throwing a complicated select statement in postgres SQL and you are not getting that performance.Explaining the select statement explains how postgres performs select, but if you are n...
$ConnStr=Server=$Server; port=$Port;uid=$User;pwd=$Pass;database=$Database;Pooling=$Pooling; charset=$CharSet$Conn=New-Object MySql.Data.MySqlClient.MySqlConnection($ConnStr)$Conn.Open$Sql=SELECT* FRO...
| « | - 38 - | » |
© 2024 OneMinuteCode. All rights reserved.