Good teaching sir

Thank u so much sir,,, it helps me a lot

I have received clear information from you 😃

Sir How to connect mysql to normal java ie jdk 1.7.0-25 not for eclipse

Super sir You are also rocking.

@Kaalaratham

2 жыл бұрын

So nice of you

Good sir

Sir which set of commands is auto commit in sql..I mean whether DML or DDL

@grvasuiyer

2 жыл бұрын

DDL is by default auto commits in mysql. This auto commit future works for DML also

😍

how do get all the datas from database instead of indicating 1st row data,2nd row data,.....

@Kaalaratham

2 жыл бұрын

Use SELECT * FROM table_name to get all values from the table

@jayakumarj3367

2 жыл бұрын

@@Kaalaratham Sry sir,I think i am not properly explained my doubts. My question is ,You were writing commands as "system.out.println(rs.getInt(1)+"\t"+........."to show the particular rows datas.which command should be used in that place to show all the rows datas? .

@grvasuiyer

2 жыл бұрын

No direct method is ResultSet to show all the data. We need to iterated it using rs.next() method.

@jayakumarj3367

2 жыл бұрын

@@grvasuiyer Mm k sir thank you for your kind information

@kavingct

Жыл бұрын

@@jayakumarj3367 In the rs.getInt(1), 1 is not row number, it’s column number. The while(rs.next()) part will take care of looping through all rows returned by select query. Suppose if your first column name is ‘address’, then you can either use rs.getString(1) or rs.getString(“address”) to get the first column data. If you put System.out.println(rs.getString(“address”)); inside the whole loop it will print all the addresses returned by select query as the while loop will take care of the iteration.

Sir try to make videos in English

@grvasuiyer

2 жыл бұрын

Will do it ASAP