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

0 vote165 views1 answer
Get last inserted primary key
SQL
1 vote115 views1 answer
Sqlite check if row exists
SQL
1 vote134 views2 answers
Create table if not exist
SQL
1 vote110 views1 answer
Mysql drop key
SQL
0 vote106 views1 answer
Change default schema sql server
SQL
0 vote136 views1 answer
Calculer pourcentage mysql
SQL
0 vote118 views1 answer
Utiliser sql ligne de commande
SQL
4 votes116 views1 answer
Mysql copy table with new name
SQL
0 vote113 views1 answer
Drop tables from local database postgres pgadmin
SQL
1 vote135 views1 answer
Mysql show long running queries
SQL