Filter multiple id values using Navicat in MySQL database

I need to filter the data using the most recent expiration date and sales price without repeating id_product, I tried to solve this problem but I can't find the right way to do it. This is the Navicat query and the result is SELECT product_exp_date.idproduct,product_exp_date. exp_date,product_exp_da...

P粉285587590 2023-08-28 17:09:38 0 1 296

Missing newline characters while getting data from PostgreSQL database using PHP

Title: Missing newline characters when getting data from PostgreSQL database using PHP Text: When I use PHP to get data from a PostgreSQL database, I encountered a problem. I use Navicat to view the data in the database, and I can obviously see the newlines (\n) in the data.

P粉696146205 2023-08-06 13:44:42 0 1 289

How to connect to mysql on SSH server with PHP?

Similar to Navicat for Mysql, I need to connect to the database on the SSH server to execute SQL. May I?

Ellen 2021-12-13 15:07:23 0 1 552

How to solve the problem of errors in the cracked version of navicat for mysql downloaded from this website?

The MySQL service cannot be found in the service and cannot be started. What is this error code? The bin folder cannot be found, and there is no .ini file. How to fix this error! I urgently need to use the software MySQL for my graduation project. I always fail to install it myself. Please give me s...

手机用户1583662988 2020-03-08 19:46:35 0 1 779

php mysql_query() problem

phpstudy mysql connection is successful navicat mysql connection phpstudy mysql no problem table is id username gender pass1 bule man 111php in the conn.php file: Connect to phpstudy database: use $link= mysqli_connect(); there is no problem after verification do

移动用户-4895127 2019-12-17 08:01:01 0 4 906

Database cannot be accessed

It was normal to use Navicat to connect to the database two days ago. After opening it today, I can no longer connect. It seems like there is no permission? I have searched many methods and tried them one by one but still failed.

php小白学习中~ 2019-08-26 14:12:42 0 4 1335

phpMyAdmin on Mac cannot connect to the database created by itself

When I connect to navicat, there are 6 databases displayed. Why can’t PHP connect? Moreover, I have changed the secret of the database, but a new root user and root secret will suddenly appear on phpMyAdmin. user

去如烟 2019-04-07 21:44:07 0 6 915

Can the author allow modification of the phpstudy shortcut key ctrl+q?

I remember that it could be modified before. Recently, I don’t know which version started, but it can no longer be modified. The shortcut key ctrl+q of phpstudy is never used for me. But in Navicat, it is used many times. This is Create a new query. So, can it be deleted or allowed to modify this sh...

稻草人 2018-09-14 09:48:27 0 4 1078

Does phpStudy have shortcut key settings?

I downloaded the latest version of navicat and phpStudy. When phpStudy is opened, navicat's new query shortcut key (control+q) cannot be used. After it is closed, it can be used normally. But after searching for a long time, I couldn't find any shortcut key settings.

foreach 2018-08-21 13:42:20 0 2 1315

Navicat for mysql Chinese version cracking problem!

Is PatchNavicat.exe copied to the root directory of the database software and then double-clicked to run it? There is no explanation on the download page, I don’t quite understand it! In addition, the PHP Chinese website is very easy to use and will become my home from now on. I hope I can learn som...

小生我怕怕啊 2018-07-05 19:22:20 0 1 1205

How does Navicat automatically and regularly clear the contents of a field in a table (only clears the content, not the field)?

How does Navicat automatically and regularly clear the contents of a field in a table (only clears the content, not the field)? It is said on the Internet that it can be solved by defining events. Please give me a solution, preferably with code.

。。。。 2018-06-08 15:46:01 1 2 1588

php - mysql supports emoji expressions?

Before the modification, the mysql encoding was all utf8. After modification, the following figure is shown: Then copy the string with the expression below into the record through navicat, and keep talking about grandma.

曾经蜡笔没有小新 2017-07-05 10:01:56 1 1 737

mysql - After Navicat imported the dumped sql file, I found that some data was not displayed on the website.

I use navicat for mac. My steps are to right-click to select the database name in the official website, right-click to select dump sql, and save it to the desktop. Open the local server environment, the link is normal, select the local database name (same database user name, password), right-click a...

我想大声告诉你 2017-07-04 13:43:29 0 4 1520

php - Entering SQL statements to create a table prompts the error Unknown column

The mysql software used: Navicat's complete sql statement is as follows: {code...}

巴扎黑 2017-06-19 09:07:07 0 2 713

javascript - Access denied for user 'root'@'localhost' (using password: YES)

Connect to mysql through the terminal in mac. The connection is successful through the graphical tool Navicat. The connection is successful through nodejs. The failure code to connect to mysql is: {code...} The connection error is Access denied for user 'root'@'localhost' (using password: YES)code: ...

学习ing 2017-06-12 09:20:35 0 3 700

mysql storage json error

Recently, I have been using MySQL's json storage format, and a very strange problem has occurred. INSERT INTO `json` (`notes`) VALUES ('[{"name":1}]'); I use the above statement to insert the json array, and the display of navicat is normal. When I use UPDATE json SET notes =json_array_app...

phpcn_u1582 2017-06-06 09:52:13 0 1 629

There are a lot of backslashes in the data stored in json format in Navicat for mysql. How to remove them?

When using mysql's json operation, it will be interfered by escape characters, and it is normal to read it. I want to save it in the database without a bunch of backslashes.

巴扎黑 2017-06-06 09:52:07 0 3 1144

php - How to export and import large amounts of data in mysql

Now we have a database here that reaches 10G. We want to export it and import it to other servers. Basic exports can no longer be used, such as mysqldump and navicat exports. Are there any other methods or tools that can export the database and then migrate it to other places?

巴扎黑 2017-05-24 11:30:37 0 9 734

mysql - database creation field, what is the difference between default value empty and empty string 110

mysql database, navicat tool. Prerequisite, this field is set to NOT NULL, so the default value cannot be set to Null. But the other two are OK, and they do not affect normal data addition, deletion, modification, and query, and Null values cannot be inserted. Please read it clearly before answeri...

我想大声告诉你 2017-05-18 10:55:59 0 1 840

Problems with navicat and MYSQL5.7

Scenario: An insert statement is run on the query interface of navicat and an error is reported, such as the following statement {code...} Error {code...} Solution method one is ignored, it has been successfully run in MYSQL, and the corresponding content exists. Method two upgrades navicat. Or don’...

怪我咯 2017-05-18 10:46:38 0 1 802