maria-developers team mailing list archive

[Sergei Golubchik <serg@xxxxxxxxxxx>]

Hi, nitin!

On Mar 04, nitin goel wrote:
> Sir/Ma'am,
> I would like to bring to your notice that i used 'mysql' to drop and create
> tables to understand project better but would like to know more
> specifications for the project 'create or replace, create if not exists,
> and drop if exists'. I have been working in C/C++ since 2010 and would like
> to learn more from you.

There's not much to add to the specifications.

There is CREATE TABLE statement, CREATE TABLE IF NOT EXISTS statement,
CREATE OR REPLACE TABLE statement.

There is CREATE USER statetement, but no CREATE USER IF NOT EXISTS and
no CREATE OR REPLACE USER.

There is CREATE PROCEDURE, but neither CREATE PROCEDURE IF NOT EXISTS
nor CREATE OR REPLACE PROCEDURE.

And so on. We'd like to have a consistent syntax and support "IF NOT
EXISTS" and "OR REPLACE" for all CREATE statements where possible.

> Please also mention how to contact the mentor for the project and proceed
> further on project.

I'm the mentor.
See http://www.google-melange.com/gsoc/homepage/google/gsoc2014
about "how to proceed further".

Regards,
Sergei