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
MySQL Articles
Found 3,543 articles
Convert timestamp coming from SQL database to String PHP?
To convert timestamp to string, use setTimestamp(). Let’s say the following is our input i.e. timestamp −$SQLTimestamp = 1600320600000;We want the following output i.e. Date string −2020-09-17 05:30:00At first, get seconds from Timestamp −$seconds = round($SQLTimestamp/1000, 0);Example Output2020-09-17 05:30:00
Read MoreHow to convert JS date time to MySQL datetime?
We can convert JS date time to MySQL datetime with the help of toISOString() function.Let us see an example of JavaScript.Example Web Page Design document.writeln(new Date().toISOString().slice(0, 19).replace('T', ' ')); Current Date is displayed above... OutputThe following is the output.2018-11-23 11:14:38 Current Date is displayed above...
Read MoreHow to convert Python date format to 10-digit date format for mysql?
While working with databases like MySQL, it’s necessary to store dates in a numeric format, especially for timestamps. MySQL commonly uses Unix timestamps, which are 10-digit numbers representing the number of seconds since January 1, 1970 (known as the epoch). The following are the different methods from the time and datetime modules to convert Python date formats into a 10-digit format (Unix timestamp) suitable for use with MySQL. Using mktime() Method Using strptime() + mktime() Combination Using timestamp() Method Using mktime() Method The mktime() method from ...
Read MoreCount the number of columns in a MySQL table with Java
In this article, we will learn how to count the number of columns in a MySQL table using JDBC. We will be using the ResultSetMetaData to get details of the table by using simple examples. What is ResultSetMetaData? The ResultSetMetaData is an interface that is present in the java.sql package. Using ResultSetMetaData, we can get information about the table, for example, what are the column names of each and every table, and how many columns are there?. To create the object for ResultSet: ResultSet rs=st.executeQuery("Select * from Student"); The executeQuery method writes the records, which are then stored in the ...
Read MoreHow to Connect to Mysql Server Using VS Code and Fix errors?
MySQL is a relational database based on Structured Query Language used to access and manage records in a database. MySQL is based on a client-server architecture that follows a request-response cycle. Clients make requests through GUI or command prompt using MySQL. Fixing Errors in MySQL Server Here are the steps to connect to the MySQL Server using VS Code - Open Visual Studio code. Go To -> extensions, search MySQL Open the extension called MySQL management tool and install it. Click on the ...
Read MoreDecimal vs Double vs Float in MySQL
When designing a MySQL database, selecting the right numeric data type is crucial for balancing precision, storage efficiency, and performance. Decimal, Double, and Float are three common numeric types, each serving distinct purposes. While Decimal offers exact precision for financial data, Float and Double handle approximate values for scientific calculations. This article explores their differences, use cases, and practical examples to help you make informed decisions. What is Decimal Decimal (or DECIMAL(M, D)) is a fixed-point data type designed for precise arithmetic, such as financial calculations. It stores exact numeric values with a specified precision (M = total ...
Read MoreWhat is the difference between CHAR and NCHAR in MySQL?
In MySQL, both CHAR and NCHAR are ASCII character data types used for storing text data, but they differ significantly in terms of storage, data representation, and performance. CHAR and NCHAR columns can have different collations, determining how strings are compared and sorted. The CHAR type typically uses the collation associated with its specified character set. On the other hand, NCHAR is intended for Unicode data and typically uses a collation that can handle Unicode characters, ensuring proper sorting and comparison. Understanding 'CHAR' in MySQL The CHAR data type is primarily used to store ASCII character data. It is a ...
Read MoreWhat MySQL returns if I insert invalid value into ENUM?
If strict SQL mode is disabled and we insert an invalid value (which is not in the list of permitted enumeration values) into ENUM, MySQL will insert an empty string instead of throwing an error. If strict SQL mode is enabled, MySQL throws an error when inserting invalid value. Invalid values without strict SQL mode Strict SQL mode is disabled by default. When it is disabled, if we enter an invalid value that is not in the ENUM list, it returns an empty string. Let us understand this by using the example below. Example In the below example we have ...
Read MoreUse a trigger to stop an insert or update in MySQL?
The MySQL trigger can be used to automatically terminate an INSERT or UPDATE operation if specific conditions are not met. This is achieved by adding logic to the trigger to detect incorrect data or violations of a rule. If the condition is satisfied, the SIGNAL statement is used to show a customized error message and terminate the procedure. Thus, it ensures that the database has valid, clean, and consistent data. For instance, if a value is being updated or inserted in the column beyond the allowed range, the trigger can stop the action and give a customized error message. ...
Read MoreWhat does DELIMITER // do in a Trigger in MySQL?
DELIMITER in MySQL Triggers In MySQL, a DELIMITER command changes the delimiter from its default value of semicolon (;) to another string like //. This is really useful when creating stored procedures or triggers that contain multiple SQL statements, which may also include semicolons. Why do we Change the Delimiter in MySQL When you declare a trigger, you have to write a few SQL statements that may also involve control flow statements like IF conditions, which include semicolons. Unless you change the delimiter, MySQL will consider the first semicolon to be the end of the declaration of the ...
Read More