NAV: SLTechnology News&Howtos > Database >

• 

  Mysql DOS: enter the Mysql running text directory F:\ mysql-8.0.13-winx64\ bin

  The Mysql database is installed in the F:\ mysql-8.0.13-winx64 directory, but the running files enter the DOS (that is, the cmd window) with administrator privileges in the\ bin directory. 2. Enter the mysql installation directory; cd / d F:\ mysq

  2022-06-01 14:12:44 Views: 287
• 

  Centos73 postgresql9.6.2rpm installation

  Postgresql9.6.2 rpm installation 1. Install rpm package rpm-ivf postgresql96-libs-9.6.2-2PGDG.rhel7.x86_64.rpmrpm-ivf postgr

  2022-06-01 14:12:44 Views: 244
• 

  Install mysql

  First, the experimental environment installs MySQL II and operation script 1 in the Linux system. Cd / mntlsmount / dev/cdrom / mnt2 is mounted on CD. Establishing yum Warehouse cd / etc/yum.repos.d/vim aaa

  2022-06-01 14:12:14 Views: 285
• 

  Oracle business optimization ask for help, ask for repetition of this month and last month in the combined partition table

  With cur_month as (select * from CUST_SFM_JYCRMEPC_LISTwhere mold = '302'and create_time > = to_date (to_)

  2022-06-01 14:12:13 Views: 224
• 

  Indexes, views, stored procedures, and triggers

  1. Index: method of data sorting, fast query data classification: unique index: primary key index with the same value is not allowed: index corresponding to primary key created automatically, command mode non-removable clustered index: physical order is the same as index order, only one nonclustered index can be created: physical order is not consistent with index order.

  2022-06-01 14:12:13 Views: 257
• 

  Sybase date function

  Sybase date function date function getdate () gets the current time, which can be set to get various time formats. Datepart (date part, date) takes a certain part of the specified time, year, month, day, minute and second. Datediff (date part, date 1, date 2)

  2022-06-01 14:12:12 Views: 221
• 

  Zabbix monitors mysql performance

  Today, let's take a look at how zabbix monitors mysql performance. Using the template that comes with mysql, you can monitor the following contents: OPS (add, delete, modify and query), mysql request traffic bandwidth, mysql response traffic bandwidth, and finally attach the corresponding monitoring chart! Write check

  2022-06-01 14:12:12 Views: 255
• 

  Oracle database deployment

  Previously, we have studied Microsoft's sqlserver and Oracle's mysql, and also understood the role of database systems. These two database management systems are suitable for background databases such as software, websites, games and so on. For example, we have built dynamic websites when we are learning mysql.

  2022-06-01 14:11:42 Views: 297
• 

  Install redis under windows

  1. Download redis installation package download address: https://github.com/MicrosoftArchive/redis/releases download screenshot: 2. Double-click the installation steps as follows:

  2022-06-01 14:11:19 Views: 281
• 

  Install MySQL using standard source distribution

  Pre-compilation installation preparation OS:CentOS 6.9Mysql:5.7.18 download Mysql source official source: mysql-boost mysql Sohu source: mysql-boost mysql uninstall the original version query before installing Mysql

  2022-06-01 14:11:19 Views: 241
• 

  Build LAMP by Ubuntu14.04

  1. Update the software source (for specific documents, please contact this blogger, there is a blogger's email on the home page) 2. Install Apache3. Check whether Apache is installed successfully. 4. Install PHP55. Check out version 6 of PHP5. Check to see if apache has loaded the libphp5.so module

  2022-06-01 14:11:19 Views: 237
• 

  MySQL management

  MySQL management starts and shuts down the MySQL server first, we need to check whether the MySQL server is started with the following command: ps-ef | grep mysqld if MySql has been started, the above command will output a list of mysql processes

  2022-06-01 14:11:15 Views: 271
• 

  Yum installs lamp and Xcache acceleration

  The construction of LAMP: using two virtual machines, one virtual machine installs httpd and php, compiles php as a module into httpd, and the other installs mysql, so that php can call mysql to read data. Virtual machine 1VR 172.18.250.76C

  2022-06-01 14:10:45 Views: 217
• 

  Install the Oracle 11gR2 client

  Installing the Oracle 11gR2 client describes how to install the Oracle 11gR2 database client. Export DISPLAY=192.168.1.1:0.0192.168.1.1 is the IP of the host where the Xmanager resides

  2022-06-01 14:10:45 Views: 259
• 

  Vue family bucket + Express blog (the back-end API is all handwritten by itself)

  Why learn and use Vue1. Development trend in the front-end circle in recent years, as the stage is generally brilliant, from MVC to MVVM, you just sang and I made my debut. Backbone,AngularJS has become a thing of the past, reactjs is in its heyday

  2022-06-01 14:10:45 Views: 205
• 

  Oracle series: (33) JDBC accesses stored procedures and stored functions of Oracle

  1. Prepare the SQL-- definition stored procedure create or replace procedure get_rax (salary in number,rax out number) as--

  2022-06-01 14:10:45 Views: 271
• 

  Installation of HBASE version 0.98, three steps: install Zookeeper 3.4.5

  1. Download zookeeper 3.4.52, decompress 3, move to the appropriate location / home/hadoop/zookeeper4, set a zookeeper location / home/hadoop/zk5, modify zooke

  2022-06-01 14:10:44 Views: 251
• 

  Configuring InnoDB Buffer Pool

  Translated from the official document InnoDB performs certain tasks in the background, including flushing of dirty pages (those)

  2022-06-01 14:10:38 Views: 212
• 

  Several differences between temporary files and data files

  Some differences between temporary files and regular data files 1 temporary data files are always set to nologging2 cannot create temporary data files using alter database 3 Media recovery cannot restore temporary data files 4 when creating temporary data files, oracl

  2022-06-01 14:10:38 Views: 243
• 

  Still writing the GROUP BY clause manually? SQL Prompt can be used by itself

  SQL Prompt is a practical SQL grammar prompt tool. SQL Prompt automatically retrieves according to the object name, syntax and code snippet of the database to provide users with appropriate code choices. Automatic script settings make code easy to read-when developers are not familiar with scripts

  2022-06-01 14:10:38 Views: 207