MySQL Import data to txt

Select fdate,fminute,ftotal,ft200, (ft200+0.0)/ftotal from t_switch_155 ORDER by FDate asc,fminute ASC to outfile ' 15 5.txt ';

Then open with Notepad, you can see the whole. If you open with txt, a newline character may not exist.

If TXT has a string condition, then

[FID MSG] = fopen (' t_server13.txt '); xx = Textscan (FID, '%d%d%s%d%d%d%d ', [7 inf]); Fclose (FID);

So xx is a variable containing 5 cells, through Xx{1} xx{2} and so on, you can take each column in turn.

For example, the SH script written under Windows can be executed under Linux and may go wrong.

Workaround:

The reason is: Windows line break symbol is "\ r \ n", and Linux is "\ nthe" no "\ R", when the shell file is written under Windows, all the newline characters are "\ r \ n", the shell is not able to execute this file, will prompt the above error. Please perform ' file format conversion '-WINDOWS in Notepad.

Then use Matlab xx=load ('. txt ').