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
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.