1
edit
Changes
no edit summary
* Change some of the records into the table you created:
UPDATE tmp SET bday = '1980-01-11' WHERE name = 'Xyz';
* Delete records from the table you created:
DELETE FROM tmp WHERE name = 'Xyz'
* How will you read records from in a plain text file into MySQL.
LOAD DATA LOCAL INFILE '/tmp/vyas.txt' INTO TABLE tmp;
You need to enable this to use it. Start your mysql like this:
'mysql --local-infile=1 -u root -p'
This should also be enabled from the server side.
