jad3z Posted March 5, 2014 Share Posted March 5, 2014 Hey guys!! I need some help I have a project of mine in java that needs mySQL integration. I haven't worked with mysql before, so I need some simple queries 1. Return a list of tables 2. Add a table with x number of columns 3. Add x value to x column in x table 3. Remove x value from x column in x table 4. Edit x value from x column in x table Thanks for reading my my topic! Regards, Joey Quote Link to comment https://forums.phpfreaks.com/topic/286734-queries-question/ Share on other sites More sharing options...
gizmola Posted March 5, 2014 Share Posted March 5, 2014 Adding/altering tables are done with DDL commands (CREATE TABLE, ALTER TABLE). Listing tables is most easily done with the SHOW TABLES command. To actually manipulate an existing table, there is INSERT and UPDATE. In short, you need to learn basic SQL syntax. Quote Link to comment https://forums.phpfreaks.com/topic/286734-queries-question/#findComment-1471568 Share on other sites More sharing options...
jad3z Posted March 5, 2014 Author Share Posted March 5, 2014 Can you give me a example please? Quote Link to comment https://forums.phpfreaks.com/topic/286734-queries-question/#findComment-1471574 Share on other sites More sharing options...
gizmola Posted March 5, 2014 Share Posted March 5, 2014 Given what I provided, and a little googling and reading, you should have what you need. Quote Link to comment https://forums.phpfreaks.com/topic/286734-queries-question/#findComment-1471575 Share on other sites More sharing options...
kicken Posted March 6, 2014 Share Posted March 6, 2014 Can you give me a example please? It's all in the manual, start reading and come back if you have a more specific question. Quote Link to comment https://forums.phpfreaks.com/topic/286734-queries-question/#findComment-1471585 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.