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 on Trending Technologies
Technical articles with clear explanations and examples
What are the best websites a developer should visit?
Following are the best websites for a developer:RedditTutorialspoint.comTechCrunchTwitter MomentsCNetTwitter MomentsRedditDotNet KicksFeedlyHighScalability.comHacker News
Read MoreHow to find the MySQL data directory from command line in Windows?
To find the MySQL data directory, we can simply use the variable datadir. Let us see how to use the variable with select statement.The query is as follows −mysql> select @@datadir;Here is the output+---------------------------------------------+ | @@datadir | +---------------------------------------------+ | C:\ProgramData\MySQL\MySQL Server 8.0\Data\ | +---------------------------------------------+ 1 row in set (0.00 sec)Now we can reach the directory from the above sample output.Here is the snapshot that displays the MySQL data directory.
Read MoreSetting similar value for a column in a MySQL table?
You can set value for a column of all records with the help of update command.The syntax is as follows if you want set NULL value for all the records in a column −update yourTableName set yourColumnName = NULL;Or if you want to use empty string, the following is the syntax −update yourTableName set yourColumnName = ’’;To understand the above concept, let us create a table. The query to create a table.mysql> create table StudentDemo −> ( −> Studentid int, −> StudentName varchar(100), −> Age int −> ); Query OK, 0 rows affected (0.64 sec)The ...
Read MoreHow did Sony start and become one of the world leaders in the tech industry?
Sony Corporation is one of Japan's biggest multinational corporations, headquartered in Minato, Tokyo of Japan. It was founded by Akio Morita and Masaru Ibuka on 7th May 1946. It was during the wake of the World War-II. Sony’s first branded product was TR-55 Transistor radio that was launched in 1955, whereas Sony was made to be its official name since January 1958.It was Not-So-EasyEarlier, vacuum tubes were used, whereas, after the invention of transistors, the circuits became shorter and eventually the size of the equipment used got reduced. When TR-55 Transistor radio was launched which was made using a transistor, ...
Read MoreHow to take MySQL database backup using MySQL Workbench?
To make MySQL database backup using MySQL, first we need to install MySQL Workbench. Follow the below link to install MySQL workbench.https://dev.mysql.com/downloads/windows/installer/8.0.htmlAfter installing successfully, we need to open MySQL Workbench. Choose the option “Data Export”. Here is the snapshot.Select the database you want to export. You can also set the path here where you want to save the database.After successful completion, you can see the following screenshot.You have successfully created a backup of the above database. The following message is now visible.Export of E:\BackupDatabase has finished
Read MoreHow to integrate PayU Money in iOS using swift?
payU money is a payment gateway which is more popular in Indian online markets. To Integrate payU money we need to go through a few steps. Be careful with integrating payU and do not skip any of the steps of integration.Sign Up with payU money.Once you sign up, your key & salt, merchant ID will be generated which can be found in the dashboard after you login to your payU money account.After that in the terminal application, use the below code to clone payU money.Drag and drop the PlugNPlay folder to your project.$ git clone --recursive https://github.com/payu-intrepos/PayUMoney-IOS-SDK.gitNote − If you ...
Read MoreResolve an error whenever multiple rows are returned in MySQL Benchmark?
You will get an error whenever you return multiple rows in the benchmark. Return a scalar value or single row instead of multiple rows. The syntax is as follows −SELECT yourColumnName FROM yourTableName WHERE yourCondition.To understand the above syntax, let us create a table. The query to create a table is as follows −mysql> create table UserDemo -> ( -> UserId int, -> UserName varchar(20), -> RegisteredCourse varchar(10) -> ); Query OK, 0 rows affected (0.67 sec)Insert some records in the table using insert command. The query is as follows −mysql> insert into UserDemo values(1, ...
Read MoreWhat are some good tools to visualize MySQL database schema?
There are many tools to visualize MySQL database schema. Let us see some of them −SchemaSpyThis tool is based on java and can be used to analyze the metadata of MySQL database schema. Also use it to generate a visual representation of schema. A type of command line tool.The following are the featuresSupports most JDBC compliant DBMSGenerates ER diagram for foreign keysGenerates ER diagram for implied relationships (name, type) of a column matches a primary keyGenerates ER diagram for relationships based on rails naming conventionsShows column relationship and actionsShows routinesSchemaCrawlerThis is also a tool and an API that can be ...
Read MoreHow to keep the connection alive in MySQL Workbench?
To keep connection alive in MySQL Workbench, you need to reach at the following location −Edit -> Preferences -> SQL EditorHere is the snapshot of all the options.After clicking the “Edit” menu, we will select “Workbench Preferences” as shown below −Now, select SQL Editor and set an interval. You can also set the below options to set the connection alive in MySQL Workbench.DBMS connection Keep-alive intervalDBMS connection Read-timeout intervalDBMS connection Timeout intervalHere is the screenshot
Read MoreHow to insert multiple rows with single MySQL query?
You can insert multiple rows with the help of values() separated by comma(, ). The syntax is as follows −insert into yourTableName values(value1, value2, ...N), (value1, value2, ...N), (value1, value2, ...N), (value1, value2, ...N), (value1, value2, ...N), (value1, value2, ...N)................N;To insert multiple rows, let us create a table. The following is the query to create a table −mysql> create table MultipleRowsInsert −> ( −> UserId int, −> UserName varchar(200) −> ); Query OK, 0 rows affected (1.21 sec)Here is the query to insert multiple rows in the table −mysql> insert into MultipleRowsInsert values(100, 'Bob'), (101, 'Smith'), ...
Read More