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 AmitDiwan
Page 840 of 840
Add a column to a MySQL table which is the result of concatenation of text and value from another auto increment column?
For this, you can use LAST_INSERT_ID(). Let us first create a table −mysql> create table DemoTable ( UserId int(6) unsigned zerofill NOT NULL AUTO_INCREMENT, UserAutoIncrement char(100) default null, PRIMARY KEY(UserId) ); Query OK, 0 rows affected (0.72 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(); Query OK, 1 row affected (0.13 sec)Display all records from the table using select statement −mysql> select *from DemoTable;Output+--------+-------------------+ | UserId | UserAutoIncrement | +--------+-------------------+ | 000001 | NULL | +--------+-------------------+ ...
Read MoreHTML DOM Anchor text Property
The HTML DOM text property associated with the anchor tag () specifies the text part of an anchor tag. For example − Google. Here the text part is Google. Using the text property we can get or change the value of anchor text. Syntax Following is the syntax for − Returning the text property − anchorObject.text Setting the text property − anchorObject.text = sometext Example Let us see an example for anchor text property − Example site Click the button below to change the text content of ...
Read More