Tag:mysql

  • Database Index

    Time:2019-8-24

    Database Index Why use index Generally, when the amount of data is small, the data is loaded into memory and scanned in full table. A large amount of data must be indexed (dictionary). What kind of information can be indexed Fields that can limit the record to a certain range of lookups. Primary key, unique […]

  • Importing CSV files into MySQL using Navicat

    Time:2019-8-24

    This article shares the specific code of importing CSV files into MySQL using Navicat for your reference. The details are as follows. 1. Open navicat, connect to the database and find the tables you want to import. The database table is under the table under the specified database. 2. Right-click on the data sheet. Click […]

  • Record a MySql data splitting

    Time:2019-8-23

    Preface When I went to work in the morning, the query data suddenly found slower, so I went to look at the database, and found that the table data had reached ten million levels, so I was ready to split the table. thinking Because table_one data is very large and online businesses write data to […]

  • Navicat for MySql Visual Import CSV File

    Time:2019-8-23

    This article shares the specific code of Navicat for MySql visual import CSV file for your reference. The details are as follows. Version number:Navicate 12 1. Create a database, right-click the table and import wizard. 2. Select the format of the imported data file, next – >. 3. Choose the. CSV file to import. Pay […]

  • Summary of Format Errors in Exported CSV Files

    Time:2019-8-22

    Problem Description:At present, in general, in the process of web development, there are many cases of using import and export reports. Let’s start with the derivation. The number of rows exported from the project is more than 500,000, and the CSV mode is chosen. For the following application scenarios, there are several points to note […]

  • Go grabs web data and stores it in MySQL and returns JSON data

    Time:2019-8-22

    Preface Want to learn long agoGOHowever, due to preparation for postgraduate study and internship, it has been delayed to start, only occasionally look at the relevant basic grammar, and did not specifically apply it to the actual coding. When I was a senior, the course was much less, so I decided to use it to […]

  • Several methods of retrieving MySQL password forgotten under Linux (recommendation)

    Time:2019-8-22

    Today, we mainly talk about the Linux forgetting MySQL password processing method. Here are five Linux forgetting MySQL password retrieval methods. Method 1 (first-in root permission): # /etc/init.d/mysql stop # mysqld_safe –user=mysql –skip-grant-tables –skip-networking & # mysql -u root mysql> update user set password=password(“newpassword”) where user=‘root‘; mysql> flush privileges; mysql> quit # /etc/init.d/mysql restart # […]

  • Node.js+MySQL+Vue full stack combat project

    Time:2019-8-21

    This project is a Node.js-based full stack is a practical project, the goal is to lead readers and friends to start the actual combat. As we all know, the whole stack engineer will have more prospects than the pure front-end. I hope this article can bring some benefits to my friends. The actual combat project […]

  • Go grabs web data and stores it in MySQL and returns JSON data

    Time:2019-8-21

    The previous section has explained what to do and the directory structure of the entire applet, and then the coding section begins.First introduce the package under the project into the entry filecrawldataThen call the function in which the data is fetched, temporarily namedCrawl: package main import ( “fmt” “indiepic/crawldata” ) func main () { // […]

  • Navicat imports CSV data into MySQL

    Time:2019-8-21

    This article shares how to use Navicat to import CSV data into MySQL for your reference. The details are as follows. 1. Get CSV data and save excel as CSV with office save as function. (Of course, this is the reason why my own data exists in excel, if you are CSV data, ignore this […]

  • Recommend some PHP and back-end related technology blogs

    Time:2019-8-20

    Link to the original text: He Xiaodong Blog No matter which one you think of and which one you write, there are other integrated technology communities like SegementFault and Nuggets, which are often haunted by big guys. Technological blog should be only the condiment of technological career, and the core should be solid foundation and […]

  • Timely Backup of Database under Linux

    Time:2019-8-20

    Timely Backup of Database under LinuxTimely Backup of MYSQL Database Using Crontab under LinuxJust follow these three steps and everything is under your control: Step 1: Configure the backup directory code on the server:1 mkdir /var/lib/mysqlbackup 2 cd /var/lib/mysqlbackupStep 2: Write backup script code:1 vi dbbackup.sh Paste the following code and make sure to change […]