The autofill feature
extends a sequential series of data
automatically adds range of cell values
applies a boarder around the selected cells
all of the above

The autofill feature a) extends a sequential series of data b) automatically adds range of ... B. automatically adds range of cell values. C. applies a boarder around the selected cells

answer:

cuddy aftertastes study

explanation:

cda gucci street cubby

select @yourvariablename − = @yourvariablename+1 anyaliasname,

yourcolumnname1,yourcolumnname2, from yourtablename ,

(select @yourvariablename − = 0) as yourvariablename;

to understand the above syntax, let us create a table. the query to create a table is as follows −

mysql> create table tblstudentinformation

-> (

-> studentname varchar(20),

-> studentage int,

-> studentmathmarks int

-> );

query ok, 0 rows affected (0.68 sec)

insert some records in the table using insert command. the query is as follows −

mysql> insert into tblstudentinformation values('carol',23,89);

query ok, 1 row affected (0.18 sec)

mysql> insert into tblstudentinformation values('bob',25,92);

query ok, 1 row affected (0.22 sec)

mysql> insert into tblstudentinformation values('john',21,82);

query ok, 1 row affected (0.15 sec)

mysql> insert into tblstudentinformation values('david',26,98);

query ok, 1 row affected (0.21 sec)

display all records from the table using select statement. the query is as follows −

mysql> select *from tblstudentinformation;

the following is the output.

| studentname | studentage | studentmathmarks |

| carol | 23 | 89 |

| bob | 25 | 92 |

| john | 21 | 82 |

| david | 26 | 98 |

4 rows in set (0.00 sec)

the following is the query to generate the serial number in mysql query −

mysql> select @serialnumber − = @serialnumber+1 yourserialnumber,

-> studentname,studentage,studentmathmarks from tblstudentinformation,

-> (select @serialnumber − = 0) as serialnumber;

here is the output displaying the row number in the form of serial number.

| yourserialnumber | studentname | studentage | studentmathmarks |

| 1 | carol | 23 | 89 |

| 2 | bob | 25 | 92 |

| 3 | john | 21 | 82 |

| 4 | david | 26 | 98 |

4 rows in set (0.00 sec)