What can i do about it?

|
Curioustolearn 2021-05-12 17:59:54
MasterZiv 2021-05-12 17:33:14
There is no real need to lock tables at all, don’t use this feature, use transactions

I saw somewhere that one should use the lock function in order to avoid possible table corruption in case multiple users try to write to the same table at the same time.

MasterZiv 2021-05-12 20:07:40
Curioustolearn 2021-05-12 17:59:54
I saw somewhere that one should use the lock function in order to avoid possible table corruption in case multiple users try to write to the same table at the same time.

No no no this all is wrong approach, use transactions

MasterZiv 2021-05-12 20:08:54
Curioustolearn 2021-05-12 17:59:54
I saw somewhere that one should use the lock function in order to avoid possible table corruption in case multiple users try to write to the same table at the same time.

Just remember, you don’t need locking at all, never.
And do your tasks without them

Curioustolearn 2021-05-13 01:13:55
MasterZiv 2021-05-12 20:07:40
No no no this all is wrong approach, use transactions

Okay ! I will take a look at transactions.

Curioustolearn 2021-05-13 01:14:03
MasterZiv 2021-05-12 20:08:54
Just remember, you don’t need locking at all, never.
And do your tasks without them

Okay 👍👍👍

troliaa 2021-05-13 17:31:48
Good afternoon, could you suggest a solution to one problem?
When installing mySql, the program asked for the root password, but I have no idea where to get it. What can i do about it?
troliaa 2021-05-13 17:32:07
mysql_en-9733.jpg

troliaa 2021-05-13 17:32:12
sth like that
troliaa 2021-05-13 17:32:53
I came up with different passwords that fit all the rules. But they didn’t work
MasterZiv 2021-05-14 08:30:15
troliaa 2021-05-13 17:31:48
Good afternoon, could you suggest a solution to one problem?
When installing mySql, the program asked for the root password, but I have no idea where to get it. What can i do about it?

You can install MySQL into user directory , manually, instead of system directories. This is possible , but MySQL will not run as a service, so called daemon. For this you can download so called binary distribution (an archive containing all MySQL binaries) or you can even build MySQL yourself from the source code.

Bharath Gajula 2021-05-14 13:57:39
Hi, i got struck in installing mysql in my windows 10 laptop. I downloaded the zip file but it is not showing how to run and install the process. Can somw one guide me to install mysql
troliaa 2021-05-14 13:59:59
MasterZiv 2021-05-14 08:30:15
You can install MySQL into user directory , manually, instead of system directories. This is possible , but MySQL will not run as a service, so called daemon. For this you can download so called binary distribution (an archive containing all MySQL binaries) or you can even build MySQL yourself from the source code.

thx u so much!! i got it

troliaa 2021-05-14 14:00:47
Bharath Gajula 2021-05-14 13:57:39
Hi, i got struck in installing mysql in my windows 10 laptop. I downloaded the zip file but it is not showing how to run and install the process. Can somw one guide me to install mysql

i ll send u a video, hope it can work on laptop

Bharath Gajula 2021-05-14 14:01:06
That’s great.. thanks for the help
troliaa 2021-05-14 14:01:26
Bharath Gajula 2021-05-14 14:01:06
That’s great.. thanks for the help

SQL Tutorial – Full Database Course for BeginnersYouTube
In this course, we’ll be looking at database management basics and SQL using the MySQL RDBMS.
Want more from Mike? He’s starting a coding RPG/Bootcamp – https://simulator.dev/

The course is designed for beginners to SQL and database management systems, and will introduce common database management topics.

Throughout the course we’ll be looking at various topics including schema design, basic C.R.U.D operations, aggregation, nested queries, joins, keys and much more.

You can get PopSQL to follow along here: http://popsql.com/freecodecamp

🔗Company Database Code: https://www.giraffeacademy.com/databases/sql/creating-company-database/

⭐️ Contents ⭐
⌨️ (0:00) Introduction
⌨️ (2:36) What is a Database?
⌨️ (23:10) Tables & Keys
⌨️ (43:31) SQL Basics
⌨️ (52:26) MySQL Windows Installation
⌨️ (1:01:59) MySQL Mac Installation
⌨️ (1:15:49) Creating Tables
⌨️ (1:31:05) Inserting Data
⌨️ (1:38:17) Constraints
⌨️ (1:48:11) Update & Delete
⌨️ (1:56:11) Basic Queries
⌨️ (2:08:37) Company Database Intro
⌨️ (2:14:05) Creating…

Bharath Gajula 2021-05-14 14:01:35
Tq
troliaa 2021-05-14 14:02:05
Bharath Gajula 2021-05-14 14:01:06
That’s great.. thanks for the help

if u ve questions – ask, i downloaded it yesterday nd it works xD

Bharath Gajula 2021-05-14 14:02:31
Done. Tq
MasterZiv 2021-05-14 14:53:16
Bharath Gajula 2021-05-14 13:57:39
Hi, i got struck in installing mysql in my windows 10 laptop. I downloaded the zip file but it is not showing how to run and install the process. Can somw one guide me to install mysql

Then you should probably use the installer, not the binary distribution

Bharath Gajula 2021-05-14 14:53:54
Iam not aware of the installer can u plz guide me
MasterZiv 2021-05-14 14:54:08
Bharath Gajula 2021-05-14 14:53:54
Iam not aware of the installer can u plz guide me

No, I can’t

Bharath Gajula 2021-05-14 14:54:34
mysql_en-9774.jpg
Got stuck after the download of zip file
troliaa 2021-05-14 14:55:06
Bharath Gajula 2021-05-14 14:53:54
Iam not aware of the installer can u plz guide me

Sec

MasterZiv 2021-05-14 14:56:16
Bharath Gajula 2021-05-14 14:54:34
Got stuck after the download of zip file

Don’t download zip file, download an installer, or use Linux and install from packages

troliaa 2021-05-14 14:56:17
mysql_en-9777.jpg

troliaa 2021-05-14 14:56:38
troliaa 2021-05-14 14:56:17

U have to download this one

Bharath Gajula 2021-05-14 14:56:42
Ok
troliaa 2021-05-14 14:57:13
mysql_en-9781.jpg

troliaa 2021-05-14 14:57:16
Than this
troliaa 2021-05-14 14:57:21
That’s it
Bharath Gajula 2021-05-14 14:58:26
Wow… it’s working now. Tq
troliaa 2021-05-14 14:58:42
🥰 welcome
Bharath Gajula 2021-05-14 15:59:30
mysql_en-9786.jpg
In the final step of installation it is throwing me this error multiple times. It is not shown in YouTube video aswell
CMDLS 2021-05-14 22:08:29
Anyone can help me ? How can i learn DBMS ?
CMDLS 2021-05-14 22:08:40
In SQL ?
|