When using PowerDesigner to design the ORACLE library table in the past, it is very convenient to generate the SQL statement to build the table. There is an option, which means that when the COMMEN
Tag: mysql
PowerDesigner connects Mysql, establishing a reverse engineering diagram – Mysql’s ODBC establishment
anywhere else Solved, there was a problem in the last step, and an exception was prompted:
In the legend, programmers like to use powerDesign for database modeling. Usually, the physical mode
MySQL Backup – Back up all databases in turn using mysqldump
In some scenarios, the databases need to be backed up separately, and in some scenarios, all the databases need to be backed up together. Hereby we organize this backup script
#! /bin/bash
#
PowerDesigner Connect the mysql database using the DSN file
First create a new PDM model
Enter the password and click OK, there will be a little pause and then a pop-up will pop up. The connection is successful. This is to test whether it can be connected.
To connect to mysql in PDM, see the following steps:
126 Mysql Storage Engine Overview
Table of Contents
Data in MySQL is stored in files (or memory) using various techniques. Each of these technologies uses different storage mechanisms, indexing techniques, locking levels, and
133 mysql view, transaction, index (very important)
Contents
# Data dependency: single table emp# Syntax# Create view mysql>: create view view name [( Aliases)] as select statement; eg>: create view v1 as select dep, max(salary) from emp group
DRBD + HeartBeat + MySQL: Configuring the high availability of MySQL
DRBD+Heartbeat+Mysql: Configure mysql high availability
Description:
Today I will continue to study the second application of DRBD, using DRBD+Heartbeat+Mysql: configure mysql high avai
Enter net start mysql prompt in cmd: Service name is invalid or mysql is starting mysql unable to start
The error is shown in the figure:
The reason for the error is:Because of net start + service name, the service registered under win is started . At this time, mysql is not registered to the s
PowerDesigner ODBC connection mysql
First Install mysql, then install the odbc driver, I installed mysql-connector-odbc-5.3.4-win32.msi. The following is the link of odbc driver and mysql http://pan.baidu.com/s/1gfodRv9, these two in
129 mysql data type (important)
Contents
mysql The database supports the following data types:
Key points:tinyint, int, constraints (unsigned, zerofill)
tinyint: 1 byte -128~127 (for logical judgment) Key points