Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
CURIOUS
MySQL workbench 8.0 CE gives error code 1064 on using ? in prepared statement. Is there any alternative to ? in prepared statements?
Requirement : I want to prepare a statement in a stored procedure in the below format and then to execute that statement using different parameters which will differ in a loop:
The syntax used for preparing the statement is as below:
**PREPARE** statement **FROM** insert into table(attribute_one,attribute_two) SELECT attribute_1, ? values from ? ;
After preparing the statement, in a loop, values for the placeholders are set and statement is to be
executed.
Loop begins:
SET @value 1;
SET @value 2;
EXECUTE statement using @value_1,@value_2;
Loop ends
Output : But My_SQL workbench is throwing syntax error code : 1064 at PREPARE statement.
Could somebody please help me with this?
Programming & Design11 months agoWhich is the best institute in India for M.Sc. in Astrophysics(not for integrated M.Sc. PhD. which is the case for IIA,Bangalore,Karnataka)?
Can a B.Sc. Applied Science graduate pursue M.Sc. in Astrophysics?
What can be done after doing post-graduation in the same?
1 AnswerHigher Education (University +)5 years agoWhat is the binary equivalent of decimal number 2.3?
3 AnswersMathematics5 years agoWhy are electric wires made cylindrical in shape?
4 AnswersPhysics6 years agoDuring an experiment how many set of readings should be taken? Is it related to statistical error?
If yes how is statistical error calculated? How do we come to know the number of readings to be taken? Is statistical and standard error same?
2 AnswersPhysics6 years agoSPHERICAL COORDINATE SYSTEM! Can the direction of polar angle θ be obtained by right hand thumb rule?
Taking the cross product between any vector along z axis (say) zk^ and the radial vector (say) xi^ + yj^ + zk^, we will get the vector which is perpendicular to both these vectors. Is not the unit vector of the vector obtained after cross product, θ^?
Using x=rcosϕsin θ, y=rsinθcosϕ , z=rcosθ. (ϕ be the azimuthal angle)
To my surprise the answer I gain by solving this method is of ϕ^.
Could somebody please correct my where I went wrong?
2 AnswersPhysics6 years ago10 POINTS! Internal energy ,Real gases,Ideal gases! How is internal energy of a real gas a function of pressure as well as of temperature?
Can it be a function of (volume and temperature) or (volume and pressure)?
How does an ideal gas satisfies by definition the following equation-
(∂U/∂P)t = 0 i.e. at constant temperature.
U-internal energy
P-pressure
1 AnswerPhysics6 years agoPolarised capacaitors and AC! Hey I came to know that polarised capacitors are used in DC circuits while unpolarised are used in AC.BUT!?
I myself have used polarised capacitor in ac circuit without any adverse effects while performing the experiments of RC integrator and differentiator circuit in which sine waveform was converted into -cosine and cosine respectively.
Could somebody plz explain what's going on here?
2 AnswersPhysics6 years ago