13 replies to this topic

[dcord]

I'm new here and don't know what everyone is all about. I am trying to learn SQL but am having troubles getting my database up and running. I guess I' may be dumb or something. taking on line tutorial classes but I think I am missing something to get my database to cooperate. is there and basic guide I can follow? if so where might I find it?

thanks

[WingedPanther]

Welcome aboard!

It depends a LOT on the type of database you're trying to get working. Firebird, MySQL, SQL Server, Oracle, Access, PostGreSQL, and many others exist, each one with different requirements to get working properly.

[James.H]

Hi dcord welcome to codecall!

[Vswe]

Welcome to codecall :)

[dcord]

right now I am using Mysql an open source because I am just now learning this. I cant seem to create a database or tables. I am thinking that what I am reading and trying to practice is leaving out some common commands that I should know. such as ';' at the end and beginning of any command I enter. I was told to write "create database LEARNSQL;" (without quotes of course) Once I do that I can not find the database that I supposedly created. also true with tables I get error code 1046 syntax error. My question: is there anywhere I can get simplified detailed instructions on how to enter commands? I know I need to open and close with ( ) but do I need to do that when I create a table or just when I add data? I think so far I am just confused. is there rules in any SQL program that states any command input has to have ; behind it? example CREATE TABLE EMPLOYEE_TBL; Once I create this table I cant use it because of error code 1046

help please

[WingedPanther]

Are you using a command-line utility, or something else? After you create a database you have to switch to using it. Also, you only need a ';' at the end of a statement.

[dcord]

yes I am using a command line client. also don't know how to switch to using my database
whenever I use ; at the end of a statement it says there is error code 1064 syntax error

[WingedPanther]

MySQL Commands

[dcord]

wow,
thank you for all your help. this last one I will print and keep handy. I appreciate your time and effort to help me
thanks again

[Guest]

[WingedPanther]

Not a problem. It's just knowing what to search for on Google :)

[Egz0N]

Welcome to CC !! :)