How to import SQL files using command line in MySQL?

I have a .sql file containing exports from phpMyAdmin. I want to import it into a different server using the c...

From [MySQLdiscussion group] 2023-08-23 10:46:22 0  2  520

What is NullPointerException and how to fix it?

What are NullPointerExceptions (java.lang.NullPointerException) and what cause them? What methods/tools can be...

From [MySQLdiscussion group] 2023-08-23 10:22:08 0  2  625

Solve the GPG key problem when installing mysql-community-server

The following error occurred while installing mysql-community-server: Command: sudoyuminstallmysql-community-s...

From [MySQLdiscussion group] 2023-08-22 23:03:45 0  1  540

How to load date data using LOAD DATA in MySQL

The default date format for a date column in MySQL is YYYY-MM-DDHH:MM:SS. The data file I'm trying to load has...

From [MySQLdiscussion group] 2023-08-22 22:12:49 0  1  529

Driver not found - "An exception occurred in driver: could not find driver" in Symfony 5

I'm currently facing this issue. I'm a real newbie when it comes to Symfony. Problem: When I create a new data...

From [MySQLdiscussion group] 2023-08-22 20:59:57 0  2  496

Mysql connection cannot be established because the target machine actively refuses the connection

I know a lot of people have asked this question, but most of these people have forgotten their passwords that ...

From [MySQLdiscussion group] 2023-08-22 19:04:28 0  2  686

How to solve the problem of "ORA-00922: missing or invalid option" error?

I entered the following SQL command in Oracle, but it reported the error "ORA-00922: Option missing or in...

From [MySQLdiscussion group] 2023-08-22 18:45:24 0  2  870

MySQL implementation method of multi-column ascending sort

I'm trying to run this query in ascending order: SELECTtitle,project_indexFROMprojectdetailWHEREproject_indexB...

From [MySQLdiscussion group] 2023-08-22 18:35:13 0  1  485

How to design a product table for multiple products where each product has many parameters

I don't have much experience in table design. My goal is to create one or more product tables that meet the fo...

From [MySQLdiscussion group] 2023-08-22 17:45:42 0  2  661

How to undo an executed mysql UPDATE command

I was trying to make an update to my MySQL server and accidentally forgot to add an extra WHERE clause that wa...

From [MySQLdiscussion group] 2023-08-22 17:36:22 0  2  590

Nesting a list within IN clause in Python MySQL

I know how to map a list to a string: foostring=",".join(map(str,list_of_ids)) I know I can put that...

From [MySQLdiscussion group] 2023-08-22 17:04:59 0  2  504

SQL query: What is the default sorting method?

What is the default sort order for queries when ORDERBY is not used?

From [MySQLdiscussion group] 2023-08-22 16:55:09 0  1  600

Resolving handshake inactivity timeout error in Node.js's MYSQL module

I'm using node-mysql and most of the queries work fine. But some queries don't work. I tried every version of ...

From [MySQLdiscussion group] 2023-08-22 16:34:16 0  2  534

Problem with not being able to set columns to auto-increment exists in MySql

I have a table called "Bestelling" with 4 columns: "Id" (primary key), "KlantId"...

From [MySQLdiscussion group] 2023-08-22 16:23:53 0  2  612

How to pass parameters to MySQL query callback function in Node.js

I'm trying to figure out the correct way to pass custom data to a query call so it's available in the callback...

From [MySQLdiscussion group] 2023-08-22 15:44:32 0  2  699