MySQL first database creation

Question

I need to create a database for employees that stores information about their names, salaries, salary status, dates, and messages between the employees. At least 3 users are needed. Foreign keys and an ER diagram. Can I go about creating this database by creating tables, importing data thru code and then just create a diagram by reverse engineering. I have no clue. My main concern is whether it is enough to only use tables or is there more to it? I'm completely new to MySQL and I hope some of you can help me out.

Sounds more like you need an application (which might have a database) — Olaf Kock
– Olaf Kock, Commented Mar 26, 2022 at 19:17

Md Rasheduzzaman · Accepted Answer · 2022-03-26 19:18:07Z

1

If you are using phpmyadmin, you can easily create a database and tables. or if you want to create by code you can use like,

CREATE DATABASE databasename;

and table will be created by like,

CREATE TABLE employees (
column1 datatype,
column2 datatype,
column3 datatype,
....
 );

answered Mar 26, 2022 at 19:18

Md Rasheduzzaman

1

Sign up to request clarification or add additional context in comments.

4 Comments

Dragan Basa Over a year ago

thank you. But I'm more stuck on importing data than anything else

Md Rasheduzzaman Over a year ago

Which data do you want to import?

Dragan Basa Over a year ago

int, charset(40), date. It's mostly text and dates. Can i add a short biography into just one table cell?

Md Rasheduzzaman Over a year ago

yes, you can use varchar(255), or text(), logntext() etc for taking short biography

Collectives™ on Stack Overflow

MySQL first database creation

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related