Does mysql have plsql?

mysql does not have plsql. plsql generally refers to PL/SQL, which is a procedural SQL language; plsql is an extension of the Oracle database to SQL statements and is specifically developed for the Oracle database stored program unit, so it cannot be connected to the mysql database.

The operating environment of this tutorial: windows7 system, mysql8 version, Dell G3 computer.

mysql does not have plsql.

plsql generally refers to PL/SQL, which is a programming language called Procedural Language/SQL. PL/SQL is an extension of Oracle database to SQL statements. The features of programming languages ​​are added to the use of ordinary SQL statements, so PL/SQL organizes data operations and query statements into procedural units of PL/SQL code, and implements complex functions or calculations through logical judgments, loops and other operations. programming language.

plsql is specially developed for the Oracle database stored program unit, so it cannot connect to the mysql database.

plsql basic usage tutorial

1. Login

1 , configure the database service here, and then you can log in

2. Enter the user name and password, and select the previously configured database service. My service name is localhost. (The name is arbitrary.)

2. Create a table space

1. In the SQL window Execute the following SQL code in.

CREATE TABLESPACE FJFEDW
LOGGING
DATAFILE 'C:\app\Administrator\oradata\orcl\FJFEDW.DBF'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;

2. Create a temporary table space. You do not need to create a temporary table space here. You can also use the default temp. The code is as follows:

CREATE TEMPORARY TABLESPACE FJFEDW_TEMP
TEMPFILE 'C:\app\Administrator\oradata\orcl\FJFEDW_TEMP.DBF'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;

3. During this process, the error ORA-02180: invalid option for CREATE TABLESPACE may occur. This may be an incorrect statement like other posts on the Internet. But the reason it appeared before for me was insufficient permissions. Just create it with a user with higher authority.

3. Create a user

1. Find the user option in New.

#2. Fill in the user name and password, and select the table space created previously. Profile selection default.

3. Set role permissions

4. Set system permissions

5. Quota setting

4. Log in with the newly created user and create a table.

1. Create a new table, fill in the table name and comments.

#2. Fill in the fields and their types.

3. Select to set the primary key. (Or foreign key, the primary key is set here. You can also set indexes, etc.)

[Related recommendations: mysql video tutorial]

The above is the detailed content of Does mysql have plsql?. For more information, please follow other related articles on the PHP Chinese website!