Psicopunk Posted January 4, 2008 at 04:47 PM Report Share #157808 Posted January 4, 2008 at 04:47 PM Boas, pessoal, estou a trabalhar em MySQL e tenho uma tabela criada com as tabelas: ID - Inteiro Longitude - Double Latitude - Double Index - Integer; e tb é primary key e auto incremental como é que posso apagar registos com base no valor do index daquela linha? tentei : delete from lamec.rota where Index = 3; mas dá-me um erro de sintaxe Cumprimentos Link to comment Share on other sites More sharing options...
RVG Posted January 4, 2008 at 05:04 PM Report Share #157814 Posted January 4, 2008 at 05:04 PM boax... Antes de mais, aconselhava-te a fazer uma pesquisa sobre palavras reservadas em sql. delete from lamec.rota where `Index` = 3 Link to comment Share on other sites More sharing options...
Psicopunk Posted January 4, 2008 at 05:10 PM Author Report Share #157818 Posted January 4, 2008 at 05:10 PM YA... ja reparei... era msm esse o prob... Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now