Entry containing gaminginfo

Complete Game Information：

• 1
  、mysql how to use json functions to manipulate data
• 2、Boot on and enter bios, but not desktop, and no hard disk can be detected
• 3 、How to view motherboard model from bios
• 4
  、How to solve the problem when MSI B650 motherboard turns on memory XMP or EXPO starts slowly?

mysql How to use json functions to manipulate data

1. UPDATE users SET info = JSON_REMOVE (info,$. city) WHERE id = 1; Construct and format JSONJSON_ARRAY (): Create a JSON array.

2. Insert/create JSON data JSON_OBJECT () converts key-value pairs into JSON objects, and the syntax is JSON_OBJECT (key, value,...).

3. JSON_ARRAYAGG function: Used to merge multiple rows of query results into a JSON array to simplify summary operations. The basic syntax is as follows: Example: Integrate all the province names in the com_province table into a JSON array. This operation produces a JSON array containing the names of 31 provinces. JSON_OBJECT function: Build a JSON object containing the specified key-value pair to facilitate the generation of specific structured data.

Boot on and enter bios, but not desktop, and no hard disk can be detected

When booting, the BIOS does not enter the desktop and the hard disk cannot be detected. This may be caused by BIOS settings, hardware connections or hard disk failure. You can use the following steps to resolve the problem: Confirm the BIOS option settings and update the BIOS version: Visit the motherboard's official website to download the latest BIOS files (for example, Asus motherboards can use EZ Flash 3 tool), follow the prompts to complete the update to avoid compatibility issues caused by the old version.

Check the hard drive cable for loose or damaged. Ensure that all SATA cables and power cords are securely connected. Try replacing the SATA port or replacing the SATA cable. BIOS Settings Saving Problem: Make sure that after making changes in the BIOS, the settings are saved correctly (usually press the F10 key to save and exit). If the BIOS battery is low or has a battery failure, settings may not be saved. Try replacing the BIOS battery.

The hard disk cannot be detected when booting up because the interface of the hard disk in the BIOS is not set correctly. Taking the ASUS notebook as an example, the specific operating steps are as follows: Click F2 to enter the BIOS when booting. Select the secure boot menu on the security tab. secure boot control Press Enter to select Disable, and press F10 to save. After the computer restarts, click F2 to enter the BIOS, and select Launch CSM on the boot tab.

Check the motherboard battery (CR2032) If the battery is dead, the BIOS settings (including the boot sequence) cannot be saved, and the default will be restored after every power outage. If the computer time is not accurate, this is a strong signal. Replace it with a new button battery.

How to view motherboard model from bios

Method 1: Query through BIOS. Press the DEL key to enter the BIOS when the system starts up. Check your model name in EZ mode in UEFI BIOS. (The figure below takes ROG STRIX Z590-A GAMING WIFI as an example) Method 2: Check the model name on the motherboard. You can view the model name printed on the motherboard.

Method 1: Query through BIOS. Press the DEL key when the system starts up to enter the BIOS. Check your model name in EZ mode in UEFI BIOS. Wang Chunxian (the figure below takes ROG STRIX Z590-A GAMING WIFI as an example) Method 2: Check the model name on the motherboard. You can view the model name printed on the motherboard.

The method to view the motherboard version information from the BIOS is as follows: Different computers may have different buttons to enter the BIOS when booting. Usually, there will be a prompt on the first screen of booting (such as pressing the DEL button). If no prompt is displayed, the buttons of common brands are as follows: ASUS notebook computer: Press the F2 button to boot on other brands or desktops: You can refer to the corresponding key value of the motherboard (such as FESC, etc.).

Method 1: Query through BIOS. Press the DEL key to enter the BIOS when the system starts up. Check your model name in EZ mode in UEFI BIOS. (The figure below takes ROG STRIX Z590-A GAMING WIFI as an example) Method 2: Check the model name on the motherboard. You can view the model name printed on the motherboard.

Bios method to view the motherboard model: 1: Use the DirectX diagnostic tool to view 1. First open the command running window, click the "Start" menu, enter "DxDiag", and then click Run. 2. The "DirectX Diagnostic Tool" will appear next, where you can view basic information, including the motherboard model. Two: Use Device Manager to view First open the "Control Panel" and then click the "Hardware and Sound" option.

The method to view the motherboard model from the BIOS is as follows: Different brands and models of motherboards have differences in the way they enter the BIOS and the viewing path, but the core logic is to enter the BIOS setting interface at startup and find hardware information in specific menus. The following are the specific operating steps: General method to enter the BIOS setting interface: When booting up, quickly press a specific button on the keyboard (such as Del, FF10 or Esc). The buttons may be different for different brands of motherboards.

How to solve the problem when MSI B650 motherboard turns on memory XMP or EXPO starts slowly?

1. Update the motherboard BIOS to the current version and visit MSI's official website: Open the browser, visit MSI's official website (https://), and find your motherboard model on the home page or product support page. Here is the B650 series motherboard. Download the latest BIOS: On the motherboard support page, find "BIOS & Firmware" or a similar option to download the latest BIOS version. Make sure to download BIOS files that exactly match your motherboard model.

2. First, make sure your MSI B650 motherboard BIOS has been updated to the latest version. BIOS updates often include hardware compatibility improvements and performance optimizations to help solve the problem of slow boot. Visit MSI official website: Open your browser and visit MSI official website (https://). On the product support page, enter your motherboard model (such as B650M-GAMING-PLUS-WIFI) to find and download the latest BIOS updates.

3. Memory overclocking or abnormal settings If you cannot boot up after turning on EXPO/XMP overclocking, you need to give priority to restoring the BIOS default settings: Battery buckle method: turn off the power, unplug the motherboard battery, let it stand for 5 - 8 minutes, and then reinstall; Short-circuiting pins: Use a metal tool to short-circuit the JBAT1 pin on the motherboard for 3 - 5 seconds; Button reset: If the motherboard is equipped with CLEAR CMOS BUTTON (such as some MSI models), press directly to reset.

4. Step-by-step solution Emergency recovery of the system (when the boot cannot be booted) Pull out a single memory to reset: Remove a single memory and boot, and the system will automatically reset the BIOS settings (close EXPO); Clear CMOS: Shorten the motherboard CMOS jumper or remove the battery for 5 minutes to completely clear the overclocking configuration; Failsafe Settings: Press DEL to enter the BIOS after booting, and select "Failsafe Settings" to restore the default parameters.

5. Update BIOS version Too old motherboard BIOS may lead to inefficient hardware recognition. For example, MSI B650 mortar motherboard users shortened the boot time from 1 minute to 18 seconds by updating the BIOS. It is recommended to go to the motherboard manufacturer's official website to download the latest BIOS files and update them through USB flash drive or built-in tools (important data need to be backed up before operation).