Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles by karthikeya Boyini
Page 87 of 143
What are the limitations of using MySQL views?
In spite of various benefits of using views there are following limitations on using MySQL views − Can’t create an index of views − In MySQL, we cannot create an index on views. It is because indexes are not utilized when we query data against the views. MySQL invalidates the view − Suppose, if we drop or rename tables to which a view references, rather than issuing an error MySQL invalidate the view. We can use the CHECK TABLE statement to check whether the view is valid or not. MySQL views cannot be updateable in some situations − Actually, the ...
Read MoreLocal Inner Class in C#
A nested class is a class declared in another enclosing class and it has inner as well as outer class. It is a member of its enclosing class and the members of an enclosing class have no access to members of a nested classLet us see an example code snippet of nested classes in C#.Here, class Two is a local inner class −Exampleclass One { public int num1; public class Two { public int num2; } } class Demo { static void Main() { One x = new One(); ...
Read MoreHow can we see the information on triggers order in case of multiple triggersnfor same event and action time?
It can be done with the help of the following query −mysql> SELECT trigger_name,action_order FROM INFORMATION_SCHEMA.triggers WHERE TRIGGER_SCHEMA = 'query' ORDER BY event_object_table,action_timing,event_manipulation; +------------------------------+--------------+ | trigger_name | action_order | +------------------------------+--------------+ | studentdetail_before_update | 1 | | studentdetail_before_update2 | 2 | +------------------------------+--------------+ 2 rows in set (0.10 sec)The above result set shows the order of multiple triggers created on the same event and action time in the database ‘query’.
Read MoreHow to list down all the files available in a directory using C#?
Firstly, use the DirectoryInfo object −//creating a DirectoryInfo object DirectoryInfo mydir = new DirectoryInfo(@"d:\amit");Now, use the GetFiles() method to get all the files −FileInfo [] f = mydir.GetFiles();To get the list of files in a directory, try to run the following code −Exampleusing System; using System.IO; namespace Demo { class Program { static void Main(string[] args) { //creating a DirectoryInfo object DirectoryInfo mydir = new DirectoryInfo(@"d:\amit"); // getting the files in the directory, their names and size FileInfo [] f = mydir.GetFiles(); foreach (FileInfo file in f) { Console.WriteLine("File Name: {0} Size: {1}", file.Name, file.Length); } Console.ReadKey(); } } }
Read MoreHow can we check the current MySQL transaction isolation level?
By executing SELECT @@TX_ISOLATION command we can check the current MySQL transaction isolation level.Examplemysql> SELECT @@TX_ISOLATION; +-----------------+ | @@TX_ISOLATION | +-----------------+ | REPEATABLE-READ | +-----------------+ 1 row in set (0.00 sec)
Read MoreHow to compile and execute C# programs on Mac OS?
To compile and execute C# programs on Mac, firstly you need to IDE. On MacOS, one of the best IDEs is Monodevelop.Monodevelop is an open source IDE that allows you to run C# on multiple platforms i.e. Windows, Linux, and MacOS. MonoDevelop is also known as Xamarin Studio.Monodevelop has a C# compiler to run C# programs. It can be used on Windows, macOS and Linux.For Mac, a special version of MonoDevelop was introduced and it was called Visual Studio for Mac. It has many of the features of what the same IDE provides for Windows like a tool for and ...
Read MoreUnderstanding Logistic Regression in C#
The Logistic regression is a linear model used for binomial regression. It is used in medical science and to predict a customer’s tendency to purchase a product. It makes use of predictor variables for this purpose.Logistic Regression allows easier analysis of results in the form of odds ratios and statistical hypothesis testing.A generalized linear model has taken input for a non-linear link function. The linear model has the following form −z = c1x1 + c2x2 + … cnxn + i = ct x + iHere,c is the coefficient vector, i is the intercept value x is the observation vector
Read MoreHow to print all the Armstrong Numbers from 1 to 1000 using C#?
To display Armstrong numbers from 1 to 100, firstly use a while loop.Examplewhile (val
Read MoreWhat is a managed code in C#?
Managed code is a code whose execution is managed by Common Language Runtime. It gets the managed code and compiles it into machine code. After that, the code is executed.The runtime here i.e. CLR provides automatic memory management, type safety, etc.Managed code is written in high-level languages run on top of .NET. This can be C#, F#, etc. A code compiled in any of this language with their compilers, a machine code is not generated. However, you will get the Intermediate Language code, compiled and executed by runtime.C/C++ code, called "unmanaged code” do not have that privilege. The program is ...
Read MoreChecked vs Unchecked Exceptions in C#
You can execute statements in C# in checked or unchecked context.In checked, the exception is raised by arithmetic overflow, whereas in unchecked context, arithmetic overflow is ignored.Checked ExceptionsUse the checked keyword to explicitly enable overflow checking for integral-type arithmetic operations and conversions. For this, just set the checked keyword.Overflow checking can be enabled by compiler options, environment configuration, or use of the checked keyword.res = checked(val + 10);Let’s say the value of val is 2147483647 i.e. the max value of int type. The above will raise an error since it is checked. This enables overflow checking at runtime.Unchecked ExceptionUse the ...
Read More