<{p}>Choose two.<{br/}>You must export data from a set of tables in the world_x database.<{br/}>Examine this set of tables:<{br/}>Tables (country, countryinfo, location)<{br/}>Which two options will export data into one or more files?<{/p}>

【多选题】
A shell}> mysqldump world_x country countryinfo location }> mydump.sql
B mysql}> SELECT * INTO OUTFILE '/output/country. txt' FROM world_x.country; mysql}>; SELECT * INTO OUTFILE '/output/countryinfo. txt' FROM world_x.countryinfo; mysql}>; SELECT * INTO OUTFILE '/output/location. txt' FROM world_x.location;
C shell}> mysqlexport world_x country countryinfo location }> mydump.sql
D mysql}> CLONE LOCAL DATA DIRECTORY = '/var/lib/mysql/world_x/country'; mysql}> CLONE LOCAL DATA DIRECTORY = '/var/lib/mysql/world_x/countryinfo'; mysql}> CLONE LOCAL DATA DIRECTORY = '/var/lib/mysql/world_x/location';
E shell}> mysql --batch world_x.country world_x.countryinfo world_x.1ocation }> mydump.sql

查看更多