do mysql create another table when selecting rows?if this happens it will take up lot more space on hard disk as duplicate entries will be risiding in table formed by "select"...
ankit1122
-3
Junior Poster in Training
Recommended Answers
Jump to PostNo, MySQL does not create new rows unless you tell it to.
Either you are using the wrong query to get your data or something is seriously wrong with your installation (unlikely).
Can you show an example of a query you're using and how it affects the db?
All 3 Replies
mattster
195
Practically a Master Poster
Featured Poster
No, MySQL does not create new rows unless you tell it to.
Either you are using the wrong query to get your data or something is seriously wrong with your installation (unlikely).
Can you show an example of a query you're using and how it affects the db?
ankit1122
-3
Junior Poster in Training
select email from tablename where products LIKE %product1% && products LIKE %product2% && products LIKE %productn%
Taywin
312
Posting Virtuoso
Not sure what is that query? The reason is that it will very likely return an empty row back because of your WHERE clause...
My question is, why do you think it will create new "table" (not "row")? What functionality or command are you using that implies what you said?
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.