Desaster Posted December 21, 2013 Share Posted December 21, 2013 hello, I wanted to ask you if I can use the same the same sql strings for sqlite and mysql ? I saw this in a script and I wanted to know if I can use it in sqlite or not dbExec("UPDATE blabla SET hi=?, ho=?, oh=?, tit=?, cha=?, cho=?, titt=?, wfa=?, fwfn=?, wfwf=?, wfwf=?, wfw=?, wdwd=?, wdwd=? WHERE name=?", fe, ww, faw, waffa, wdaf, wfaf, wafa, wafwa, wafwaf, wafwfa, eafwfa, wafwf, faf, wfwf, wfwfw) Link to comment
Desaster Posted December 21, 2013 Author Share Posted December 21, 2013 an other question : is it possible to remove a column from a table and to rename it if yes wish funcs I can use Link to comment
pa3ck Posted December 21, 2013 Share Posted December 21, 2013 (edited) You'll need 'ALTER TABLE' http://dev.mysql.com/doc/refman/5.1/en/alter-table.html OR http://www.w3schools.com/sql/sql_alter.asp ( ALTER TABLE table_name RENAME COLUMN old_name to new_name ) Edited December 21, 2013 by Guest Link to comment
bandi94 Posted December 21, 2013 Share Posted December 21, 2013 Yes. MySQL and SQLite string's are the same. Link to comment
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