DBMS

Data base managment system

25 Oct 2013 by ZurdoDev

No. There are too many variables to be able to say. It will depend on your indexing, file system, the hardware, the processing power, etc.

CRUD Operations in IndexedDB using JsStore

9 Sep 2017 by Shaswat94

Create, Insert, Select, Update and Delete data in IndexedDB using JsStore

write a query to select the 5th higest salary record from table employee

20 Sep 2012 by VIPR@T

Hi,Please see the below article and review it. i hope you will get answer.http://blog.sqlauthority.com/2008/04/02/sql-server-find-nth-highest-salary-of-employee-query-to-retrieve-the-nth-maximum-value/[^]Thanks,Viprat

write a query to select the 5th higest salary record from table employee

20 Sep 2012 by Vijay Walunj,Navi mumbai

try this soln.it works i haved tridselect * from(select empId,salary,RANK() over (order by salary desc) as rank from Emp ) as pwhere rank=5

DATABASE MANAGEMENT SYSTEM

13 Oct 2013 by Zoltán Zörgő

Well, your question is quite vague, since if you speak about superkey, you can't just tell "key": there are key candidates, primary keys, foreign keys and so on... This is a topic that is addressed by all tutorials dealing with the relational model theory. You will need some level of linear...

How do I go about creating a DBMS project for a Hobby Club?

5 Nov 2014 by Peter Leow

This should give you some head start: Introduction to database design[^].As to specifically what goes into the database, it really depends on the application requirements and the business domain that it is going to serve. You have to find out from the users, not from us.

how to count total number of hours and days from date and time in sql querry?

27 Dec 2014 by OriginalGriff

Change your database.Stop storing dates and times as NVARCHAR, and stop storing them separately. Always store dates and times together, so they form a single "moment in time" in DATETIME variables.Then you can just use the DATEDIFF function[^] which returns what you want.If you store...

How Can I Create My Own "Database Management System"?

27 Jan 2015 by Peter Leow

If you insist, you may start by reading this:1. The nuts and bolts of DBMS construction: building your own prototype[^]2. Database System Implementation[^]In fact, I think it is too big a topic (or rather an off-topic) for this forum.

How to use global temporary table in oracle function

13 Dec 2015 by Jörgen Andersson

You cannot use DDL inside a function.Simply create the temp table and let it exist in your tablespace. All data you insert into it will be usable from that session only. So there is no need to create and delete it for every transaction.So you can just use:INSERT INTO store_sales select *...

Oracle

Regarding the normalisation in dbms

1 Sep 2018 by OriginalGriff

Quote: Why there is a rule in first normal form that all underlying domain contain atomic value? Because the goal of 1NF is that the same as the goal of all normalisation: to prevent the possibility of redundant data that can become out of sync (because if you store a customer address in two...

Count the no of record with condition in sqlserver ?

25 Jul 2019 by Patrice T

Filtering "under" is a wrong approach because it remove information about not "under". I would attack the problem with 2 cascading selects. The first do a synthesis of database: field CASEID field records: count(CASEID) field unders: sum(if(TYPE="UNDER", 1, 0)) select CASEID, count(CASEID) as...

SQL-Server-2014

SQL-Server

Given the table EMPLOYEE (empno, name, salary, designation, deptid) write a cursor to select the five highest paid employees from the table.

19 Apr 2021 by Dave Kreskowiak

No, this is your assignment, not ours. If you had something specific about a problem you're having, fine. Ask a specific question. If you think someone is going to do your work for you, you've come to the wrong site.

write a query to select the 5th higest salary record from table employee

20 Sep 2012 by Abhinav S

You can simply use the Tophttp://msdn.microsoft.com/en-us/library/ms189463.aspx[^] keyword.However, that is not the solution the interviewer would most likely be looking for.

LAB-Database Management System

22 Aug 2013 by Yesudasan Moses

This may help you...http://www.blackwasp.co.uk/SQLTransactions.aspx[^]

LAB-Database Management System

22 Aug 2013 by Mike Meinz

See Transaction[^]Transactions (Database Engine)[^] and links to other articles.Transactions and Concurrency[^] and links to other articles.

how to bind category then subcategory bind in single dropdown using asp.net or vb by store procedure?

How to increase the performance of Webites without cache?

10 Mar 2014 by Member 9714428

For example, If you take E commerce website.Every second data modifies or adds in to database.how they identity the data is modified or not.how they monitor fuse amount of data with modifications. and how to handle that data. in this case, is it possible to cache those data?

How to increase the performance of Webites without cache?

10 Mar 2014 by thatraja

This is not a simple thing, there's a lot of todo. Check this answerHow to improve performance of a website?[^]

19 May 2014 by abhishek burnwal Kolkata

My Table is-:Category fields are-: CategoryID, Category_Name, Category_Description 1 Science aaaaa 2 Language lllllSubCategory fields are-: SubCategoryID, CategoryID,...

how to bind category then subcategory bind in single dropdown using asp.net or vb by store procedure?

19 May 2014 by syed shanu

hi,Check this query : Select q.CategoryID,q.SubCategoryID,q.Category_NameFROM(Select CategoryID,0 as SubCategoryID,Category_Namefrom Category Union ALLSelect CategoryID,SubCategoryID,SubCategory_Name as Category_Namefrom SubCategory ) qorder by...

Msg 102, Level 15, State 1, Line 3 Incorrect syntax near ' + '. 5

25 Jun 2014 by Member 10690757

"select SUM(dr_amount)-SUM(cr_amount)" +"from Gl_Transaction where Accountno like'1%' select SUM(dr_amount)-SUM(cr_amount)" +"from Gl_Transaction where Accountno like'2%'" +"select SUM(dr_amount)-SUM(cr_amount)" +"from Gl_Transaction where Accountno like'3%'" +"select...

Msg 102, Level 15, State 1, Line 3 Incorrect syntax near ' + '. 5

25 Jun 2014 by Maciej Los

Adding spacebar does not help ;( Sorry, collegues... Even when OP change the code, this doesn't help too, because He/She will get SQL error. Do you know SQL? I'd suggest to strat with basics: SQL Tutorial[^]

Msg 102, Level 15, State 1, Line 3 Incorrect syntax near ' + '. 5

25 Jun 2014 by Mike Meinz

Your example looks like a C# statement although it is syntactically incorrect since there is no operator in the statement. In my solution below, I added a declaration for a string named mySQLStatement and an assignment to that statement of the concatenated strings that you included in your...

I have completed change url but after that any link click then exception occured?

10 Jul 2014 by abhishek burnwal Kolkata

In global page(vb code)Imports System.Web.SessionStateImports System.IOPublic Class Global_asax Inherits System.Web.HttpApplication Sub Application_Start(ByVal sender As Object, ByVal e As EventArgs) '...

Confusion with data base model creation

4 Dec 2014 by s#@!k

I am creating data base design for the below scenario and struck with a problem.I have Users, Projects, and Permissions{ex: read,Edit,delete} tablesThen,Problem: I have to give permission to users over projects.I Tried: http://s10.postimg.org/4kgq9uay1/Model.jpg[^] Please have a look...

Confusion with data base model creation

4 Dec 2014 by syed shanu

You can use Status column in both User and in Project Table.In your case a user group can have more than one User and in a Project Group more than one Project can available.If the permission (projected to user group or project group) is set to one project Group or User Group then all the...

Confusion with data base model creation

15 Dec 2014 by Jörgen Andersson

I'm late for the party it seems.Anyway, here's my take, use a simplified version of how Oracle have set up their own permission system. User and groups belongs in the same self referencing table with just a field setting that defines if it's a group or a user.You need to add logics that...

how to count total number of hours and days from date and time in sql querry?

27 Dec 2014 by Abhishek Burrnwal

how to count total number of hours and days from date and time in sql querry?My table Is-Id CheckInDate CheckInTime CheckOutDate CheckOutTime1 2014-12-28 09 : 29 : AM 2014-12-30 06 : 29 : AM2 2014-12-27 11 : 30 : AM 2014-12-30 12 : 30 : PMPlease...

How Can I Create My Own "Database Management System"?

27 Jan 2015 by OriginalGriff

This is too broad a question for us to answer in a small text box: so start with Google.Google: create my own "database management system"[^]Half a million results, most of them with some information.Work out what you need, then try to ask a more specific question. At the very least,...

How to create user profile page after login in an ASP.NET website

3 Mar 2015 by gaurav9822

I am creating a website project for patient healthcare.After user login,I want to make a new page where he can access all his records and all. How to do that in ASP.NET?? How do I manage user roles such as patient,doctor and admin????? Patient can only access his records and send messages to...

HTML

ASP.NET

How to create user profile page after login in an ASP.NET website

4 Mar 2015 by Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

The easiest way would be retrieving the Role of Logged In User like Patient or Admin. To store the Role of User, you could add a new Column to the User Table or create two new Tables like...UserRole Table (UserId, RoleId)Role Table (RoleId, RoleName)Then in Code Behind of the Page, which...

HTML

ASP.NET

DBMS Superkey indentification

16 May 2015 by Member 11695306

Hi all, I am doing some revision for a database module and I have come across this question in a past paper:Identify all the superkeys in the following table: ID First name Last name Age 1 Sean O'Connor 22 2 Tim O'Connor 27 3 Jack Black 32 ...

database

Reposting please help- dealing with tuple values in mysql

11 Jun 2015 by Peter Leow

This is trivial, study http://www.w3schools.com/sql/sql_where.asp[^] and you should be to construct the sql statement that meets your need.A template will help:select columns from table1 where pricecolumn >(select pricecolumn from table1 where namecolumn = "modelname")

MySQL-Connector

Creating new table vs adding new field

2 Aug 2015 by afzalex

I am having following data : Fabric Cost time | No fabric|BangloreSilk|Chanderi|....

Creating new table vs adding new field

2 Aug 2015 by DamithSL

I would have use 3 table1. FabricType2. FabricCost3. CostTypeCost type table you can have two entries now, you can add more in future if needed. Primary Key of Cost Type and FabricType can used in Fabric cost table record as foreign keys.

How do I write a query to display the name(s) of the user who has/have answered most number of queries, sorted by name.

How to amazon payments sandbox for developer in asp.net mvc?

19 Nov 2015 by John C Rayan

Follow this linkhttps://payments.amazon.com/help/Checkout-by-Amazon/Using-the-Checkout-by-Amazon-Sandbox/Overview-of-the-Sandbox[^]

6 Oct 2016 by David_Wimbley

Your going to have to give a lot more information about what your desired output is. You are probably not seeing what you want as you've got a HAVING clause in your query. Otherwise your query looks like it is probably correct.See example schema/data belowDECLARE @Users TABLE ( Id INT...

Which books are best for learning below computer science subjects?

18 Dec 2016 by Afzaal Ahmad Zeeshan

There are thousand books, thousand reviews and thousand rating. Each evaluating gibberish to 4.5. How can you evaluate a good book based on personal reviews? I might enjoy reading a book that you hate. So, basically start by understanding the concepts and then keep reading one book and...

system

Write SQL query of given questions

8 Jul 2017 by OriginalGriff

We do not do your homework: it is set for a reason. It is there so that you think about what you have been told, and try to understand it. It is also there so that your tutor can identify areas where you are weak, and focus more attention on remedial action. Try it yourself, you may find it is...

I need to create 2 tables for below data how to map between the data values

10 Oct 2017 by Member 13456434

i need to create 2 tables for below data how to map between the data values.As my data values are each of them are not unique cover_id , file , TestCase 256 , /x/eng/rlse/DOT//prod/common/raidv2/ric.c , test1 469 , ...

I need to create 2 tables for below data how to map between the data values

10 Oct 2017 by OriginalGriff

Create two tables Table1: CoverID INT Filepath NVARCHAR TestCaseID INT, foreign key to Table2 Table2: ID INT, IDENTITY caseName NVARCHAR

How to use global temporary table in oracle function

10 Nov 2017 by Member 13514037

I Have use below code and successfully work. Below statement for creation of global temporary table. CREATE global TEMPORARY TABLE xx_am_temp_tbl_emp2 on commit delete rows as select employee_id, first_name from XX_am_employees; Result : Global temporary TABLE created.

Oracle

How I can copy file from local folder to FTP server

30 May 2018 by Jochen Arndt

It depends on which application you are using for uploading files via FTP. Some of those applications can be scripted or support uploads with a single command line call. Then call such a script / command line from a batch (Windows) or shell (Linux) script, check the return value, and act...

Spatialite GUI new query window

24 Feb 2019 by RAHUL(10217975)

Hi, I am new to Spatialite version 4.3, I am using windows 10. I accidentally closed Query Window in Spatialite. I don't know how to bring it back so that I can write queries on it. I tried all menu options in Spatialite and searched in google too but no luck One of colleague told me to change...

Spatialite GUI new query window

20 Feb 2019 by Richard MacCutchan

You should try SpatiaLite: SpatiaLite[^] for assistance with their product.

Spatialite GUI new query window

24 Feb 2019 by RAHUL(10217975)

Remove Spatialite Windows registry settings will work.

Related to transaction in dbms

22 Jun 2019 by An@mik@

I know the Theory of transaction in DBMS. But I want to demonstrate the concepts of seriazibility , concurrency mechanism in transaction using practical. Like how in SQL we can perform different types of queries. How to perform practical of transaction concepts in DBMS? What I have tried: I...

Related to transaction in dbms

22 Jun 2019 by Afzaal Ahmad Zeeshan

Here you go, follow these links and study how they work—which as you mentioned, you already are aware of. database - Correct use of transactions in SQL Server 2008 - Stack Overflow[^] BEGIN TRANSACTION (Transact-SQL) - SQL Server | Microsoft Docs[^] Now, as you can see that a TRANSACTION...

Count the no of record with condition in sqlserver ?

25 Jul 2019 by Member 13047430

Accounts Table ------------------ cases| type | ------------------ A1 | UNDER ------------------ A1 | UNDER ------------------ B1 | OVER ------------------ B1 | UNDER ------------------ B1 | OVER ------------------ C1 | OVER ------------------ C1 | OVER ----------------- D1 |...

SQL-Server-2014

SQL-Server

Error inserting contactperson=null phone=null name=null aptno=null purpose=null.... Table visitortable has no column named contactperson

30 Aug 2020 by Sameen Kazi

package com.example.vistiorg; import android.content.ContentValues; import android.content.Context; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteOpenHelper; import android.util.Log; public class...

Create a stored procedure that accept the job from in parameter and show all employees of that job ?

6 Oct 2021 by OriginalGriff

At a guess, calling your SP the same name as a column in your table might be a problem: I'd give the SP a more sensible name ("GetEmployeesByJob" maybe) and probably rename the column as well, if it does contain a row ID value. My standard for ID...

I am not able to create any table because of this error could anyone help I have attached the code thanks in advance

20 Feb 2022 by Mohit Lakhwani 2022

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order( id INT PRIMARY KEY, amount INT NOT NULL, discount INT NOT NULL, date_orde' at line 1...

I am not able to create any table because of this error could anyone help I have attached the code thanks in advance

20 Feb 2022 by OriginalGriff

You can't call the table "order" - that's a keyword (as in SELECT ... ORDER BY ...) Change the table name to "Orders" and it should work.

I am not able to create any table because of this error could anyone help I have attached the code thanks in advance

20 Feb 2022 by M Imran Ansari

What is your database name? Normally the following error produce when we used hyphen (−) in the database name, which isn’t acceptable. You can use the way to create the table in your database: create table orders( id INT NOT NULL, amount...

I am not able to create any table because of this error could anyone help I have attached the code thanks in advance

20 Feb 2022 by Graeme_Grant

The best way to learn how to write this type of SQL is to use a Database Management tool. Create the table in the tool, then select the table and there will be a menu option (usually done by right-clicking on the table name) and it will generate...

I am trying to apply pagination with limit and offset in MYSQL but its not working can somebody help

27 Feb 2022 by Richard MacCutchan

I do not think that the expression (limit)*(@pageno-1) is accepted. You should calculate those values first and pass the result as a single parameter. See MySQL LIMIT[^].

How do I identify the partial key of a weak entity set?

25 Jul 2022 by Aditi Thakore

I've a weak entity set as follows: Medicine_reminder that have three attribute : start_date,dosage , and time I am unable to define the partial key for this. What I have tried: I thought of taking it as multivalued composite attribute but that...

How do I identify the partial key of a weak entity set?

25 Jul 2022 by Gerry Schmitz

Start_date is a partial key; the entity is not unique without the time (e.g. the prime key is date+time). The name medicine "reminder" provide a hint as to context. Partial keys are often used in "starts with" type searches, and can make use of...

How to get old value and new value after update trigger

19 Aug 2022 by OriginalGriff

Look at the documentation: MySQL :: MySQL 8.0 Reference Manual :: 25.3.1 Trigger Syntax and Examples[^] it's pretty clear: Quote: Within the trigger body, the OLD and NEW keywords enable you to access columns in the rows affected by a trigger....

Create a stored procedure that will display all transactions for a specific customer

15 Oct 2022 by OriginalGriff

Have you tried:SELECT * FROM MyTransactionsTable WHERE CustomerID = 'id of customer'

Kerosene Dynamic Data Services

11 Mar 2014 by mbarbac

Implementing the Repository and Unit of Work Patterns dynamically using Kerosene ORM

Advanced WPF TreeViews in C#/VB.Net Part 4 of n

22 Dec 2017 by Dirk Bahle

Tips & Tricks on loading and saving WPF Tree View based content.

SQL Server Performance Issue After An Upgrade

9 Dec 2019 by Kanishka Basak

Analysis and troubleshooting a database performance bottleneck

GraphQL: Evolution of Modern Age Database Management System

21 Aug 2019 by David Cuelogic

GraphQL: Evolution of Modern Age Database Management System

graphql

database

A Closer Look at Lookup Tables

20 Oct 2016 by Bryan Kowalchuk

The two most common database lookup table patterns are examined

To Replicate/Clone/Duplicate, selected data in SQL Server 2012, 2008

2 Mar 2013 by Syed Moula Ali

Replicate/Clone/Duplicate selected data in a Table using merge statment

Need the source code of contact management program

16 Nov 2015 by Afzaal Ahmad Zeeshan

No one would be spoon feeding you here. As far as I can understand this is a homework task assigned to you to test your skills for:1. Programming with C++2. Relational Database ManagementAnd most specially how good you are at software engineering. The only solution would be to go and...

VisualC++

C++

Difference between primary key, candidate key and super key in DBMS

1 Nov 2012 by WajihaAhmed

Super Key: An attribute or set of attributes that uniquely identifies a tuple within a relationCandidate key: A super key such that no proper subset is a super key within the relationPrimary key: The candidate key that is selected to identify tuples uniquely within the relation, the...

Difference between primary key, candidate key and super key in DBMS

5 Feb 2013 by hemant paul

Super Keys : Super key stands for superset of a key.A Super Key is a set of one or more attributes that are taken collectively and can identify all other attributes uniquely.Candidate KeysCandidate Keys are super keys for which no proper subset is a super key. In other words...

Difference between primary key, candidate key and super key in DBMS

4 Nov 2017 by Lion 2012

What is the difference between the terms primary key, super key and candidate key used in Database Management System - DBMS.I did google but couldn't distinguish them. The terms candidate key and primary key appear to be the same.

Difference between primary key, candidate key and super key in DBMS

8 Apr 2016 by manub22

Check this blog[^] Video[^]I'll take example of an Employee table:Employee ( Employee ID, FullName, SSN, DeptID)1. Candidate Key: are individual columns in a table that qualifies for uniqueness of all the rows. Here in Employee table EmployeeID & SSN are...

How to amazon payments sandbox for developer in asp.net mvc?

19 Nov 2015 by Abhishek Burrnwal

How to amazon payments sandbox for developer in asp.net mvc?How to create an account in (https://payments-sandbox.amazon.com) for developing purpose.Please to send the procedure integrate amazon payment.Also, how to know that access key id, account id, client id, secret key, amazon payment...

LAB-Database Management System

22 Aug 2013 by Member 10225600

What is a transaction? What are the steps involved in a simple transaction?

How do I go about creating a DBMS project for a Hobby Club?

5 Nov 2014 by Member 11208763

As the question states, I need to create a DBMS project for a Hobby Club for my university. I am needed to present modules, which would have respective tables which would then be normalized and so on and so forth. I don't have the faintest idea as to how to go about it.Please help. Anything...

DATABASE MANAGEMENT SYSTEM

13 Oct 2013 by Member 10333615

what is the Difference between key and super key .. i heared that both are same .. if so then why they are given two names like one boy have two name chintoo and pappu types

Data base managment system

25 Oct 2013 by shyqyri

Can somebody tell me which database management system works faster with recursion and why?

How to get old value and new value after update trigger

23 Aug 2022 by Randomuser787

Solved with inserted as i and deleted d

write a query to select the 5th higest salary record from table employee

20 Sep 2012 by Member 9239619

write a query to select the 5th higest salary record from table employee plz explain the query too

multiple value insert ,delete and update in store procedure & trigger

28 Oct 2014 by Soundararajan O M

i tried all insert, delete and upadte queries as single rows affectedi have tried insert MULTIROW insertion,deletion and updation i get confused, most of the refernces are give as likeInsert()Insert()Insert() for same procedure for delete...

SQL-Server-2008R2

stored-procedure

How Can I Create My Own "Database Management System"?

28 Jan 2015 by Member 11378804

how can i create my own "database management system" : Java platform.... So, basically I want to know that how can I initiate it ?

Reposting please help- dealing with tuple values in mysql

11 Jun 2015 by raj@hardWork

My tableCustno---Model---Amount1010-----Nokia---95001020-----Samsung--32001030-----Nokia--12001040-----Sony----82001050-----LG------2000now i want to display cellphones which has higher price than samsung.how do i do it ? please help thanks in advance.

MySQL-Connector

monitoring and recording internet usage activities

20 Nov 2015 by webprit

I have to develop a software that monitors and records internet activities for individual devices (Computers using windows 7/8 OS) within a workplace(40-50 computers).I need help and suggestions on how to develop this, any APIs or source could if available would help a lot.

How to use global temporary table in oracle function

10 Nov 2017 by Santhosh Kumar

Hi,I want to use a temporary variable in oracle function, but the function is not accepting the table, can any provide me the syntax to create and use temporary table in oracle function.I used following code in function create global temporary table store_sales on commit delete...

Oracle

How do I write a query to display the name(s) of the user who has/have answered most number of queries, sorted by name.

26 Oct 2017 by Member 12780090

I'm not getting the desired outputWhat I have tried:the code i have used isSELECT u.name FROM user as u, query as q WHERE u.id = q.user_id GROUP BY u.name HAVING COUNT(q.user_id) = 2 ORDER BY u.name;

How do I write a query to display the name(s) of the user who has/have answered most number of queries, sorted by name.

26 Oct 2017 by Member 13486869

SELECT u.name FROM user as u, query as q WHERE u.id=q.user_id and q.parent_id is NOT NULL GROUP BY u.name HAVING COUNT(q.user_id) = 2 ORDER BY u.name;

How I can copy file from local folder to FTP server

30 May 2018 by Akshay Gate

Hi, I have a text file on my local drive and I wanted to copy that file on FTP server, If it copied successfully then the file should move to the another folder called "Backup folder" and if it fails to copy then file should move to "Error Folder" on same drive, Can you help me to get out off...

How do I solve the job error

31 May 2018 by Akshay Gate

Hi, I have a scheduled job and it failed giving an error "Arithmetic overflow error converting numeric to data type numeric", please advice what should be the solution on this. Thanks in advance. What I have tried: I tried many ways, but it didn't solved

How to import CSV file with some null values

7 Jun 2018 by Akshay Gate

I have to import csv file, but some field contains null values in it.How to import such type of files in database table. Please help. Thanks in advance. What I have tried: I tried to I to import file using Bulk import statement , but I am getting an error of null values

Regarding the normalisation in dbms

1 Sep 2018 by An@mik@

I have one question in normalisation. Why there is a rule in first normal form that all underlying domain contain atomic value?? Why atomic value is required in database?? What I have tried: I read the book related to DBMS but Not get why atomic value rule is there. So help me.

Count the no of record with condition in sqlserver ?

25 Jul 2019 by OriginalGriff

Read the question again: you've missed a bit. It wants you to count every different cases value that has a type of 'UNDER', not a single value result: A1 2 B1 1 C1 0 D1 1 E1 1 To do that, you will need a GROUP BY clause. But it's your homework, so I'm not going to give you the code just like...

SQL-Server-2014

SQL-Server

Error inserting contactperson=null phone=null name=null aptno=null purpose=null.... Table visitortable has no column named contactperson

30 Aug 2020 by Garth J Lancaster

I can't pick anything obvious, unless the app is still finding a copy of the database left on the device/workspace One thing I'd say, is that (Golum voice) 'we hates SQL written like that' - its so error prone, and from a lot of personal...

Create a stored procedure that accept the job from in parameter and show all employees of that job ?

6 Oct 2021 by Member 15384921

cant be able to solve this question. What I have tried: create or replace procedure job(jobid varchar(10)) begin select * from employee where job= jobid; end//

I am trying to apply pagination with limit and offset in MYSQL but its not working can somebody help

27 Feb 2022 by Mohit Lakhwani 2022

I have made customer table no problem in that. mysql> SET @pageno = 2; Query OK, 0 rows affected (0.00 sec) mysql> select * from customer limit 2 offset (limit)*(@pageno-1); ERROR 1064 (42000): You have an error in your SQL syntax; check the...

How to get old value and new value after update trigger

23 Aug 2022 by Randomuser787

I want to take record of values updated in the main table everytime a user updates something i want old and new updated value side by side on every update they do. If at first they changed firstname the new and old values should be side by...

Create a stored procedure that will display all transactions for a specific customer

15 Oct 2022 by Masentle Mocheko

I tried to create it but it does not work so I need help to get through it What I have tried: I tried creating it, and it gives me errors I don't know where I went wrong