table

The problem is that deployment MySQL DB is on Linus, ma development MySQL DB on Windows. DB is InnoDB. So arose the problem with case-sensitive…

I have 3 tables, 'old', 'new' and a 'result' table (from a phonebook database), they have the same structure and nearly the same entries. old: ID |…

I have a MySQL table like this: +--------+-------+ + Server + Port + +--------+-------+ + 1 + 27001 + +--------+-------+ + 2 + 27002 +…

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…

It's a complicated title, I know. I think an example would best illustrate what I mean: Let's say I'm asking the user for their favorite Rock…

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…

As simple in theory as it sounds I've done a fair amount of research and am having trouble figuring this out. How can I check if a MySQL table…

I am using Apache FOP 1.0 to generate PDF. I want to extend the end-indent of the table such that I do not get the INFO warnings: INFO: An fo:table…

$dbhost = 'localhost'; $dbuser = 'root'; $dbpass = ''; $conn = mysql_connect($dbhost, $dbuser, $dbpass); if(! $conn ) { die('Could not connect: ' .…

I'm just looking for some general direction on this one. Basically I have a date set as one of the parameters of a mysql database. The date is set…

I have 2 tables usrfrnd_table user_id friend_id __________________ 1 2 2 5 3 1 2 1 and usr_table id fullname ________________ 1 John Doe 2 George…

I have 2 tables usrfrnd_table user_id friend_id __________________ 1 1 2 5 3 1 2 1 and usr_table id fullname ________________ 1 John Doe 2 George…

I want to delete multiple users from db table with checkboxes at once. But my code doesn't work correctly index.php <?php require 'db.php';…

here is my code - <?php $host="localhost"; // Host name $username=""; // Mysql username $password=""; // Mysql password $db_name="test"; //…

Been banging my head trying to work this out but no luck, so am reaching out for help! I'm trying to put together a photo portfolio for a friend…

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 have 2 tables that contain completely seperate information table: tires columns: Tire_id name model etc etc table: product columns: product_id…

I need a table which will allow to insert values into a column with values greater than 10. When I tried in net, they suggested to create table in…

I have 2 tables table1 in database1 on server1 having userID and userName table2 in database2 on server2 having userID i need a way to access table1…