mysql tag

409 questions


1 answers
36 views
0
Viewing Attendance by Student

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...

2 years ago

1 answers
73 views
0
Does MySQL Multi-Column Index Partial Match Work?

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,...

2 years ago

2 answers
36 views
0
How to Receive the Results of a Select Statement Called in a Stored Procedure in MySQL in the Stored Procedure

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...

2 years ago

1 answers
91 views
0
I want to receive the stored procedure OUTPUT Parameter

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...


1 answers
47 views
0
DESCRIPTION METHOD ON SMARTY AND PHP FOR INFORMATION EXTRACTION AT SITE UTILIZING MYSql, PHP AND SMARTY

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 ...

2 years ago

2 answers
65 views
0
How to write SQL Where clauses, and how to evaluate AND/OR

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...

2 years ago

1 answers
56 views
0
Error in PowerShell DataAdapter.Fill

$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...

2 years ago

1 answers
34 views
0
Even if I try mysql-u root with mysql, I get an error, so I want to solve it.

What do you want to solveI can't solve the error in mysql, so I want to solve itProblems/errors encountered#1stERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' ...

2 years ago

1 answers
68 views
0
"No module named 'MySQLdb' error when deploying Django apps to the Google App Engine"

https://github.com/priyankavergadia/Django-Dialogflow-GoogleVisionAPII'm trying to move the Django chat bot of ↑ based on the document to which I linked it.The last deployment to Google app engine is ...


1 answers
38 views
0
DELETE for MySQL is not running.

Creating a bulletin board site.I am connecting to MySQL from PHP using PDO, but the DELETE statement does not run.You can INSERT the database with the add.php file, but The delete.php file is not work...

2 years ago
« - 24 - »

© 2024 OneMinuteCode. All rights reserved.