Jump to content

  •  

- - - - -

MYSQL


  • Please log in to reply
14 replies to this topic

#1 Aeros

Aeros

    Newbie

  • Member
  • Pip
  • 6 posts

Posted 11 January 2018 - 03:58 AM

Hello, I was wondering if MYSQL Is hard to learn, I need to learn it to add certian things to my site? can anyone give me some feed back?

#2 FKDATSHT

FKDATSHT

    Newbie

  • Member
  • Pip
  • 2 posts

Posted 22 January 2018 - 11:44 AM

I wouldn't really say it's "hard" to learn, fairly easy.

#3 VoidNetworkPT

VoidNetworkPT

    Newbie

  • Member
  • Pip
  • 5 posts

Posted 23 January 2018 - 06:41 AM

I'm not very experienced but I have built a couple of simple websites that used MySQL. If you don't know that it is, it is basically a system that allows you to store information on a database, from which you can access and retrieve information. You start by creating tables that contain different columns with different information about it's entries, for example, a table called "Users" may contain the columns "ID, Username, Age, Email" etc. which are then assigned to each entry. It's also important that you know you must use a different programming language in order to access this data and display it on your website, for example PHP, which requires a bit more time to learn than MySQL. MySQL is really not that hard to learn the basics, but the deep concepts are harder to learn, but if you're planning to build a not very sophisticated website, you will be fine.

Here's a little SQL query just so you can see how it works. and how accessible it is:
SELECT Username FROM Users WHERE Age=19

This query will retrieve all the usernames from the table "Users" where the age equals to 19.

#4 emm.strips

emm.strips

    Newbie

  • Member
  • Pip
  • 9 posts

Posted 19 February 2018 - 05:04 AM

There's a lot of tools and applications to automate building databases for you, but I recommend learning the basics at the least. It's good for when it comes to managing and if you need to mass replace stuff. Like the guy above me said, the deeper the more difficult.

#5 Sh0oter

Sh0oter

    Newbie

  • Member
  • Pip
  • 7 posts

Posted 24 May 2018 - 03:30 AM

I would strongly recommend you to get any graphic interface for better understanding MySQL. I'm personally using Navicat.

#6 hissen7

hissen7

    Member

  • Member
  • PipPip
  • 17 posts

Posted 13 June 2018 - 12:15 AM

It's not really hard once you're used to queries and so on.....

!

#7 xPrince

xPrince

    Newbie

  • Member
  • Pip
  • 5 posts

Posted 17 June 2018 - 07:24 AM

mysql belongs to the easier programming languages

#8 wiikey

wiikey

    Member

  • Member
  • PipPip
  • 12 posts

Posted 21 August 2018 - 12:50 PM

Do you know the code PDO access to Mysql on IPS.
Could you please fix the CODE so that it can be used with this IPS BOARD?

[font="MS Pゴシック", Osaka, "ヒラギノ角ゴ Pro W3"]try {[/font]
[font="MS Pゴシック", Osaka, "ヒラギノ角ゴ Pro W3"]$pdo = new PDO('mysql:dbname=' . $db['dbname'] . ';host=' . $db['host'] , $db['user'] , $db['pass'] );[/font]
[font="MS Pゴシック", Osaka, "ヒラギノ角ゴ Pro W3"]} catch (PDOException $e) {[/font]
[font="MS Pゴシック", Osaka, "ヒラギノ角ゴ Pro W3"]exit('can't access mysql' . $e->getMessage());[/font]
[font="MS Pゴシック", Osaka, "ヒラギノ角ゴ Pro W3"]}[/font]



#9 Geo620

Geo620

    Newbie

  • Member
  • Pip
  • 7 posts

Posted 07 September 2018 - 09:21 PM

Yes, simple enough. Once you understand the structure.


To help you :



https://downloads.my...erpt-5.5-en.pdf

#10 Douzan

Douzan

    Newbie

  • Member
  • Pip
  • 6 posts

Posted 10 September 2018 - 04:32 AM

I wouldn't say MYSQL is hard because most of where MYSQL is used is done via an application. I prefer SQLYOG. Having the basic SQL command knowledge surely helps but the application can help you out. There are apps out there to even generate SQL code for you, based on the results you were seeking. If you are a back-end developer, I would definitely suggest learning SQL but if you are a front end or designer and just needs to get an idea of what it is, I suggest not learning it and just looking at applications that support it instead.

#11 Caesius

Caesius

    Newbie

  • Donator
  • Pip
  • 7 posts

Donator

Posted 22 October 2018 - 11:40 PM

Hello here,

First, you made a mistake (everyone does, but vocabulary is very important in programming languages, it can really help you). MySQL is not a language, it's a relational database management system (RDMS) and in order to manage those databases, you use SQL. SQL is a language, you can use  this language in several RDMS, the syntax can changed but it's almost the same thing. If you really want to learn SQL, Codecademy is an excellent website where you can learn while practicing and it's free.

#12 Invader Zim

Invader Zim

    Member

  • Member
  • PipPip
  • 10 posts

Posted 25 November 2018 - 02:47 AM

Hi! Just an advise, I learn MySQL when I tried to re engineered a php website. It like breaking the entire code and then finding what each line meant. The Host + databasename + username + password is your key to get inside the MySQL Database base. Just imagine it like an airport where you go board in, the security personnel (login page) will ask you for your ID and passport (username) and check your face (password), then will recheck the ticket for your flight (databasename). Then they check if you flight exist (host) and if everything is set, then you can proceed. I highly recommend you give it a try and if you get into any errors, you can always google the entire error and try to understand what it means.

#13 cold

cold

    Community Team & Verified Uploader

  • Community Team
  • 158 posts

Donator

Posted 25 November 2018 - 02:49 AM

View Postratngailaga, on 25 November 2018 - 02:47 AM, said:

Hi! Just an advise, I learn MySQL when I tried to re engineered a php website. It like breaking the entire code and then finding what each line meant. The Host + databasename + username + password is your key to get inside the MySQL Database base. Just imagine it like an airport where you go board in, the security personnel (login page) will ask you for your ID and passport (username) and check your face (password), then will recheck the ticket for your flight (databasename). Then they check if you flight exist (host) and if everything is set, then you can proceed. I highly recommend you give it a try and if you get into any errors, you can always google the entire error and try to understand what it means.

Very interesting way of putting it...
I focus on paid IPB mods, applications and themes. However, if you require a specific file please request it here: http://invision-viru...um/17-requests/ and I'd be more than happy to check it out.

Are you looking for a moderator to manage your community? Feel free to PM me!

Do you require dedicated - free - IPS customization support? Join me on ecliptic.cc!

My support team and I will help you customize your entire forum as well as any plugins, apps and themes - for free.

Posted Image

____________________________________________________

Community Rules | Discord | News | Upcoming mods and themes

#14 Invader Zim

Invader Zim

    Member

  • Member
  • PipPip
  • 10 posts

Posted 25 November 2018 - 02:54 AM

View Postcold, on 25 November 2018 - 02:49 AM, said:

Very interesting way of putting it...

Thank you. It is like explaining it in easiest form so that I can encourage people to learn more than depend on others.

PS. If you have time and you are not easy, try to search for "The Prayer Marcelito Pomoy" , he will show you how easy to sing but definitely I do not think it is easy for everyone else.

#15 JakeyPrime

JakeyPrime

    Newbie

  • Member
  • Pip
  • 5 posts

Posted 27 November 2018 - 12:20 PM

I learned MySQL fairly easily from some quick online tutorials and some of the online courses that you can find pretty easily.
I never really actually went to school for it, but I'd say I'm pretty confident when it comes to MySQL and creating scripts to keep my databases clean or adding new features, especially SSO.
I can't recall what online courses I took, but they weren't paid courses.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users