Guys it is possible to Save this table and use in other laptop without mySQL software?

Oh do not select all the code…

Once you select all of the code, it tries to make table that already exists

Just run: select part…

It still gives me errors

So how to view table using Desc

Ok… to simplyfy …delete all code… and just type:
select * from makgato;

Now i see this this

And that is your table… Just has no data in it… try to add some…

Ok thanks

Cheers! Enjoy learning sql 🙂 Also find and download some free databases online, so you can practice your querries and so…

Thanks now i see 🤗🤗 thanks to be patient to me

The more you learn, less you know… many people are patient with me as well haha 😀

Thanks so can u tell me the meaning of the following in mySQL:
NOT NULL
PRIMARY KEY()

NOT NULL, means the value in the record can’t be left empty… needs to have a value.. you will use this in columns that have to be filled in… name of person for an example

PRIMARY KEY…. is a uniqe idenfier of each row… its a value that can’t be null and it cant be like any other in the column as well… Your Passport number would be an example… Primary keys are very important, especially later on when you start joining tables together….

Thanks now i understand

You will connect Primary keys, to matching foreign keys in other tables… but leave that for now… just play with creating tables, droping them, inserting values(with code), and simple queries…

Ok
check i know C++ tell me it is possible to connect C++ IDE e.g(code::Blocks , visual studio and C++ Qt creator) with mySQL ?
after i learnt mySQL

Enjoy:
https://dev.mysql.com/doc/connector-cpp/1.1/en/connector-cpp-examples-complete-example-1.html

Not null means required

Does anyone have any pdf for mysql Dba to crack the interview for basics . Please help as I have scheduled interview 🙏

Really appreciate your help and thanks in advance

Have you ever used MySQL?

Yes, I used before 5 years ago and since few days I am doing practice on my virtual machine

But I did not get much chance for deep dive issues .

I need to explain it as a secondary skill since I am much aware about sql server database

And what were you doing till this 5 years?

Microsoft sql server database administrator

Oh, you may not worry. General things are the same

Ok

I thought things might be different. Like architecture etc.

Actually mysql is linux native so get a grip on your Linux commands before going for interview,rest general dba task are related to sql server

Okay 👍

Guys it is possible to Save this table and use in other laptop without mySQL software ?

This table is MySQL software