Recent questions tagged mysql

0 votes
1 answer

What are Best Practices for preventing SQL injection in node-mysql?

Oct 21, 2024 in Web Development by Nidhi
 • 16,260 points • 938 views
0 votes
0 answers

I have only been using Python for a week. I tried to install django-mssql, but when I used import sqlserver_ado.dbapi to try to import the library, I got this error message:

Sep 13, 2023 in Python by Satyawrat
 • 460 points • 1,116 views
0 votes
1 answer

Java present on a system but not installed. Is this a cybersecurity issue?

Apr 19, 2023 in Cyber Security & Ethical Hacking by anish
 • 400 points • 960 views
0 votes
1 answer

How to pass a JSON-formatted string from Excel VBA as argument to a MySQL Store Procedure

Apr 2, 2023 in Others by narikkadan
 • 86,360 points • 1,651 views
0 votes
1 answer

How to connect ms excel-2007 with mysql.

Dec 22, 2022 in Others by Kithuzzz
 • 38,000 points • 1,019 views
0 votes
0 answers

Convert oracle UDF function with to_number and value_error expection in it to AWS RDS maria db

Dec 14, 2022 in AWS by Tejashwini
 • 5,380 points • 981 views
0 votes
1 answer

Find max and second max salary for a employee table MySQL

Nov 4, 2022 in Others by gaurav
 • 23,580 points • 5,324 views
0 votes
1 answer

Convert Excel's "41014" date to actual date in PHP or JavaScript

Oct 24, 2022 in Others by Kithuzzz
 • 38,000 points • 5,874 views
0 votes
1 answer

Online MYSQL editor as an Excel-like spreadsheet

Oct 7, 2022 in Others by Kithuzzz
 • 38,000 points • 1,696 views
0 votes
1 answer

Convert Excel sheet having shivaji fonts to csv having google unicode utf-8 encoding

Sep 24, 2022 in Others by Kithuzzz
 • 38,000 points • 2,302 views
0 votes
1 answer

Online Excel Web-based Platform

Sep 23, 2022 in Others by Kithuzzz
 • 38,000 points • 1,202 views
0 votes
1 answer

ERROR 1064 (42000): You have an error in your SQL syntax;

Sep 19, 2022 in Database by Kithuzzz
 • 38,000 points • 10,738 views
0 votes
1 answer

Using ORDER BY and GROUP BY together

Sep 19, 2022 in Database by Kithuzzz
 • 38,000 points • 1,187 views
0 votes
1 answer

How to retrieve the current version of a MySQL database management system (DBMS)?

Sep 19, 2022 in Database by Kithuzzz
 • 38,000 points • 1,284 views
0 votes
1 answer

java.sql.SQLException: Column count doesn't match value count at row 1

Sep 19, 2022 in Database by Kithuzzz
 • 38,000 points • 3,359 views
0 votes
1 answer

Multiple SQL Joins error in W3Schools Tryit Editor

Sep 17, 2022 in Database by Kithuzzz
 • 38,000 points • 3,486 views
0 votes
1 answer

SQL - Update multiple records in one query

Sep 16, 2022 in Database by Kithuzzz
 • 38,000 points • 4,997 views
0 votes
1 answer

ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it

Sep 12, 2022 in Database by Kithuzzz
 • 38,000 points • 16,041 views
0 votes
1 answer

How to select from multiple tables without a JOIN ?

Sep 11, 2022 in Database by Kithuzzz
 • 38,000 points • 7,652 views
0 votes
1 answer

What's the difference between VARCHAR and CHAR?

Sep 11, 2022 in Database by Kithuzzz
 • 38,000 points • 1,402 views
0 votes
1 answer

PL/MySQL does it exist?

Sep 10, 2022 in Database by Kithuzzz
 • 38,000 points • 2,300 views
0 votes
1 answer

SQL keys, MUL vs PRI vs UNI

Sep 8, 2022 in Database by Kithuzzz
 • 38,000 points • 2,533 views
0 votes
1 answer

Add Auto-Increment ID to existing table?

Sep 8, 2022 in Database by Kithuzzz
 • 38,000 points • 1,985 views
0 votes
1 answer

How do I run an sql query in php?

Sep 8, 2022 in Database by Kithuzzz
 • 38,000 points • 1,398 views
0 votes
0 answers

How to concat two columns into one with the existing column name in mysql?

Sep 6, 2022 in Database by Kithuzzz
 • 38,000 points • 1,169 views
0 votes
0 answers

MySQL error code: 1175 during UPDATE in MySQL Workbench

Sep 5, 2022 in Database by Kithuzzz
 • 38,000 points • 2,124 views
0 votes
0 answers

MySQL Multiple Joins in one query?

Sep 4, 2022 in Database by narikkadan
 • 86,360 points • 963 views
0 votes
0 answers

Add Foreign Key to existing table

Sep 3, 2022 in Database by Kithuzzz
 • 38,000 points • 1,017 views
0 votes
0 answers

What is wrong with my SQL here? #1089 - Incorrect prefix key

Sep 3, 2022 in Database by Kithuzzz
 • 38,000 points • 1,779 views
0 votes
0 answers

java.sql.SQLException Parameter index out of range (1 > number of parameters, which is 0)

Sep 3, 2022 in Database by Kithuzzz
 • 38,000 points • 3,855 views
0 votes
0 answers

PDOException SQLSTATE[HY000] [2002] No such file or directory

Sep 3, 2022 in Database by Kithuzzz
 • 38,000 points • 2,481 views
0 votes
0 answers

SQLSTATE[HY000] [1045] Access denied for user 'username'@'localhost' using CakePHP

Aug 30, 2022 in Database by Kithuzzz
 • 38,000 points • 3,995 views
0 votes
0 answers

SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102

Aug 29, 2022 in Database by Kithuzzz
 • 38,000 points • 2,647 views
0 votes
0 answers

Display data from SQL database into php/ html table.

Aug 27, 2022 in Database by Kithuzzz
 • 38,000 points • 1,480 views
0 votes
0 answers

Find max and second max salary for a employee table MySQL

Aug 26, 2022 in Database by Kithuzzz
 • 38,000 points • 1,634 views
0 votes
0 answers

SQL query for distinct professors and courses

Aug 26, 2022 in Database by Kithuzzz
 • 38,000 points • 25,805 views
0 votes
0 answers

Getting java.sql.SQLException: Operation not allowed after ResultSet closed

Aug 22, 2022 in Database by Kithuzzz
 • 38,000 points • 2,707 views
0 votes
0 answers

java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/dbname [duplicate]

Aug 21, 2022 in Database by Kithuzzz
 • 38,000 points • 2,916 views
0 votes
0 answers

How to import large sql file in phpmyadmin

Aug 21, 2022 in Database by Kithuzzz
 • 38,000 points • 1,300 views
0 votes
0 answers

Find the number of columns in a table

Aug 20, 2022 in Database by Kithuzzz
 • 38,000 points • 792 views
0 votes
0 answers

How to convert date into timestamp in SQL query?

Aug 19, 2022 in Database by Kithuzzz
 • 38,000 points • 2,307 views
0 votes
0 answers

SQL joins as venn diagram

Aug 19, 2022 in Database by Kithuzzz
 • 38,000 points • 13,071 views
0 votes
0 answers

Not all parameters were used in the SQL statement (Python, MySQL)

Aug 15, 2022 in Database by Kithuzzz
 • 38,000 points • 4,317 views
0 votes
0 answers

MySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near

Aug 14, 2022 in Database by Kithuzzz
 • 38,000 points • 8,125 views
0 votes
0 answers

Drop multiple tables in one shot in MySQL

Aug 13, 2022 in Database by Kithuzzz
 • 38,000 points • 3,790 views
0 votes
0 answers

How to export and import a .sql file from command line with options?

Aug 13, 2022 in Database by Kithuzzz
 • 38,000 points • 973 views
0 votes
0 answers

What's the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN?

Aug 13, 2022 in Database by Kithuzzz
 • 38,000 points • 924 views
0 votes
0 answers

How to run SQL script in MySQL?

Aug 11, 2022 in Database by Kithuzzz
 • 38,000 points • 1,025 views
0 votes
0 answers

How do I list all the columns in a table?

Aug 9, 2022 in Database by Kithuzzz
 • 38,000 points • 1,010 views
0 votes
0 answers

php records navigation

Aug 8, 2022 in PHP by Kithuzzz
 • 38,000 points • 977 views
Page:

Most popular tags

"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.