Jump to content

  •  

Staff applications open!

We are looking for dedicated members to join the Community Team to help enforce the community rules and make IV a better place for everyone.
Do you think you have what it takes to join? Apply here: http://invision-viru...f-applications/
IV Management

- - - - -

How does mysql work?


  • Please log in to reply
7 replies to this topic

#1 Kdr

Kdr

    Newbie

  • Member
  • Pip
  • 5 posts

Posted 02 February 2019 - 04:41 AM

some one explain me in a few steps how this works so i can learn this easy.
Thanks for the one who can explain it :D

#2 omegaw

omegaw

    Newbie

  • Member
  • Pip
  • 6 posts

Donator

Posted 02 February 2019 - 10:27 PM

An exact google search with this topics title would tell you everything you need to know about mysql, I don't know why you ask this kind of question :D

#3 BenOwns

BenOwns

    Newbie

  • Member
  • Pip
  • 8 posts

Posted 03 February 2019 - 12:45 PM

mySQL is a relational database. I suggest going to https://www.mysql.com/ and checking everything out. Install it on your local PC. install some board softwares on it and learn how it works.

#4 Kajsky

Kajsky

    Newbie

  • Member
  • Pip
  • 7 posts

Posted 16 February 2019 - 10:41 PM

Check https://dev.mysql.com/ for help with syntax. Install soft like xampp, run mysql server and apache and use phpmyadmin to test your sql.

#5 02diablo

02diablo

    Newbie

  • Member
  • Pip
  • 3 posts

Posted 14 July 2019 - 09:58 AM

could you be more specif like what features inside of mySQL?

#6 exaulz

exaulz

    Newbie

  • Member
  • Pip
  • 5 posts

Posted 21 July 2019 - 09:24 AM

Imagine MySQL database like an Excel file.

Your sheets are Tables.

Within each Sheet/Table, you have: Columns and Rows (tables share these the exact same way)

This is the simplest example of MySQL I can think of.

With MySQL, you can then join data from multiple "Excel" files, very specific column values, etc. It's very, very interesting.

#7 mloneya212

mloneya212

    Newbie

  • Donator
  • Pip
  • 9 posts

Donator

Posted 22 July 2019 - 04:29 PM

MySQL is a database system that essentially stores information for later use. Its a flex-able system that allows most programming languages to be able to access the information

#8 error403 ツ

error403 ツ

    Retired Management Team

  • Retired Contributor
  • PipPipPipPipPip
  • 865 posts
  • LocationUkraine - Kyiv

Posted 08 November 2019 - 11:23 PM

View PostKdr, on 02 February 2019 - 04:41 AM, said:

some one explain me in a few steps how this works so i can learn this easy.
Thanks for the one who can explain it :D

What is MySQL: MySQL Explained For Beginners


So What is MySQL?

First things first, you have to know how to pronounce it: MY-ES-KYOO-EL’ [maɪˌɛsˌkjuːˈɛl]. Sometimes people call it “my sequel” or other names, but at least you know the official pronunciation. A Swedish company called MySQL AB originally developed MySQL in 1994. The US tech company Sun Microsystems then took full ownership when they bought MySQL AB in 2008. US tech giant Oracle in 2010 acquired Sun Microsystems itself, and MySQL has been practically owned by Oracle since.
In regard to the general definition, MySQL is an open source relational database management system (RDBMS) with a client-server model. RDBMS is a software or service used to create and manage databases based on a relational model. Now, let’s take a closer look at each term:
Database

A database is simply a collection of structured data. Think of taking a selfie: you push a button and capture an image of yourself. Your photo is data, and your phone’s gallery is the database. A database is a place in which data is stored and organized. The word “relational” means that the data stored in the dataset is organized as tables. Every table relates in some ways. If the software doesn’t support the relational data model, just call it DBMS.
Open source

Open source means that you’re free to use and modify it. Anybody can install the software. You can also learn and customize the source code to better accommodate your needs. However, The GPL (GNU Public License) determines what you can do depending on conditions. The commercially licensed version is available if you need more flexible ownership and advanced support.
Client-server model

Computers that install and run RDBMS software are called clients. Whenever they need to access data, they connect to the RDBMS server. That’s the “client-server” part.
MySQL is one of many RDBMS software options. RDBMS and MySQL are often thought to be the same because of MySQL’s popularity. To name a few big web applications like Facebook, Twitter, YouTube, Google, and Yahoo! all use MySQL for data storage purposes. Even though it was initially created for limited usage, now it’s compatible with many important computing platforms like Linux, macOS, Microsoft Windows, and Ubuntu.
SQL

MySQL and SQL are not the same. Be aware that MySQL is one of the most popular RDBMS software’s brand name, which implements a client-server model. So, how do the client and server communicate in an RDBMS environment? They use a domain specific language – Structured Query Language (SQL). If you ever encounter other names that have SQL in them, like PostgreSQL and Microsoft SQL server, they are most likely brands which also use SQL syntax. RDBMS software is often written in other programming languages, but always use SQL as their primary language to interact with the database. MySQL itself is written in C and C++.
Computer scientist Ted Codd developed SQL in the early 1970s with an IBM based relational model. It became more widely used in 1974 and quickly replaced similar, then-outdated languages, ISAM and VISAM. History aside, SQL tells the server what to do with the data. It is similar to your WordPress password or code. You input it into the system to gain access to the dashboard area. In this case, SQL statements can instruct the server to perform certain operations:
  • Data query: requesting specific information from the existing database.
  • Data manipulation: adding, deleting, changing, sorting, and other operations to modify the data, the values or the visuals.
  • Data identity: defining data types, e.g. changing numerical data to integers. This also includes defining a schema or the relationship of each table in the database
  • Data access control: providing security techniques to protect data, this includes deciding who can view or use any information stored in the database
How MySQL Works?

Posted Image
The image explains the basic structure of the client-server structure. One or more devices (clients) connect to a server through a specific network. Every client can make a request from the graphical user interface (GUI) on their screens, and the server will produce the desired output, as long as both ends understand the instruction. Without getting too technical, the main processes taking place in a MySQL environment are the same, which are:
  • MySQL creates a database for storing and manipulating data, defining the relationship of each table.

  • Clients can make requests by typing specific SQL statements on the MySQL.

  • The server application will respond with the requested information and it will appear on the clients’ side.
That’s pretty much it. From the clients’ side, they usually emphasize which MySQL GUI to use. The lighter and more user-friendly the GUI is, the faster and easier their data management activities will be. Some of the most popular MySQL GUIs are MySQL WorkBench, SequelPro, DBVisualizer, and the Navicat DB Admin Tool. Some of them are free, while some are commercial, some run exclusively for macOS, and some are compatible with major operating systems. Clients should choose the GUI depending on their needs. For web database management, including a WordPress site, the most obvious go-to is phpMyAdmin.
Why is MySQL so Popular?

Posted Image
MySQL is indeed not the only ®DBMS on the market, but it is one of the most popular ones and only second to Oracle Database when scored using critical parameters like the number of mentions in search results, professional profiles on LinkedIn, and frequency of technical discussions on internet forums. The fact that many major tech giants rely on it further solidifies the well-deserved position. Why so? Here are the reasons:
Flexible and easy to use

You can modify the source code to meet your own expectations, and don’t need to pay anything for this level of freedom, including the options for upgrading to the advanced commercial version. The installation process is relatively simple, and shouldn’t take longer than 30 minutes.
High performance

A wide array of cluster servers backs MySQL. Whether you are storing massive amounts of big e-Commerce data or doing heavy business intelligence activities, MySQL can assist you smoothly with optimum speed.
An industry standard

Industries have been using MySQL for years, which means that there are abundant resources for skilled developers. MySQL users can expect rapid development of the software and freelance experts willing to work for a smaller wage if they ever need them.
Secure

Your data should be your primary concern when choosing the right RDBMS software. With its Access Privilege System and User Account Management, MySQL sets the security bar high. Host-based verification and password encryption are both available.

Greetings
error403



You like my work? You like my support? Want more apps? Then please donate

Posted Image

Featured: Picturish - Imagehosting | BeDrive - Filehosting | Snipped - Code Snippets | jabs - URL Shortener





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users