Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
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 More
Python is an interpreter based language. However it internally compiles the source code to byte code when a script (.py extension) is run and afterwards the bytecode version is automatically removed. When a module (apart from the precompiled built-in modules) is first imported, its compiled version is also automatically built but saved with .pyc extension in __pycache__ folder. Subsequent calls to import same module again won't recompile the module instead uses the one already built.However, a Python script file with .py extension can be compiled expilicitly without running it. The 'py_compile' module contains 'compile()' function for that purpose. Name of ... Read More
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 More
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
The pyclbr module in Python library extracts information about the functions, classes, and methods defined in a Python module. The information is extracted from the Python source code rather than by importing the module.This module defines readmodule() function that return a dictionary mapping module-level class names to class descriptors. The function takes a module name as parameter. It may be the name of a module within a package. In that case path is a sequence of directory paths prepended to sys.path, which is used to locate the module source code.Following code uses readmodule() function to parse classes and methods in ... Read More
Cybercrime is the crime that is done using the internet and a computer or a phone or any other device as an instrument to cheat people, commit frauds, stealing intellectual property, violating privacy, stealing identities and diverting monetary transactions through the internet, female and child trafficking in pornography etc. Cybercrime has been very prevalent in the world today that almost everyone in the world is directly or indirectly affected by this. As the computer has become the gateway to the trade, banking, governance etc. Cybercrime is increasing by leaps and bounds.There are different types of Cybercrime that can be enlisted ... Read More
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 More
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 More
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 More
Use of 'zipimport' module makes it possible to import Python modules and packages from ZIP-format archives. This module also allows an item of sys.path to be a string naming a ZIP file archive. Any files may be present in the ZIP archive, but only files .py and .pyc are available for import. ZIP import of dynamic modules is disallowed.Functionality of this module is explained by first building a zip archive of files in 'newdir' directory. Following files are assumed to be present in newdir directory['guess.py', 'hello.py', 'impzip.py', 'mytest.py', 'prime.py', 'prog.py', 'tmp.py']import sys, glob import zipfile files = glob.glob("*.py") print (files) ... Read More