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 vanithasree
Page 5 of 6
How to allow a MySQL user account to connect from any host?
It is quite possible to allow a user account to connect from any host. To do so we need to create the user with the help of ‘%’ wild card character after @ character. Its syntax would be as follows −Use mysql; CREATE USER user_name@’%’ IDENTIFIED BY password;Here user_name is the name of the user we wish to make an account for.Password is the password we wish to make for user_account. With the help of this password, MySQL server will identify this user.ExampleIn the given example we are creating a user ‘Gaurav’ by using ‘%’ character so that it can be ...
Read MoreWhat kind of settings can we do to a text file by query while exporting the values from MySQL table into a text file?
While exporting the data from MySQL table to a text file we can use ‘FIELDS TERMINATED BY’, ‘ENCLOSED BY’, ‘LINES TERMINATED BY’ and other options too to put the values of fields in different settings of the text file. It can be illustrated with the help of the following example −ExampleSuppose we are having following data from table ‘Student_info’ −mysql> Select * from Student_info; +------+---------+------------+------------+ | id | Name | Address | Subject | +------+---------+------------+------------+ | 101 | YashPal | Amritsar | History | | 105 | Gaurav | Chandigarh | Literature | | ...
Read MoreWhat is the difference between UNIX TIMESTAMPS and MySQL TIMESTAMPS?
In MySQL, UNIX TIMESTAMPS are stored as 32-bit integers. On the other hand MySQL TIMESTAMPS are also stored in similar manner but represented in readable YYYY-MM-DD HH:MM:SS format.Examplemysql> Select UNIX_TIMESTAMP('2017-09-25 02:05:45') AS 'UNIXTIMESTAMP VALUE'; +---------------------+ | UNIXTIMESTAMP VALUE | +---------------------+ | 1506285345 | +---------------------+ 1 row in set (0.00 sec)The query above shows that UNIX TIMESTAMPS values are stored as 32 bit integers whose range is same as MySQL INTEGER data type range.mysql> Select FROM_UNIXTIME(1506283345) AS 'MySQLTIMESTAMP VALUE'; +----------------------+ | MySQLTIMESTAMP VALUE | +----------------------+ | 2017-09-25 01:32:25 | +----------------------+ 1 row in set (0.00 sec)The query ...
Read MoreWhat do the =+ and += do in Python?
The += operator is syntactic sugar for object.__iadd__() function. From the python docs:These methods are called to implement the augmented arithmetic assignments (+=, -=, *=, @=, /=, //=, %=, **=, =, &=, ^=, |=). These methods should attempt to do the operation in-place (modifying self) and return the result (which could be, but does not have to be, self).ExampleSo when you do something like −a = 5 b = 10 a += b print(a)OutputThis will give the output −15a is being modified in place here. You can read more about such operators on https://docs.python.org/3/reference/datamodel.html#object.__iadd__.The =+ operator is the same as ...
Read Morehow to shuffle a 2D array in java correctly?
Yes. Create a list to represent a 2D array and then use Collections.shuffle(list).Exampleimport java.util.ArrayList; import java.util.Collections; import java.util.List; public class Tester { public static void main(String[] args) { List rows = new ArrayList(); rows.add(new int[]{1,2,3}); rows.add(new int[]{4,5,6}); rows.add(new int[]{7,8,9}); System.out.println("Before Shuffle"); System.out.println("[0][0] : " + rows.get(0)[0]); System.out.println("[1][1] : " + rows.get(1)[1]); System.out.println("After Shuffle"); Collections.shuffle(rows); System.out.println("[0][0] : " + rows.get(0)[0]); System.out.println("[1][1] : " + rows.get(1)[1]); } }OutputBefore Shuffle [0][0] : 1 [1][1] : 5 After Shuffle [0][0] : 7 [1][1] : 2
Read MoreWhat is a Java class library?
Java is not dependent on any specific operating system so Java applications cannot depend on the platform dependent native libraries, therefore, instead of those Java provides a set of dynamically loaded libraries that are common to modern operating systems.These libraries provide –Container classes and Regular Expressions.Interfaces for tasks that depend on the hardware of the OS such as network and file access.In case, the underlying platform does not support certain feature of Java then, these libraries surpass that specific feature if needed.
Read MoreTaking schema wise backup in SAP HANA
Data backup in any RDBMS system comes under Data Persistence layer. SAP HANA holds the bulk of its data in memory for maximum performance, but it still uses persistent storage to provide a fallback in case of failure.When you refer a schema in database, it refers to a namespace in the database. It is not possible to take backup schema wise as you do for complete database.However it is possible to export a schema using below command −EXPORT "MY_SCHEMA".* AS BINARY INTO '/tmp/my_schema' WITH REPLACE;SyntaxEXPORT AS INTO [WITH ] [ ]Note that you shouldn’t take schema ...
Read MoreHow can we write MySQL handler, in a stored procedure, that throws an error message and continues the execution?
As we know that whenever an exception occurred in MySQL stored procedure, it is very important to handle it by throwing proper error message because if we do not handle the exception, there would be a chance to fail application with that certain exception in a stored procedure. MySQL provides a handler that throws an error message and continues the execution. To demonstrate it, we are using the following example in which we are trying to insert a duplicate value in a Primary key column.Examplemysql> DELIMITER // mysql> Create Procedure Insert_Studentdetails(S_Studentid INT, S_StudentName Varchar(20), S_Address Varchar(20)) -> BEGIN ...
Read MoreHow can we get an idea about the server performance from the output of MySQL?
After running a query, MySQL returns the number of rows and gives time in the output that shows how much it took for running that query. As for example, if we run the following querymysql> create table e1(id int); Query OK, 0 rows affected (0.23 sec)It is showing the time (0.23 sec).
Read MoreWith the help of function, how can we return the difference in Year, Month and Days between two date values?
We can create a function, which accepts the date values as its argument and returns the difference in year, month and days, as followsmysql> CREATE FUNCTION date_difference(Date1 DATE, date2 DATE) RETURNS VARCHAR(30) -> RETURN CONCAT( -> @years := TIMESTAMPDIFF(YEAR, date1, date2), IF (@years = 1, ' year, ', ' years, '), -> @months := TIMESTAMPDIFF(MONTH, DATE_ADD(date1, INTERVAL @years YEAR), date2), IF (@months = 1, ' month, ', ' months, '), -> @days := TIMESTAMPDIFF(DAY, DATE_ADD(date1, INTERVAL @years * 12 + @months MONTH), date2), IF (@days = 1, ' day', ' days')) ; Query OK, 0 ...
Read More