sql

SQL ( (listen) S-Q-L, "sequel"; Structured Query Language) is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS). It is particularly useful in handling structured data, i.e. data incorporating relations among entities and variables.
SQL offers two main advantages over older read–write APIs such as ISAM or VSAM. Firstly, it introduced the concept of accessing many records with one single command. Secondly, it eliminates the need to specify how to reach a record, e.g. with or without an index.
Originally based upon relational algebra and tuple relational calculus, SQL consists of many types of statements, which may be informally classed as sublanguages, commonly: a data query language (DQL), a data definition language (DDL), a data control language (DCL), and a data manipulation language (DML). The scope of SQL includes data query, data manipulation (insert, update, and delete), data definition (schema creation and modification), and data access control. Although SQL is essentially a declarative language (4GL), it also includes procedural elements.
SQL was one of the first commercial languages to use Edgar F. Codd’s relational model. The model was described in his influential 1970 paper, "A Relational Model of Data for Large Shared Data Banks". Despite not entirely adhering to the relational model as described by Codd, it became the most widely used database language.SQL became a standard of the American National Standards Institute (ANSI) in 1986 and of the International Organization for Standardization (ISO) in 1987. Since then, the standard has been revised to include a larger set of features. Despite the existence of standards, most SQL code requires at least some changes before being ported to different database systems.

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

    Help Making POS SQL or JSON

    Begginer lang ano po mas ok sa POS pang small sari2 store lang din nagiisip ako kung json based or sql ? pahingi advice Btw kung sarisari store lang naman mas ok kung offline? language used:vb.net
  2. 2

    Database Development Free eBooks (MySQL, MSSQL, etc.)

    Share ko lng mga Free PDF eBooks na ito for SQL/MySQL development references: Download Here: Hidden content Microsoft SQL Server Notes For Professionals SQL Notes For Professionals MySQL Notes For Professionals
  3. A

    Help PHP and SQL Parking management Web databased system

    mga paps baka meron kayo nito parang login form ?
  4. 2

    Java Eclipse di ma connect sa mysql

    Nag eclipse windows builder kami sa mga friends ko at di siya connect sa mysql ang error na connect kuno siya sa connectorj pero ang labas sa dalawa kung kumpare xx.refistration doesn't exist paki tulong guys sira na ang ulo ko
  5. T

    Help Sql script help po mga sir

    ito sample problem age : 5months weight : 65.5 grams gamit yang chart nayan, gawa kayo sql script, pano ma identiy yang weight na yan sa category Paano po iyan mga sir?
  6. W

    SQL Database

    Mga master, ano po ang sql neto? 1.) "Set the fname and lname of instructor A B to C D" 2.) "Remove from student table the student with fname A and lname B" Ganito ko ginagawa ko pero parang hindi maganda kasi humahaba at parang mali rin ang query ko dahil one query lng dapat sya... My Code...
  7. C

    Patulong po sa SQL DataBase

    Paano po pagsamahin yung apat na table? Need ko po yung result na magkakasama po sila at nasa tama po yung information ng bawat employee. Ito Ito po yung code ko. Wala pong error dyan. Need ko lang po mapagsama yung 4 tables. create database PDM; create table Employee(emp_num INT(11) PRIMARY...
  8. J

    Help PHP sql programming

    Mga sir patulong naman po.. ano po mali sa code .. May error po siya pag wrong password at username.. ito po yung code <?php @include 'config.php'; session_start(); if(isset($_POST['submit'])){ $name = mysqli_real_escape_string($conn, $_POST['name']); $email =...
  9. C

    PHP .

    .
  10. H

    PHP PHP SQL Insert

    Any idea paano mag insert ng Long text sa database like yung mga nandito sa forum yung mga thread nila gamit ang PHP? tpaos na retain pa yung format.
  11. S

    Visual Basic Vb.net ms sql

    Pa help po mga idol ayaw kase mag insert ng data sa table pag pipindotin ko ang add to list button1 :< Imports System.Data.SqlClient Imports System.Net Imports System.Security.Authentication.ExtendedProtection Public Class Form1 Private Sub PictureBox1_Click(sender As Object, e As...
  12. X

    Tutorial Microsoft Training: Office 365, Excel, SQL and Etc. Crash Course

    Learn Python online at your own speed with Udemy. Start right now with a fantastic deal. Join the millions of students from across the world who are already using Udemy to study. Take a Python training course from Udemy to upgrade your skills. Discover why millions of people trust our industry...
  13. M

    Baka pede makahinge files direct run na visual studio 2010

    Baka pede makahinge files direct run na visual studio 2010 ,naka chromebook(converted to windows) kasi ako 14gb local c: .balak ko i run sa external drive..Salamat mga lods hit like ko nalang...pag aaralan ko lang ulet
  14. V

    Databases Basic SQL Commands & Queries Every Programmer Should Know

    Databases form the backbone of the modern web. Every big or dynamic website uses a database in some way, and when combined with SQL commands (Structured Query Language pronounced as /ˈsiːkwəl/- "sequel"), the possibilities for manipulating data are really endless. There are many names for data...
  15. R

    PL/SQL/UNIX Banking Application (Help)

  16. B

    C# SYSTEM PROJECT

    Baka po may nagawa dito ng system project sa visual studio. Willing to pay po student price lang po sana 🥺
  17. F

    Help ERD Software

    Pa-help po mga sir kung ano gamit niyong ERD Software na UI-friendly. May nabasa ako na lucid chart kaso parang hindi ko trip 'yung UI baka may alam kayo na much better po. Thank you po sa mga tutulong. 🙌
  18. D

    PHP coders and MySQL

    Good day po sa inyo, ask lang po kung paano i-multiply yung result ng DATEDIFF sa price ng room po? bali yung PricePerNight is na sa roomcharges table and yung nakapaloob sa DATEDIFF is na sa rentals na table. Nacalculate naman niya kung ilang days yung na spend ng bawat customer, bali gusto ko...
  19. R

    Closed Patulong paps sa php

    patulong po baka alam niyo tong error na ito TIA errors: Warning[/B]: Undefined array key "usern" in C:\xampp\htdocs\obs_db\login.php on line 15 Warning: Undefined array key "passw" in C:\xampp\htdocs\obs_db\login.php on line 16 <!DOCTYPE html> <html> <head> <body bgcolor="lightgray"> <meta...
  20. R

    PHP 2 table for admin and user log in

    ask ko lang mga ser baka meron kayo alam sa login pag na pag user nang nag log in sa index mapupunta. at kapag admin naman deretcho sa admin panel <?php require('db.php'); session_start(); // If form submitted, insert values into the database. if (isset($_POST['UserName'])){ // removes...
  21. M

    Programming Course Materials

    For share mga sir, hoping na makatulong for aspiring programmer natin dito. LINK: https://drive.google.com/drive/folders/1SdkZuEAlHuRj3KihyEhUF2KxKe4REAJw?usp=sharing
  22. P

    Help Rdp :(

    ako'y nagbaba-sakali lang, baka may magbigay kahit 1month rdp ( windows server ). 😢 salamat agad ng sobra,
  23. 2

    (noob here) how to import sql database folder that has factories,migrations,seeds folders on it

    hello pa help po i cant really find tutorials on YøùTùbé on how explain importing these kinds of database instead of an sql file pag import lang po kase nang sql file alam ko sa mysql database
  24. V

    SQL injection Master Course

    🔰SQL injection Master Course🔰 ➖➖➖➖➖➖➖➖➖➖➖➖➖ CLICK HERE TO DOWNLOAD ➖➖➖➖➖➖➖➖➖➖➖➖➖ ➖➖➖➖➖➖➖➖➖➖➖➖ vbsfranZ ➖➖➖➖➖➖➖➖➖➖➖➖ ║▌║▌█║▌║ ▌█ ║▌║▌█ ║ ║ ║ ║▌║ ║
  25. P

    Help Php login form

    Patulong naman sa mga batak sa php and database jan. Yung login form ko kasing ginawa ang kailangan lang para mag log in is LRN lang. Nasa database ko lahat ng LRN,pero nasa dalawang table sila. My tables are "grade11" and "grade12". Ginawa kong ganto kasi gusto ko pag nag login yung isang user...
  26. P

    Help Sa mga Web developer or Programmer jan

    Ask ko lang sana if possible ba tong balak ko. Gumagawa kase ako ng voting system using html css and php. Yung webpage na gagawin ko is may limang section which is Home,Candidates,Partylists,Vote tsaka Results. Possible kayang yung Results section e viewable lang pag naglog in ka as an admin...
  27. M

    Tutorial SQL injection to test your web application security and how to prevent it

    Good day! Today, I'm going to share to you about SQL injection to test the security of your web application. Take note that this is for educational purposes only. First, let us know what really is SQL injection. SQL injection is a code injection technique in which malicious SQL statement is...
  28. F

    [HELP] MYSQL

    Sir pano po ba I-query ang 500 and above lang na value sa Quantity table?
  29. O

    MICROSOFT SQL SERVER 2016

    SQL Server 2016 is a version of Microsoft's relational database management system (RDBMS) that first became available in preview releases during 2015, with general availability on June 1, 2016. SQL Server 2016 is a sql -based database designed to support a mix of transaction processing, data...
  30. B

    Help sugarcrm

    May mga tut ba kayo dito mga paps ? salamat po in advance sa mga magagaling na programmer dyan.
  31. Z

    Help Help - attendance system php

    Paano po kaya yung isang button lang ng Log in at Log out. Pag nag log in yung user mag didisplay sa Time In then pag nag log in uli yung user sa time Out naman //log in <?php require_once 'admin/connect.php'; $student = $_POST['student']; $time = date("H:i", strtotime("+7 HOURS"))...
  32. S

    Tutorial Private dorks for sql injection

  33. N

    Mongodb - the complete developer's guide

    DOWNLOAD LINK http://gethubtunnel(.)com/programming_web_development Paki remove nalang ng parenthesis. That tutorial is all about Database using No SQL. Sana makatulong.
  34. P

    Help Php: urls

    Hi mga kuys, ask ko lang.. may project kasi kaming website sa school, tapos ung theme nya e parang student info system. May database, so question ko kung halimbawa may isang student na isasave ung url nung profile nya, icocopy nya ung link sa url right? pagka ganon ba dapat may kanyakanyang html...
  35. D

    Databases Mysql two where conditions

    Hello mga bossing, ano po kaya ang mali sa query ko? May search box po kasi ako, tas kailanga ko lang lahat ng results ay status='Active'. $query = "SELECT * FROM `firm` WHERE CONCAT(`fname`, `lname`, `age`, `position`) AND (status = 'Active') LIKE '%".$valueToSearch."%'"; Salamat po!
  36. R

    Help Mag seself taught

    Gusto ko po matoto pano gumawa ng database at gumamit ng MYSQL ano po ba una kong gagawin mga boss/madam. Beside sa mysql meron po ba ibang application to run sql
  37. C

    Compilation of programming pdf's

    Hello ! Para to sa mga gusto pa palawakin ang knowledge nila sa programming. Malaki ang naitutulong nito sa akin, and I'm sure makakatulong din ito sa iniyo :) Titles: .NET Framework Notes Algorithms Notes Android® Notes Angular 2 Notes AngularJS Notes Bash Notes C Notes C++ Notes C#...
  38. D

    Help Datepicker range to query db content

    Hello po, sinusubukan ko pong kumuha ng content sa db ko na pasok sa date range na napili ko sa datepicker(s) at display sa table. Ano po kaya yung mali sa query ko? <html lang="en"> <head> <title>List</title> <script src="jquery-3.3.1.min.js"></script> <script src="jquery.min.js"></script>...
  39. K

    Help 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.
  40. S

    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...
  41. J

    Databases Sir pahingi ulit ako ng tulong sa query thank you po

    paano ko ba e e search yung data na hinahanp ko like dictionary nag hindi nag babase sa id using sql sql,java,netbeans currently ang ginawa ko ganto select * from mytable where YEAR kaso gusto ko sa dalawang column ako mag basebase
  42. P

    Sqli challenge

    SQLi Challenge Target: http://www.canterburyct.org/department.php?id=11 Rules x Task Don't Harm the site Don't ask hints Don't change parameter Upload you DP Print your leetname database Version User Do dios PM me you query Solvers N1ghtmare Proof of challenge
  43. P

    Tutorial Sqli chall

    Rules x Task Level:Easy Print Your leetname Print Database Print version Do DIOS Link: http://www.jmtv.com/news.php?id=3 Proof of Challenge Solvers 1.apotoxin 2.n1ghtmare 3. 4. 5. 6. 7. 8. 9. 10.
  44. X

    Squid on vps digital ocean

    Tanong ko lang po nag setup ako squid proxy sa own server ko okay naman siya transparent kaso after 20-24 hours nag false sya or namamatay siya need ko pa irestart si squid sa console para lang bumalik. Ano po kaya solution dito? Cent os 7 pala server ko. Update: ako lang gumagamit ng squid...
  45. L

    Closed System making

    Guys para sa inyo, front end muna uunahin or backend?
  46. S

    Closed Sa mga web developers dyan !

    Mga kaPHC Pahingi naman po ng website online shop gamit PHP saka MySQL. Kasama sql dump. Pki zip nalang po. Kuha lang po kami idea para sa project namin. Maraming salamat po sa tutulong. ☺
  47. K

    Closed Sql joins cheat sheet

    Credits Moffat C.L ( 2009, February 3) Visual Representation of sql joins
  48. K

    Closed Sql cheat sheet

    Sql cheat sheet para sa mga nahihirapan kabisaduhin yung mga queries. Note hindi lahat ng queries nandito. Yung mga most commonly used queries lang SQL cheat sheet Pili nlang kayo kung ano gusto nyo dl. PDF,JPEG,ZIP PS. Kung estudyante ka wag mo to gamitin pag nag papa exam o nag papa...
  49. M

    Closed How to normalize in database up to 3nf?

    Pahelp po eto lang po talaga panggulo dito sa course namin di ko po maintindihan mga tuts.. Di ko din kasi talaga prime yung programming pero kahit papaano gusto ko matututo. Sana may makapag explain po sakin taglish din sana kasi medyo kamote po ako sa english. Thanks po mga programming pros!
Top