• Register

Recent posts tagged database

5 0 2 min.
In this article we will learn how to do simple MySQL operations using pre-defined queries.What is MySQL Stored Procedure?It is a pre-defined SQL query that is named to be used in PHP. The advantage of this method is its ability to be reusea...
posted 14 hours ago ahsanhanif99 109 points
12 0 1 min.
The terms database and relational database are commonly used interchangeably and most people think of these as the same thing. But, in fact, these are quite different and serve different purposes. Although, the function of both is to store data,...
posted 5 days ago Hafsa_Rao 28,538 points
14 0 4 min.
Hоw  tо  vаlidаte  usernаme  аnd  раsswоrd  frоm  dаtаbаse  in  ServletIn  this  роst,  we  will  leаrn  Hоw  tо  vаlidаte  usernаme  аnd  раsswоrd &n...
posted Jul 8 sakshi 886 points
3 0 9 min.
Hоw  tо  рорulаte  drор  dоwn  list  in  JSР  frоm  dаtаbаse  using  АjаxThe  best  рrасtiсe  is  seраrаting  соde  between  server  side  аnd  с...
posted Jul 6 sakshi 886 points
9 3 6 min.
 Hоw  tо  сreаte  dаtаbаse  in  MySQL  using  XАMРР Hi, in this post, we will study about How to create database in MySQL using Xampp. To create database in xampp, we use Phpmyadmin.what is рhрMyАdmin ...
posted Jul 2 sakshi 886 points
9 0 4 min.
In some cases, such as DBA, you are prompted to copy the schema and content of specific tables from one database to another in the same instance or a different SQL instance, such as copying specific tables from a production database to a DEV for test...
posted Jul 2 amna 113,234 points
7 0 3 min.
Models furnish an approach to collaborate with a particular table in your data set. They emerge from the case with assistant techniques for a large part of the standard ways you would have to communicate with an information base table, including disc...
posted Jul 1 amna 113,234 points
7 0 3 min.
How to rename a database from the terminalOpen a terminal window or access your server via SSH .On the command line , run the following command to create a database, replacing user with your MySQL username and new_d...
posted Jul 1 amna 113,234 points
18 2 2 min.
In C#, image files can be read as either File Stream from data path or Base64 string from data url and it can be convert into ByteArray. So there is sevaral option to store the image file into database.How to save image in databaseMethod 1: Store as ...
posted Jun 5 mhfaisal 415 points
6 0 1 min.
How to build a website with database functionalityHaving discovered the advantages of this type of website it behooves on you to get some insight on how to build a website for your business. Here are some steps and factors to consider: 1. C...
posted May 22 Sanjana Sagar 499 points
6 1 2 min.
ADO.NET follows an architecture, to make connectivity with database, which can be categorized into two modes:Connected ArchitectureDisconnected ArchitectureConnected Architecture:The connected architecture requires you to establish a connection to th...
posted May 21 Hafsa_Rao 28,538 points
0 0 2 min.
Making Database Accounts To make a database account for your websites, do the accompanying: Snap the Database Account subtab under the Administration tab. The Database Account screen opens. click Create. The Create Database Account scr...
posted May 20 amna 113,234 points
0 0 2 min.
By utilizing the Column name or Column record we can recognize a segment in an information table or data tableThe DataTables has two fundamental strategies for tending to segments as a name or with a segment file. A section is an upward arrangem...
posted May 20 amna 113,234 points
0 0 2 min.
Join is used to combine multiple tables, In this post, we are going to learn Different types of Joins available in the SQL and their SyntaxWhat is Join and why we need that?Join is the keyword used to combine multiple tables and their columns, we are...
posted May 17 Saravana 100 points
0 0 2 min.
SQL is a language used for accessing the database, In this post, we are going to learn basics of the SQL and databases.What is SQL and why we need that?SQL – Structured Query Language The database will store the data, SQL will be used...
posted May 17 Saravana 100 points
0 1 1 min.
What is a Relational DatabaseA Relational Database is a type of database that has a structure allowing us to be able to identify and to get access to data points that are related to other datapoint inside the database. Since it is based on the relati...
posted May 5 Tegra Balonga 500 points
0 1 2 min.
Packages and SetupSQLite comes pre-installed on Python versions 2.5 and up, so you can just import it.import sqlite3We can create and connect to the database with this line.# 'database' can changed with any valid stringconnect = sqlite3.conne...
posted Apr 21 maazmasood 100 points
0 0 7 min.
An attribute or a set of attributes that uniquely identifies an entity instance is called a key. It refers to a single field or a combination of fields. Its purpose is to access or retrieve data rows from the table according to the requirem...
posted Mar 21 Hafsa_Rao 28,538 points
0 0 8 min.
Q. _____ is a method for analyzing and reducing a relational database to its most streamlined form.Answer:NormalizationQ. which organizational function should set database standards?Answer:Database administratorQ. Normalization means that there are n...
posted Jan 20 Lalit Kumar 1,240 points
0 0 7 min.
Q. To remove blank lines that occur when a field is empty, change the value of the ____ property.can shrinkQ. A composite primary key can be defined using the CONSTRAINT phrase in which SQL command? A) SET TABLE B) CHANGE TABLE C) CREATE TABLE D) MOD...
posted Jan 20 Lalit Kumar 1,240 points