mysql - Merge two different sql file to one -

-

i have 2 .sql file mysql database same tables different rows.

how can make 1 .sql file datas of other two?

if files contain data (dml - selects, inserts etc.), can join them via notepad. both of files must contain same table (the same columns)!


Comments

Post a Comment

Popular posts from this blog

python - No exponential form of the z-axis in matplotlib-3D-plots -

-
Image
i have similar problem described in how prevent numbers being changed exponential form in python matplotlib figure : i don't want (in special case) weird scientific formatting of axis. problem different have problem @ z -axis. 2-d plots can use ax.get_yaxis().get_major_formatter().set_useoffset(false) . , there no function ax.get_zaxis() what use format z -axis same way? edit: example: from mpl_toolkits.mplot3d import axes3d import numpy np import sys import matplotlib import matplotlib.pyplot pyplot def func(xi, ti): res = 10e3 + np.cos(ti) * np.sin(xi) return res if __name__ == '__main__': timespacing = 20 timestart = 0 timeend = 1 time = np.linspace(timestart, timeend, timespacing) widthspacing = 50 widthstart = 0 widthend = 3 width = np.linspace(widthstart, widthend, widthspacing) reslist = [] matplotlib.rcparams['legend.fontsize'] = 10 fig = pyplot.figure() ax = fig.gca(projection = '3d...
Read more

asp.net mvc - Cannot display error message on Editor or EditorFor -

-
in mvc application, can display error messages inputs i.e. textboxfor , dropdownlist , etc. however, using same approach, cannot show validation error kendo().editor() or kendo().editorfor() . tried validationmessage beside validationmessagefor , not make sense. might problem be? view: <script type="text/javascript"> $(function () { //for using kendo validation: $("form").kendovalidator(); }); </script> //validation works textboxfor, dropdownlist, etc.: @html.labelfor(m => m.summary) @html.textboxfor(m => m.summary, new { maxlength = 50, @class = "k-textbox"}) @html.validationmessagefor(m => m.summary) //validation not work editor or editorfor: @html.labelfor(m => m.description, new { maxlength = 1000, @class = "editor-label" }) @(html.kendo().editor() //@(html.kendo().editorfor(m=>m.description) //also tried .name("description") .htmlattributes(new { @class...
Read more

portaudio - How to enable WASAPI exclusive mode in pyaudio -

-
i'm using these precompiled binaries of pyaudio wasapi support. want play wav file via wasapi. found index of default output device api: import pyaudio p = pyaudio.pyaudio() print p.get_host_api_info_by_index(3) >>{'index': 3, 'name': u'windows wasapi', 'defaultoutputdevice': 11l, 'type': 13l, 'devicecount': 3l, 'defaultinputdevice': 12l, 'structversion': 1l} then play wav file via device: import pyaudio import wave chunk = 1024 wf = wave.open('test.wav', 'rb') # instantiate pyaudio (1) p = pyaudio.pyaudio() # open stream (2) stream = p.open(format=p.get_format_from_width(wf.getsampwidth()), channels=wf.getnchannels(), rate=wf.getframerate(), output_device_index=11, output=true) # read data data = wf.readframes(chunk) # play stream (3) while data != '': stream.write(data) data = wf.readframes(chunk) ...
Read more