More tables or more rows which is better

[pandglobal]

Is now that I figured out the whole grammar behind indexing.

At first i thought if i am using where servicename = ‘service2’
i expect MySQL to focus only on servicename column for its search,

So what effect is setting index again for the column servicename

As if index tells MySQL where to look for, what is the work of WHERE AND OR NOT in the sql query i sent?

[r937]

your questions can be answered by reading the web site i linked to – maybe not all of it, but at least enough to resolve the doubts you still seem to have

it will be time well spent if you are serious about your project

[pandglobal]

I need to grab some candy and popcorn is reading time.

Thanks

[johnmaronilla]

I have suggestions, 1) create an excel spreadsheet or google sheet.
Then, create tabs for each table you want. For example, subscribes, services, and so on…

From this, you will have a good start in create your
Database schema for your business.

Think of it like doing a bookkeeping of your services. To make things easier you need a good understanding of SQL or DBMS like MySQL.
And a good simple understanding of AJAX and PHP server side scripting language.

[pandglobal]

Thanks john, but Ajax has nothing to do with MySQL and I understand ajax and php.

In all advice or advices received here about using one table for all services, i actually went for 500 tables, dedicating each table for a service because of a specific need.

But in general using one table for all services is best