Creating script

Can anyone tell me how to create new scripts in sql.
Like creating new schema, table, inserting rows and columns in it.
I tried in mysql compiler but it’s not working in my sql server

Forget using MySQL compiler.
What do you mean by “scripts”?
sql OR stored procedures OR something else.

MySQL Workbench CE will tell you if your SQL is invalid.
State the SQL Create|Select|Update|Delete that you are having a problem with.