Database Administrator

1. Save the excel file as. csv. 2. Use Notepad to open the. csv file. The first line is all fields. 3. Create a table structure Create table yu_rt_01 asselect Transaction_Id, Last_Update_Date, Last_Updated_By, Creation_Date, Created_By,

Part 1 Database SQL language Create database tables and Indexes   Data Table(OrTable) Is one of the most important parts of the database. A database is just a framework, and a data table is actually a matter of quality. For example, the database is

I used MySQL and wanted to try PostgreSQL. It is said that it is also very powerful. I searched the internet for related Chinese books. Unfortunately, there are far fewer books than MySQL, however, I found documents translated by volunteers on the

Start Multiple MySQL instances on one server using the backup files of each database as data files for SQL Review.There was no problem before running (up to 23 MySQL instances run simultaneously). Later, a new server was configured and the

In hql, you cannot write count (1). You can write specific attributes in count (a. id ).   String hql = "select new com. haiyisoft. vo. entity. cc. repo. BusinessStat (r. paramName, t. paramName ,"+ "(Select nvl (count (1), 0 )"+ "From com.

Zookeeper See: http://note.youdao.com/share? Id = 97a96387e903c407efa7323a39b81 & type = note We want to back up the AIS20130321193629 database and restore it on the test machine. 1. Right-click the database and choose task> Backup. 2.

How can we determine whether a table exists before creating a table? Because table does not support replace. The following SQL can help you. Determine whether the table exists before create. For example, if yes, drop the table. You can also define

Update # temp Set # temp. Recycle = case when UnionA. num> 0 then 1 else 0 end From (select GradeID, sum (num) as num from AreaAllot Where CHARINDEX (@ Area, AreaAllot. Area) = 1 and LEN (@ Area) = LEN (Area)-2 Group by GradeID) UnionA inner

This article follows the previous chapter: SQL Server image IntroductionSource: http://blog.csdn.net/dba_huangzj/article/details/27203053 As the saying goes: to do good deeds, you must first sharpen your tools. Planning how to deploy and use images

1. installation environment: Operating System and version [Root @ stone ~] # Cat/etc/issue Red Hat Enterprise Linux Server release 6.2 (Santiago) Memory settings [Root @ stone ~] # Free-m Total used free shared buffers cached Mem: 1063 721 341 0 25 3

If the default Kernel Parameter of the Solaris system is used, the Out of memory error occurs during database creation. In versions earlier than Solaris 10, system parameters were set in/etc/system. This method is not used in Solaris 10/OpenSolaris. 

Developed by the IBM Research and Development Lab, BLU (the development code represents "big data, lightning fast, ultra-easy") integrates the columnar processing) technologies such as deduplication, parallel vector processing, and data compression.

System Environment: CentOS release 5.10-64 bit Application Environment: Oracle 10.2.0.5 Error summary: [Oracle @ hz_cpm50 ~] $ Impdp/DIRECTORY = move dumpfile = new. dmp logfile = new. log table_exists_action = append content = data_onlyImport:

1. Modify the table fields: Modify the Data Type of a column (generally, the length is limited and there are many restrictions when you change it to a different type ): Syntax: alter table name MODIFY (column name data type ); Eg1: alter table skate_

The following error occurs when you use Hibernate to save data to an Oracle database: 19:52:35, 156 WARN JDBCExceptionReporter: 100-SQL Error: 1461, SQLState: 7200019:52:35, 156 ERROR JDBCExceptionReporter: 101-ORA-01461: Can only bind the LONG

You can use exec or call to call a written stored procedure in Oracle data, but you can only use call to call the stored procedure in db2. Pay attention to parameter issues and parameter issues.   Exec proc_pay_idv ('20140901 ',?); The execution

Directory1. Summary of Report Content2 Oracle Database 11g R2 installation process details2.1 preparations before installation2.1.1 copy the Installation File2.1.2 decompress the compressed file of the installation package2.1.3 create oracle users

I. Description I recently came into contact with the mysql database, so I am free to study it. Today I will demonstrate how to install mysql with the source code. If I use the rpm package for installation, I personally feel quite simple. MySQL

Error description: When Oracle 10 Gb is installed on CentOS 6.3, the following error occurs: "/lib/i386/libawt. so: libXp. so.6: cannot open shared object file: No such file or directory" Solution Process: Refer to: Installing libXp. so.6: cannot

This article mainly records the complete process of creating a physical standby database for reference in practice. this experiment is designed to build two databases TEST and STD_ASSG on the local machine. TEST is the master database and STD_ASSG