Database Administrator

Install MongoDB on CentOS7 Install MongoDB on CentOS7 1. Connect to the CentOS7 server through SecureCRT; 2. Go to the/usr/local/directory:Cd/usr/local 3. Create the tools directory in the current directory:Mkdir-p tools 4. Go to the tools directory:

I. IntroductionI have been using Linux for a long time. I have never studied hard tasks and system learning. Recently, I have to use MySQL in Linux for my work. I thought that I had experience using SQL Server in Windows and thought it would be easy

ASCII (str)Returns the ASCII value of the first character of the string 'str' (0 is returned when 'str' is an empty string)Mysql> selectASCII ('2 ');-> 50Mysql> select ASCII (2 );->50Mysql> select ASCII ('dete ');-> 100ORD (str)If the string 'str'

In order to learn the SQL statements of the database, after a long wait and learning, I finally learned how to use Oracle 10 Gb to learn the SQL statements of the database over the past few days. Required Software: Oracle 10g, TOAD for Oracle The

Oracle10g (32, 64-bit) is successfully installed in win7 (32, 64-bit ). Win7-32-bit installation 32-bit oracle10g, win7-64 32-bit installation, 64-bit oracle10g can refer to this case. Reference:

How to update a patch (Rolling Patch) in the Oracle RAC EnvironmentThe Oracle RAC database environment has many similarities and differences with the single-instance database environment. You can use opatch to update database patches. However, there

SQL Server not found or unable to access server problem solved, Server not found Problem information: "network-related or instance-specific errors occur when you establish a connection with SQL Server. The server is not found or cannot be accessed.

ORACLE converts data between milliseconds and dates, and oracle converts data between milliseconds. Convert millisecond to date SELECT TO_CHAR(1406538765000 / (1000 * 60 * 60 * 24) + TO_DATE('1970-01-01 08:00:00', 'YYYY-MM-DD HH:MI:SS')

IP address cocould not be resolved: Temporary failure in name resolution, resolvedresolution Mysql logs were found to have the following warnings this morning: 140724 18:41:25 [Warning] IP address '192. 16.18.217 'cocould not be resolved: Temporary

MyBatis framework Learning (III)-Mapper proxy development, mybatis-mapperIn the previous section, we learned the simple implementation of CRUD in MyBatis. In this process, we used the original Dao method for development. In this process, we found

The TNS-01201: Listener cannot find executable... error message was recently received when the Listener was started. This error has never been encountered. I really don't know what it is. The following is a detailed description of the error and the

Since the introduction of the relational database model by edugatd in 1970, relational databases began to emerge. After more than 40 years of evolution, today's relational databases have a wide variety of features and are widely used. In the face of

PL/SQL Developer   Remote connection to Oracle Database   I searched many methods online. This is feasible!   1. Configure the server tnsnames. ora file. If oracle is not installed on the local machine, you can copy one (tnsnames. ora file) in the

Platform: RHEL4.8, Oracle10.2.0.1Plan: db_name = dndn, db_unique_name/ORACLE_SID = dndnThe above two parameters can also be set to different. $ Export ORACLE_HOME = $ ORACLE_BASE/product/10.2.0/db_1 $ Export ORACLE_SID = dndn 2. Create an

SQL Study Notes (14) ------------ data table, SQL statement for creating a data table Operations on Data TablesBasic Database OperationsWith MySQL, you can choose between the three basic database table formats (version 3.23. When creating a table,

Comprehensive Sqlite Learning (2) and sqlite Learning Finally, CSDN was chosen to sort out the knowledge points published over the past few years. This article was migrated to CSDN in parallel. Because CSDN also supports the MarkDown syntax, it's

To perform time operations in SQL, You need to master four time functions: dateadd, datediff, datepart, and datename.Dateadd is to add or subtract a time on a specified date.For example, if you add a 3-day select dateadd (day, 3, '2017-05-06 ') on

15 required MySQL management tools for DBAs and 15 required mysql for DBAs Original article: http://www.techxue.com/techxue-11898-1.html Today, the response speed of Web applications is one of the keys to success. It is closely related to user

As one of the mainstream databases in the current market, Oracle databases are developed on many applications. Due to the reasons for upgrading Oracle databases and different application providers, several Oracle versions may exist in an application

During the implementation of software projects, data import has always been a headache for the project staff. In fact, many data import methods are integrated in SQL Server. Some project implementation consultants have a headache. In the eyes of our