Last mysql

Mysql get last row

SELECT fields FROM table ORDER BY id DESC LIMIT 1;

Mysql last year

SELECT * FROM my_table
WHERE YEAR(my_date) = YEAR(DATE_SUB(CURDATE(), INTERVAL 1 YEAR));

How to fetch data from database without last column

SELECT lastName,firstName FROM Customer
       WHERE lastName LIKE "B%"
         AND city = "Indianapolis"
         AND (phone LIKE "%8%" OR fax LIKE "%8%")

Source: dummies.com

Last mysql

//returns the last value
SELECT working_hours FROM employee ORDER BY name DESC LIMIT 1;

Similar codes

11 votes126 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
1 vote111 views1 answer
Altering the column name in MySQL to have a default value
SQL
2 votes103 views1 answer
Sql server find table name
SQL
3 votes103 views1 answer
Two selects in one query
SQL
3 votes122 views1 answer
Where id is in list sql
SQL
13 votes104 views4 answers
Mysql get last row
SQL
0 vote111 views1 answer
Dump db only triggers mysql
SQL
0 vote106 views2 answers
Oracle sql for each row
SQL
0 vote112 views1 answer
Initcap in mysql
SQL
23 votes113 views2 answers
Query to delete a database in mysql
SQL