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 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. 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? 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. 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. Link to comment https://forums.phpfreaks.com/topic/286734-queries-question/#findComment-1471585 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.