Crearea unei baze de date

postat acum 4 ani de Stefanescu Mihai in categorie SQL

Sintaxa de creare a unei noi baze de date este foarte simpla:

CREATE DATABASE numeleBazeiDeDate;

Numele unei baze de date trebuie sa fie unic in SGBD.

Sa luam urmatorul exemplu, dorim sa cream o noua baza de date numita bdTest, codul va fi urmatorul:

SQL> CREATE DATABASE bdTest;

Atentie, trebuie sa aveti drepturi de admin pentru a putea crea o baza de date. O data ce baza de date a fost creata puteti verifica daca apare in lista de baze de date in modul urmator:

SQL> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| ShopFirst          |
| Invata-Programare  |
| forumPluginDev     |
| WordPressDev       |
| testDB             |
+--------------------+

 

Sunt un tanar programator din Bucuresti ce lucreaza in PHP/Mysql (MySqli/PDO), Laravel, CodeIgniter, MySQL, PostgreSQL, Wordpress, HTML5/CSS3, Sass, Photoshop si multe altele.
Google+ Community Facebook Group
Acest articol a fost mutat de pe vechea platforma.
Pentru orice eroare aparuta la mutare va rog sa ma contactati!

Comentariu postate de g la data de 13.05.2019
We stumbled over here by a different web address and thought I may as well check things out. I like what I see so now i'm following you. Look forward to exploring your web page again.
Comentariu postate de how to download minecraft la data de 16.05.2019
Thanks for sharing your thoughts about free. Regards
Comentariu postate de minecraft pc download la data de 16.05.2019
I always spent my half an hour to read this blog's content daily along with a mug of coffee.
Comentariu postate de free minecraft download la data de 17.05.2019
Nice post. I was checking constantly this weblog and I'm impressed! Extremely useful info particularly the last phase :) I maintain such info a lot. I was seeking this certain information for a long time. Thank you and good luck.
Comentariu postate de download minecraft free la data de 18.05.2019
Have you ever considered about adding a little bit more than just your articles? I mean, what you say is important and all. However just imagine if you added some great photos or video clips to give your posts more, "pop"! Your content is excellent but with images and videos, this site could certainly be one of the very best in its niche. Terrific blog!