database table

I am stuck in a tricky situation. I will give a simple example to emphasize my problem. Suppose I have two databases DBa that contains tables Ta1…

Is there an online tool or an app that can create a graph or an image of an imported database that shows the relationship between the tables inside…

I am trying to make multiple foreign keys point to the same table in MySQL but I'm getting an error. drop table IF EXISTS friend_tbl; CREATE TABLE…

for example i have a table which look like this : id | name 1 | Mike 2 | Adam 3 | John 4 | Sarah ... Now when i execute query select * from table…

I'm playing around with this idea where i was saving "logs" in a "LOGS" table, with each row containing the info like "id" "title" "logtext" "views"…

Hey there. I'm attempting to design a small database for a customer. My customer has an organization that works with public and private schools; for…

With PHP and MySQL I am trying to display items with most votes over a certain period of time (24 hour, 1 week, 1 year, etc). When someone votes on…

Having trouble with this select statement: Select * from table where row != '' and row2 like '%test%' or like '%test2%'; The "or like" part isn't…

I'm working on a project and need to come up with a database for a store that sells music records. I'm having a bit of a hard time coming up with…

I'm having some issues dealing with updating and inserting millions of row in a MySQL Database. I need to flag 50 million rows in Table A, insert…

When users signup for a site and have spaces, periods, or @ in the usernames it seems to create problems. How can I include these characters?

Hi there, i want to make a link between a table customer and a table product by an IdProduct example : Create table customer( idcustomer INT not…

Hello, Ive got one question about the structure of a database. I have to save information (one number) for every day in the database. Very often I…

Hi, How can we delete some specific tables from a database. For instance I have a database with more than 20.000 tables and I need to delete the one…

Hi I'm working with MySQL, I've created a table and I'm writing queries to grab information from the table. The table contains information about…

Hi all. I'm using the table prefix method for having several clients use the same database. The number of tables created per client will be ~55.…

Hello, I'm wondering how to make a mysql table which automatically adds every unique visitor to the table and gives them a unique id, which is…

HI, I am adapting some scripts that I found through Google that monitor users who login in to a website. This consists of including this in each…

I will have several different types of users that will use my system. For all users I need to store such things as username, password, email…

I'm creating a database with various tables. Let's take the user table, for example. It has fields such as marital status and system role. Each of…