Subject Doubt

[SonyVaio]

insert into tablename
values 121,222,111

idi correct ahaa?
leka kachitanga values bracket lo undalaa?
antay
values (121,222,111) ila undala?

[LOGON]

rendu try chei.. edi aithe ade [img]http://lh3.ggpht.com/--o7mXz3u-j4/T9VVBGzBJAI/AAAAAAAAGo0/kmj8a1-XW2g/s150/PK-1.gif[/img]

[JUJUBI_JULABI]

[img]http://www.desigifs.com/sites/default/files/CroppedBrahmishock_zps694518cc.gif?1350460826[/img]

[ghazni]

SQL aitey bracket lo undali

[SonyVaio]

[quote name='LOGON' timestamp='1359330307' post='1303187284']
rendu try chei.. edi aithe ade
[/quote]

try cheyalantay na dagara Management Studio ledu

[SonyVaio]

******When a GROUP BY clause is included in an SQL statement,.... only those columns with a single value for each group can be included
true/false?

[SonyVaio]

[quote name='ghazni' timestamp='1359330404' post='1303187292']
SQL aitey bracket lo undali
[/quote]

thanks

[LOGON]

http://www.w3schools.com/sql/sql_insert.asp

[ghazni]

[quote name='SonyVaio' timestamp='1359330515' post='1303187297']
******When a GROUP BY clause is included in an SQL statement,.... only those columns with a single value for each group can be included
true/false?
[/quote]
False.... not sure.. artam kaledu.

[LOGON]

quiz teeskuntunava...

[SonyVaio]

[quote name='LOGON' timestamp='1359330785' post='1303187307']
quiz teeskuntunava...
[/quote]
avunu, clg lo ee task undi
ikkada chala mandi sql vallu untaru kada ani adugutunna.

[mastikaraja]

brackets lo undali , make sure us specify the table columns before specifying the values if there are more columns than values you are inserting into the table.

insert into table (column1, column2,column3) values [color=#282828][font=helvetica, arial, sans-serif](121,222,111) [/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]if there are any char ('xyz','cvs')[/font][/color]

[SonyVaio]

[quote name='mastikaraja' timestamp='1359331263' post='1303187323']
brackets lo undali , make sure us specify the table columns before specifying the values if there are more columns than values you are inserting into the table.

insert into table (column1, column2,column3) values [color=#282828][font=helvetica, arial, sans-serif](121,222,111) [/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]if there are any char ('xyz','cvs')[/font][/color]
[/quote]
mari idi? any guess?

******When a GROUP BY clause is included in an SQL statement,.... only those columns with a single value for each group can be included
true/false?

[mastikaraja]

i think the datatype for the column specified is boolean means it takes only true or false


When you do group by specify group by i think we should have a aggregate function like sum.
http://www.tizag.com/sqlTutorial/sqlgroupby.php