MySQL help

[senewimala1988]

Mata table ekak create karanna one MySQL valin to enter Name,Address,Contact No,Total price.Meka thama mama damma coding eka.Ekata error ekak enava.Mata eka correct karala denavada???Please!!!

create table Customer_Details(Name varchar(25),Address varchar(50),Contact_No int(10),Total_Price int(15));

 

[aiaio]

where s ur coding?

 

[senewimala1988]

where s ur coding?

Ai ban oya last satement eka!!!

 

[x-pert]

Database 1 select karalada inne?

And 'table' kiyana eka TABLE wenna ooni neda? (CAPS)

Mokakda ena error eka?

And ; ooni naha anthimata... (mathaka hatiyata.)

 

[senewimala1988]

Database 1 select karalada inne?

And 'table' kiyana eka TABLE wenna ooni neda? (CAPS)

Mokakda ena error eka?

And ; ooni naha anthimata... (mathaka hatiyata.)

OK i will try.Mama hithuwe MySQL case sensitive ne kiyala..Error eka hena digai poddak inna balanna type karanna!!!

 

[shiwankaswe]

net ake serach akak dapan
meke balapan www.codeproject.com

mata nam mathaka ne

 

[senewimala1988]

Database 1 select karalada inne?

And 'table' kiyana eka TABLE wenna ooni neda? (CAPS)

Mokakda ena error eka?

And ; ooni naha anthimata... (mathaka hatiyata.)

ERROR 1064:You have an error in your SQL syntax.Chace the manual that corresponds to your MySQL server version for rhe syntax to use near ' create table Customer_Details(Name varchar(30),Address varchar(

 

[x-pert]

OK i will try.Mama hithuwe MySQL case sensitive ne kiyala..Error eka hena digai poddak inna balanna type karanna!!!

Shit sorry machang. Case sensitive nadda kohida... Mathaka naha bung dan :S

okkoma patalila thiyenne MySql, PlSQL, T-SQL :S :S

Anyway balanna comma ekata passe space ekak deela.

like Name varchar(25),<space>Address varchar(50),<space>Contact_No int(10),

<space> kiyuwe type karanna newei ok... nikan space ekak...

 

[x-pert]

Poddak meaka balanna machang

http://www.w3schools.com/PHP/php_mysql_create.asp

and ooka balala hari yanneth naththam, mula idan codings okkoma denna balanna

Mula idan kiyuwe DATABASE ekak create karapu thana idan codings tika denna

 

[senewimala1988]

Poddak meaka balanna machang

http://www.w3schools.com/PHP/php_mysql_create.asp

and ooka balala hari yanneth naththam, mula idan codings okkoma denna balanna

Mula idan kiyuwe DATABASE ekak create karapu thana idan codings tika denna

create database SML;
create table Customer_Details(Name varchar(25), Address varchar(50), Contact_No int(10), Total_Price int(15));

Hadala thiyena data base ekak select karanne kohomada???

 

[x-pert]

create database SML;
create table Customer_Details(Name varchar(25), Address varchar(50), Contact_No int(10), Total_Price int(15));

Hadala thiyena data base ekak select karanne kohomada???

mysql_select_db(SML)

 

[kasunsankalpana]

create database SML;
create table Customer_Details(Name varchar(25), Address varchar(50), Contact_No int(10), Total_Price int(15));

Hadala thiyena data base ekak select karanne kohomada???

use database ............... ;

nede? his thanata database eke name eka

 

[x-pert]

use database ............... ;

nede? his thanata database eke name eka

anna hari. mehema leesyi wei

Thanks yaka malli

 

[senewimala1988]

use database ............... ;

nede? his thanata database eke name eka

Ethakota "mysql_select_db(SML)" nemeida???

 

[kasunsankalpana]

Ethakota "mysql_select_db(SML)" nemeida???

database eke name danme SML de?


create database SML;

use database SML;

create table Customer_Details (Name varchar(25), Address varchar(50), Contact_No int(10), Total_Price int(15) );

 

[x-pert]

Ethakota "mysql_select_db(SML)" nemeida???

mokada bung kaa gahanne?

OL AL wage newei oowa ithin

poddak karala balanna mokakda hari yanne kiyala...

ehema bari unoth google eke search paarak daanna

 

[senewimala1988]

database eke name danme SML de?


create database SML;

use database SML;

create table Customer_Details (Name varchar(25), Address varchar(50), Contact_No int(10), Total_Price int(15) );

Machan mama check kala.
Kalin hadapu database ekak use karaddi database kiyana word eka enne ne.
ex:
use SML

 

[senewimala1988]

Poddak meaka balanna machang

http://www.w3schools.com/PHP/php_mysql_create.asp

and ooka balala hari yanneth naththam, mula idan codings okkoma denna balanna

Mula idan kiyuwe DATABASE ekak create karapu thana idan codings tika denna

Thanx 4 da link.Eka godak useful vuna..Eth eka thanaka podi error ekak eke thiyenava..Anyway thanx all of you!!!

 

[kasunsankalpana]

Machan mama check kala.
Kalin hadapu database ekak use karaddi database kiyana word eka enne ne.
ex:
use SML

sory mata tikak waraduna
use database .............;
nemei
use .............. ;
enna ona

poddak inna man ekak hathala balanawa

 

[x-pert]

Thanx 4 da link.Eka godak useful vuna..Eth eka thanaka podi error ekak eke thiyenava..Anyway thanx all of you!!!

owu machang oowala waradi thiyanawa godak.

Hariyatama igena ganna ooni trial and error method eken thamai ElaKiri machang