john6384 Posted October 29, 2005 Share Posted October 29, 2005 Hello, I need to setup a simple sql database in order to test some queries out. What is the simplest way to set one up? I did try a free hosting package and using the phpmyadmin although that was very slow and crap. Is there any cool ways I can do this? Thanks anyone Quote Link to comment https://forums.phpfreaks.com/topic/2758-sql-newbie-needs-help/ Share on other sites More sharing options...
obsidian Posted October 29, 2005 Share Posted October 29, 2005 phpmyadmin is one of the best tools for newbies to start with, although learning to create SQL statements yourself for creating tables is also extremely helpful. i would recomend using phpmyadmin, but using the SQL entry tool and creating simple tables yourself: [!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--]CREATE TABLE testTable( id int(11) auto_increment PRIMARY KEY, name varchar(150), email varchar(150) UNIQUE ); [!--sql2--][/div][!--sql3--] good luck! Quote Link to comment https://forums.phpfreaks.com/topic/2758-sql-newbie-needs-help/#findComment-9234 Share on other sites More sharing options...
john6384 Posted October 29, 2005 Author Share Posted October 29, 2005 Thanks is there not anything else that I can use - i dunno maybe i could upload something? I managed to make a table in phpmyadmin although its slow and i cannot figure out how to enter data into the table. I tried to get a free version of oracle (big file). Cheers Quote Link to comment https://forums.phpfreaks.com/topic/2758-sql-newbie-needs-help/#findComment-9236 Share on other sites More sharing options...
obsidian Posted October 29, 2005 Share Posted October 29, 2005 Thanks is there not anything else that I can use - i dunno maybe i could upload something? I managed to make a table in phpmyadmin although its slow and i cannot figure out how to enter data into the table. I tried to get a free version of oracle (big file). Cheers 312543[/snapback] oracle is a totally separate database, not a tool for mysql. the speed of phpmyadmin is really dependent on two things: your server and your connection speed. if you're not using broadband, it will be slow. there are no other free tools that i know of that are going to run any faster than this for an online tool. you can get some desktop apps that will interface with your mysql databases, but these can be tricky to setup. the speed difference may make up for the difficulty in your case, though. just run a google search on mysql tools and see what you can come up with. Quote Link to comment https://forums.phpfreaks.com/topic/2758-sql-newbie-needs-help/#findComment-9238 Share on other sites More sharing options...
john6384 Posted October 29, 2005 Author Share Posted October 29, 2005 I had a look on google but did not have much luck. I dont realy know what im looking for. Maybe you could give me a better idea of what im looking for. I just need to write a simple database and then do queries on it- i wish it was as simple as access. cheers Quote Link to comment https://forums.phpfreaks.com/topic/2758-sql-newbie-needs-help/#findComment-9243 Share on other sites More sharing options...
Barand Posted October 29, 2005 Share Posted October 29, 2005 Go to the downloads section at mysql.com and get the Administrator and Query tools - for free. Quote Link to comment https://forums.phpfreaks.com/topic/2758-sql-newbie-needs-help/#findComment-9247 Share on other sites More sharing options...
john6384 Posted October 29, 2005 Author Share Posted October 29, 2005 That helps, although when I use the mysql admin I get an error 1130 telling me I cannot connect to the database. Ill try a different hosting. Do only some hostings work - does anyone know any? Thanks Quote Link to comment https://forums.phpfreaks.com/topic/2758-sql-newbie-needs-help/#findComment-9250 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.