MYSQL Storage Directory and Standard Database
Introduce the storage directory of MYSQL
I. Location of Mysql Data Storage by Command
$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 8.0.12 MySQL Communi ...
Posted by fxmzb123 on Tue, 27 Aug 2019 07:26:31 +0200
oracle multi-table Association query and sub-query
I. Multi-table Association Query
Example:
SQL> create table student1
(
sid varchar(3),
sname varchar(6),
sage number(3));
Table created.
SQL> create table course1
(
sid varchar(3),
cname varchar(8),
cno number(3));
Table created.
student1 table
SQL> select * from student1;
SID SNAME SAGE
--- ------ ...
Posted by jaydeesmalls on Fri, 23 Aug 2019 10:08:23 +0200
Personal Information Network Management System for Company Employees
Personal Information Network Management System for Company Employees
mysql Database Creation Statement of Personal Information Network Management System for Company Employees
Company employees personal information network management system oracle ...
Posted by vestax1984 on Thu, 15 Aug 2019 15:31:47 +0200
mysql database learning notes (summary)
mysql database learning collation
Log in to the database
Mysql-u username-p password
Look at the database and note that it ends with a semicolonshow databases;
# Display all databases (# is the symbol for mysql annotations)
_____________________ ...
Posted by mikster on Wed, 14 Aug 2019 10:59:39 +0200
Membership Card Management System
Membership Card Management System
Membership Card Management System mysql Database Creation Statement
Member card management system oracle database creation statement
Membership card management system SQL Server database creation statement
Membership card management system mysql database v ...
Posted by parboy on Tue, 13 Aug 2019 12:04:29 +0200
CSS-Small Practice of Web Page Making
1. Naked Running of Web Pages
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Naked Running of Web Page </title>
</head>
<body>
<h1> James Gosling, the Father of Java</h1>
<img src="../java.jpg"/>
<p> James Gosling, the ...
Posted by weevil on Mon, 12 Aug 2019 14:00:04 +0200
MySQL_Server_8.0.17_Environment Setup_Basic Knowledge
MySQL download, install, configure:
1.1 Download Address: https://dev.mysql.com/downloads/mysql/1.2 Unzip, Configuration File: Unzip to the C disk'web'folder.
Add the configuration file "my.ini" under the mysql-8.0.17 folder:
[client]
# Setting the default character set for mysql client
defa ...
Posted by Jeff4507 on Wed, 07 Aug 2019 14:19:49 +0200
Oracle ILM Related (Information Life Cycle Management)
Introduction to Information Life Cycle Management
1. Concept
The concept of ILM (Information Life Cycle Management) was born in the 1960s and 1970s. It was proposed by StorageTek (acquired by Oracle in 2010). EMC is a comprehensive management method from the generation and initial storage stage of ...
Posted by whoisKeel on Wed, 07 Aug 2019 14:14:28 +0200
Dynamic proxy parsing
I. What is the Agency Model
Definition of proxy pattern: The proxy pattern provides a proxy object for an object, and the proxy object controls the reference of the original object. Generally speaking, the agency model is a common intermediary in our life.
Classification of Agent Patterns: Agent Patterns are divided into Static Agents and D ...
Posted by BoxingKing on Thu, 01 Aug 2019 05:52:27 +0200
ORACLE 11g uses ROWNUM to perfect ORA-00600: internal error code
1, ORA-00600: Internal error code
Oracle upgraded from 11.2.0.1 to 11.2.0.4. Developers reported a job failure, debugging error messages, ORA-00600: internal error code, parameters: [rwoirw: check ret val], [], [], [], ORA-06512:... As shown in the following figure:
C:\pic\oracle\2017040501 ...
Posted by postmanager on Tue, 30 Jul 2019 08:56:41 +0200