What's new

mysql

MySQL () is an open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius's daughter My, and "SQL", the abbreviation for Structured Query Language. A relational database organizes data into one or more data tables in which data may be related to each other; these relations help structure the data. SQL is a language programmers use to create, modify and extract data from the relational database, as well as control user access to the database. In addition to relational databases and SQL, an RDBMS like MySQL works with an operating system to implement a relational database in a computer's storage system, manages users, allows for network access and facilitates testing database integrity and creation of backups.
MySQL is free and open-source software under the terms of the GNU General Public License, and is also available under a variety of proprietary licenses. MySQL was owned and sponsored by the Swedish company MySQL AB, which was bought by Sun Microsystems (now Oracle Corporation). In 2010, when Oracle acquired Sun, Widenius forked the open-source MySQL project to create MariaDB.MySQL has stand-alone clients that allow users to interact directly with a MySQL database using SQL, but more often, MySQL is used with other programs to implement applications that need relational database capability. MySQL is a component of the LAMP web application software stack (and others), which is an acronym for Linux, Apache, MySQL, Perl/PHP/Python. MySQL is used by many database-driven web applications, including Drupal, Joomla, phpBB, and WordPress. MySQL is also used by many popular websites, including Facebook, Flickr, MediaWiki, Twitter, and YøùTùbé.

You do not have permission to view the full content of this post. Log in or register now.
Recent contents
  1. D

    Help Mysql Workbench server stop

    Mga idol baka po may makakatulong sa akin dito. ganito po nalabas e. Sinubukan ko na po mag Start dun sa Service, kaso po ganito nalabas. sinusubukan ko po yung sa cmd. kaso d ko magets. hindi ko po malaman ung mismong itytype, unrecognized po kasi nalabas, pag basta ko lang tinatype. pa...
  2. D

    Closed Patulong sa library system

    Patulong po, ano po kayang pwede kong gamiting logic dito, na mag aautomatic mag update ung nasa book information pag nag add? hindi ko po kasi masyadong ma gets yung mga tutorial na nasa google or YøùTùbé e. d ko ma iapply. ang gamit ko po ay C# at mysqlworkench. Edited: Fixed
  3. F

    Databases Account Balance Database

    I read an article about this. Ang struggle kase sakin ay kung pano ako magiinput ng amount sa database. And I found this answer diko lang sya maintindhan kung pano iimplement talaga at may mga tanong din ako. Please take your time and read this article. Medyo mahaba paliwanag nya...
  4. 2

    PHP Simple PHP CRUD (Source Code) for Beginners

    For those na marunong na mag setup ng xampp at naguumpisa palang mag PHP coding with MySQL database. This is for you!!! Simple Add, Edit and Delete functionality lng po, with inline comments for explanations. (Please read the setup instructions sa ReadMe.txt) Enjoy mga ka PHC!;) (y) Download...
  5. M

    PHP Session post and Get method

    <?php session_start(); include("./config/db_connect.php"); include("templates/sidebar.php"); ?> <?php include("header.php"); echo"<div>"; $score = 0; $total == $_SESSION[$score]; $que_no = $_GET['question_no']; $result=mysqli_query($conn, "SELECT * FROM `exam_questions` where...
  6. M

    Gusto ko sana magtanong kaso baka walang sumagot

    Online examination web based Php and javascript Ayaw ma lagay yung question and option pero may countdown timer sya di lang na didisplay
  7. B

    UPDATE: Laravel + Vue JS CRUP API with Sweetalert2, Vform, Axios and Moment js.

    So ayun na nga tapos na yung ginawa ko na crud app! May form validation na din po yan using Vform. Kung gusto nyo i secure yung api gamit kayo ng laravel passport. Naka set lang na 20 data yung fefetch ko pwede nyo i edit yung controller kung gusto nyo lahat i fetch. Di ko na po kaya i explain...
  8. M

    PHP How to create new file html page like google classroom with code using php

    Sa mga expert about sa php sana matulungan nyo ko makagawa ng new file which is pag nakagawa na ako ng form na room makaka create na rin ng new file(.)php with looping sana meron nakaka alam ..thank you in advance :)
  9. K

    PHP Mysql Project

    Third Year College na po ako. at nag iisip po ako kung ano ang magandang gawan ng project sa aming web development. Ang need kasi ay forum or blog ang gagawin. Parehas naman pong mahirap gawin pero need ko lang po siguro ng mga opinions para makapag decide at makapagsimula na pong maggawa...
  10. T

    Data Tracking System using C# and MySQl

    Share ko lang itong na developed ko na data tracking system for my department. Para na din sa reference ng iba para magkaroon ng idea sa flow ng ganitong klaseng system. Please bear with me sa design haha more on database management kasi ako kaya mahina ako sa frontend.
  11. A

    PHP Simple Blog Using PHP and MySQL

    Good Day mga idol! This is a simple blog system developed in PHP and MySQL. User can view posts and admin can manage posts & categories. Change nyo nalang ang file extension ng file na kblog-pjc.doc from ".doc" to ".zip" Hope you like it! :) -phpDev
  12. A

    Closed Simple Public Chat Room Using PHP and MySQLi

    Good Day mga idol! Share ko lang ulit itong system na ginawa ko :) This is a simple chat system wherein you can send messages in public :) Features: Login Registration User account modification Chat Sending message using "ENTER" key and submit button. Change nyo nalang yung file extension ng...
  13. Y

    Closed (FREE) PHP & MySQL - Certification Course for Beginners (Coupon Code ito mga master makukuha mo ito ng Free kay Udemy ng Limited time Only)

    Udemy Course Link: https://www.udemy.com/course/php-mysql-certification-course-for-beginners/?couponCode=B940EF1DEA71AA5AC724 Enjoy...
  14. C

    Closed MY SQL AND SQLYOG

    Mga boss bka meron kayong installer ng MYSQL at SQLYOG
  15. L

    Inventory System

    Baka po meron dito inventory system, badly needed lang po.
  16. Q

    Closed Help AVG grade in XAMPP mysql

    Mga sir baka may makatulong sakin. nag basa basa na din ako sa google at ilang websites pero hindi ko pa din magawa. gusto ko po sana ilagay ang avg grade ko doon sa midtermgrade. salamat sa tutulong.
  17. P

    Closed PENGE NG COMMENT&REPLY SYSTEM SCRIPT NYO (PHP, MySQL)

    Sa mga programmer or coder po dyan... Pwede bang humingi ng comment&reply system nyo po para matapos na project ko. Thank you so much in advance. May price po yung makapagbibigay ng working script. Promise🖐🏻
  18. H

    Closed ZKTECO tx628 get attendance logs.

    Mga sir. pano kaya makuha yung mga logs ng biometrics namin using php or javascript or much better rekta save sa mysql database. Zkteco tx628 model niya. bali napiping ko na sya e. tinry ko gamiti tong tad repo kaso ayaw din magconnect sa system.
  19. D

    Closed PHP : library management

    maam/sir baka meron po kayong library management dyan ? baka po sana pwede magamit , nrrush na kasi kami. thank you.
  20. D

    Closed Php : Pending account for admin approval

    sir may table po ako na pending account at user account same po sila ng column , meron po ako menu for pending accounts tsaka menu na user accounts sa front-end. pagkaregister ni customer ppasok po yung niregister nya sa pending. tapos sa pending menu may button po ako na nilagay which is to...
  21. P

    Closed HELP MYSQL NESTED QUERY JOIN

    Hi mga KAPHC, Pwede pahelp? Ano mali dito sa query ko sa mysql. Select usual.emp_id, lastname, firstname, comm_count From tbl_employees b inner join (SELECT emp_id, COUNT(*) AS comm_count FROM tbl_performance WHERE perf_category = 'Commendation' AND YEAR(perf_datetime) =...
  22. H

    Closed How to connect finger scanner in web app?

    Mga sir good day. may way ba para maconnect yung plug and play ko na biometrics sa web app ko? gawa siya sa javascript at php,mysql.
  23. V

    Closed Secured mysql

    mga boss, anong pinaka secure na mysql na pwede gamitin sa c#? thanks in advance :)
  24. D

    Closed Ano error guys at pano po eto ifix ? need help lang po talaga, thank you.

    Error SQL query: CREATE TABLE `orderdetails` ( `order_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL DEFAULT '0', `order_name` varchar(1000) NOT NULL DEFAULT '', `order_price` double NOT NULL DEFAULT '0', `order_quantity` int(10) unsigned NOT NULL DEFAULT '0'...
  25. D

    Closed Ecommerce site using php/mysql

    baka meron kayo dyan guys , need ko lang po sana.. deadline na kasi this week..
  26. H

    Closed Mysql system variables settings.

    Mga sir good day. sa company kasi namin parang madalas mag error sa system tapos nakalagay "mysql gone away" or minsan "connection time out". may kinalaman kaya yun sa mga settings na andito sir?
  27. H

    Closed What to do if mysql server hangs

    Mga sir gusto ko lang sana magtanong kung ano ang best way na gawin kung biglang nag hang yung mysql server niyo at di makagamit ng system yung buong company dahil ang hang nga? samin kasi ginagawa lang nirerestart talaga yung server. pero gusto ko sana malaman if may iba bang way?
  28. 2

    Closed Xampp

    Pa Help Naman Po. Pa ano ma-access ang xampp from another computer
  29. T

    Closed Mysqli selecting a same date in database

    SELECT r_date FROM reservation WHERE r_date >= '2018-01-01' AND r_date <= '2018-12-31' AND r_date = r_date SELECT r_date FROM reservation WHERE r_date >= '2018-01-01' AND r_date <= '2018-12-31' AND r_date = r_date Try ko na tong dalwang query kaso yung result hndi equal yung nilalabas. Lahat...
  30. N

    Closed Paturo po php/mysql

    ppaano po siya idisplay yung data reservation by customer login ito yung database ko clients database client_id first_name surname title street_addr city province zip country phone fax email password id_type id_number additional_comments ip existing_client xx bookings database ito yung...
  31. A

    Closed Patulong mga boss

    I have a vpn panel, and already hosted, pero seperated ang database, sa isa g server ng vultr nakalagay, Ang tanung boss, pwedi ko kasi malipat ang database ki sa hosting site kasi meron itong php ny admin, kaso d ko alam kong anung host ang ilalagay ko sa mga servers da da app ko... Ang...
  32. S

    Closed Helpp java , mysql

    java.... gusto ko sana idisplay yung data sa jtable after ma display yung primary key sa textfield pano kaya yung query nun paps?
  33. H

    Closed Select max date for each type for each employee

    mga sir ganto kasi table struct ko. |emp_id| type | date | amount ---------------------------------------------------------------- | 1 | transpo | 2018-06-01 | 50 | 1 | others | 2018-06-01 | 50 | 1 | grade | 2018-06-01 |...
  34. F

    Closed Paano pasukin yung mysql based na program without administration?

    Pashare nman po.
  35. 2

    Closed Pa help po sa codes using c#and mysql

    paano yung sa 2 tables na nagkacount yung column tas pagmamayminusin pareho para makita yung items remaining
  36. N

    Closed Paano to ma fix windows sql 2008 r2 ayaw ma install after mag brownout naputol install.

    Sino nakaencounter na ng ganito sql 2008 r2, ayaw mag continue after mag accept license. Nung una nag install okay sya nasa input password na ako pero biglang nag brownout tapos balik ulit ako ayun di na nag continue. How to fix it po sa mga nakaencounter wala kasi sa google at utube.
  37. M

    Closed Php and mysql not updating in row 2

    Hi po pahelp naman po working good naman po ung code nea sa row 1 nakakapgupdate ako ng data kaso po kapag nilipat ko na sa row 2 wala ng pong data na lumalabas pati sa row 3 and so on hanggang row 1 lang po cya gumagana. Maraming salamat po sa tutulong :) <?php $sql =...
  38. J

    Closed Pahelp naman po sa ascending na code hahahaha

    Pahelp naman po medyo lutang na po talaga ako sa mga puyatan gusto ko po sana i order siya ng ascending by name so ginawa ko siya pero nauuna ang grade 10, ang balak ko sana ay nasa pinakahuli ang grade 10 at grade 7 ang una sana po may makatulong
  39. S

    Closed Sql join

    Hello dyan? hahaha matagal tagal na rin. pero anywys tama yang nababasa nyo sql join and ituturo ko sainyo ngayon. ano nga ba ito? ayon sa wikipedia ang sql join daw ay "An SQL join clause combines columns from one or more tables in a relational database. It creates a set that can be saved as a...
  40. X

    Closed Pa help po plss

    pano po gumawa ng modal sa dynamic tabs ko plss help
  41. J

    Closed Mysql database tutorial for biggeners

    http://inpics.net/mysqlbasics.html
  42. K

    Closed Self study about pusher.com/ real time notification

    Sino po may alam sa pusher.com dito? Naka sign up nako sa pusher.com and nalagay ko na yung script sa php code, and everytime na nag De'debug console nako e okay naman notif. ang tanong ko is pag may noti e pwede iclick yung noti para matignan kung ano yung notification nayun.
  43. C

    Closed Murach's book collection

    Book Tutorial authored by Joel Murach Don't forget to say thanks and like this post if it helped you.
  44. I

    Closed Programming again

    What languages would you guys suggest for me to study so I can contribute in this group? It has been a while since i did a program. :)
  45. K

    Closed Android and web developer

    Mga ka ph, help naman po sa mga android and web dev dyan. Sa thesis po kase nmin ang user is gagamitin nya is Android app, tapos yung admin is website Online pareho. Ano pwd pag aralan or isearch sa google nun? May alam nman kmi pano gumawa ng app using Android Studio, and naturo din naman yung...
  46. K

    Closed E-learning

    Sir baka matutulungan nyo ako sa pag gawa ng e learning, thesis ko lang po, website kase. Sana my mabait na tumulong. Need lang talaga huhu
  47. R

    Closed Help: capstone project

    Pwede po magpatulong kung paano gumawa ng archive saka database backup sa C# para sa lan-based voting system namin? MySQL po yung db namin. Kahit po idea lang sana, kasi di ko po alam kung saan magsisimula eh.
  48. R

    Closed Help: capstone project

    Ok na po. hehe. salamat po sa tumulong
  49. D

    Closed Pahelp po

    Pede po bang patulong kung pano gumawa ng Online Election System? May link ba kayo na madaling intindihin ang mga sinasabi nila? Pahelp sana. Salmaat
  50. Z

    Closed How to install lampp in ubuntu 14.04

    Need help mga master! how to install OLD version of lampp in ubuntu?? I just need a lampp with mysql 4 and php 4.2 or above Di ko maparun old website
Back
Top