Programmer Group

MySQL password change Check whether MySQL service is started. If not, use / etc/init.d/mysqld start [root@test-a ~]# ps aux | grep mysql root 2180 0.0 0.1 115432 1724 ? S 07:33 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/data/mysql --pid-file=/usr/local/mysql/mysqld.pid mysql 2390 0.9 17.8 1117648 180356 ? ...

1. Date format tool method 1.1. code public class DateUtil { public enum DateType{ /** * Mm / DD / yyyy HHM / S */ YMDHMS("yyyy-MM-dd HH:mm:ss"), /** * Mm / DD / yyyy hrs / min */ YMDHM("yyyy-MM-dd HH:mm"), /** * Specific date */ YMD("yyyy- ...

CentOS Six.Five install MySQL 5.6 1. View system status [root@itzhouq Three 2 tools]# cat /etc/issue CentOS release 6.5 (Final) Kernel \r on an \m [root@itzhouq32 tools]# uname -a Linux itzhouq32 2.6.32-Four 31.el6.x86_64 #1 SMP Fri Nov 22 03:15:09 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux 2. Create a directory to download rpm package [root@itz ...

onos compilation and installation 1 pre download and installation 1.1 front package installation sudo apt-get install git sudo apt-get install python #Oracle JDK8 sudo apt-get install software-properties-common -y && \ sudo add-apt-repository ppa:webupd8team/java -y && \ sudo apt-get update && ...

Build a jar package Using Spring Boot to build a simple web program, you can start it directly using java jar. @RestController @RequestMapping("/root") @SpringBootApplication public class SbDemoApplication { public static void main(String[] args) { SpringApplication.run(SbDemoApplication.class, args); } @RequestMapping("/h ...

DCL Data control language Statement of authorization and right to receive as mentioned before grant, revoke Data definition language create alter,drop statement, create table, modify table, delete Create table create table $tablename$( id int, name,varchar(5) --Maximum length required to declare money,number(6,2) --9999.00 ) -- Cop ...

Problem description A few days ago, I was helping my colleagues to troubleshoot the occasional thread pool errors on the production line The logic is simple, and the thread pool performs an asynchronous task with results. However, there have been occasional errors recently: java.util.concurrent.RejectedExecutionException: Task java.util.concurr ...

Index and view details of Mysql database The concept of index The index of a database is similar to that of a BookIn a book, you can quickly find the required information by using the catalog without reading the whole bookThe table of contents in the book is a list of words with page numbers containing each wordDatabase indexIn the database, ...

Record a series of errors after modifying the size of sga once After modifying the sga size of oracle, we encountered a series of errors. 00844 and 00851 error reporting SQL> startup; ORA-00844: Parameter not taking MEMORY_TARGET into account ORA-00851: SGA_MAX_SIZE 2147483648 cannot be set to more than MEM SQL> 01078 error reporting SQ ...

Basic concepts of databases Data: Symbolic records describing things are called data. Include numbers, text, graphics, images, sounds, file records, etc. Store in a uniform format as a "record". Table: A table is formed by grouping different records together Is used to store specific data Database: A database is a collection of ...