MySQL Question

I have a question about trying to sort of link together two tables by values. I have one table that has the following columns: id,text and then another table that has the colomns: id,table_a_id,user
I need to be able to search through the tables to display the rows in table one that the user is found to have linked to. Is this making sense? But I thought that there was some kind of command that I would be able to link the two together such as to check them on each other but none of my attempts have seemed to work.

Smilar Topics

  • MySQL Question

    I have another MySQL question, but this one is a little different then the other one I had asked. Here's my situation:I have a database of files and each file has a "column" for the number of downloads which increases by 1 everytime someone downloads it.I was wondering how I could go throu ...

  • CMS (PHP/MySQL) question

    I've made a pretty basic (crude, perhaps) content manager.It enables the user to enter text into two fields, for dateand event information, which then get stored in a new db row. Also, beneath the entry form, you get an ordered display of existing entries, and beneath each one is a link to edit orde ...

  • another MySQL question

    I have another MySQL question for those of you more advanced than I am. I've been working on this for a couple hours now, but can't seem to get it to work properly:Ok, let's say I have 4 different tables - rankings, asset_1, asset_2, and asset_3.each of the three asset tables have 2 primary keys: us ...

  • Ubuntu mysql question

    i have a question after installing mysql database where to perform coding for mysql in the terminal or we get a client version to perform the coding ?? ...

  • PHP/mySQL question

    This question may have nothing to do with PHP but i'm going to post it anyways, cause i'm not sure.I'm writting a PHP script that is to be run on a server (Let's call it Server A). And I have a mySQL database on Server B.I am trying to connect to Server B with the script running on Server A and get ...

  • array/mysql question

    My question is, how can I build an array like this;$data=array("12-23-03" => 98,"12-24-03" => 56,"12-25-03" => 46,"12-26-03" => 24,"12-27-03" => 13,"12-28-03" => 87,"12-29-03" => 75);from a mysql query like th ...

  • MySQL question about backup

    I have an MySQL DB hosted with a hosting provider. Now I want to backup my data. I can use phpMyAdmin and export the DB to an 'SQL' format.. My question is : what will happen with the AUTOINCREMENT fields, when I restore this data ? 1. Will the records be recreated with the value as they are in the ...

  • MySQL Question on Index length

    I have a question on the "Index length" field you see from MySQL Administrator in the Schema Tables tab under Catalogs. In my cfs_extents table (see definition below), which has 200 million rows, the Index length is 0. In my cfs_files table (see definition below), which has 130 million row ...

  • MySQL Question related to "Describe table"

    Hello, i would like to make a question related to Describe table, I have a table which has its primary key (dvd_r_id) and a foreign key (pc_id). mysql> describe dvd; +--------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+---- ...

  • Grouping objects in mysql question

    I am new to mysql, having picked it up out of a need to design a human resource webapp. My question goes like this. I have a table with data of newly matriculated students for my university. Fields include their gender, their primary degree program (ie. whether they're economics students, business s ...

  • how do i edit a mysql database? (was "Really basic MySQL question")

    Hey, I'm looking to learn about MySQL DB's so my site can hold more connections and move at a quicker rate. I'm used to editing databases by simply editing them from my desktop so my question is, how do I edit a MySQL database? Can someone point me in the direction to a site to help someone looking ...

  • MySQL Question about 'Load data local infile' and excel .cvs files

    I am new to mySQL and teaching myself the language. Have a question? I created a spreadsheet of data in MS Excel and saved the file as CSV(comma delimited). File is called CUSTOMERS.csv Here is just a small sample of a much larger list in which all the data was entered line by line in order: 90 WEND ...

  • MySQL Question about performance

    I am very new to MySQL and have a question about the database performance. I currently have in the database two tables with an identical structure, let's say one for men and one for women. Each holds about 200,000 records. When I query the database I first determine which gender someone is and than ...

  • Really stupid mysql question(to you)

    How do you create a database in MySQL called, lets say "mydb"?:D Is that the right way to ask the question?:o ...

  • MySQL Question about trying to recover data from an old install

    Okay, I had mySQL 4.1 installed and had data entered. I lost my system drive to a hard drive crash, but I still have the folder where mySQl 4.1 was previously installed (as it was not on my system drive). My question: How can I get the data from that old installation into a new mySQL installation? I ...

  • Win2k3 Apache2 PHP MySQL question

    Hello,evryone,I'm a Chinese,oncemore I asked a question for install PHP and MySQL under windows server 2003 IIS6.0,but I always couldn't make the PHP connect with MySQL.(Thanks tomwerner and LeZeNkO :) )http://www.phpbuilder.com/board/showthread.php?s=&threadid=10264944Now,I used Apache2 and PHP ...

  • MySQL Question about ERROR 1071 (42000) error

    I've got a production database in MySQL 5.0.45 on a Linux server that I'm trying to import into MySQL 5.1.37 on my local Linux box. I use mysqldump to dump the database on the server and I use the "mysql" command to import the file created by mysqldump. During the MySQL 5.1.37 import proce ...

  • MySQL question on innodb_data_file_path

    the ibdata1 file size can be fixed to a maximum for innodb tables and my question is what is the trade off of putting a maximum to it and if there is a happy ratio between that size and the size of the actual table or their usage, b.c technically we use only at most the last 100rows of each table an ...

  • connect_mysql() question

    I have a seemingly silly question. In the connect_mysql() function. How do I determine what my local host is? I have hosting through Blue Host and I've created the database, but nowhere can I figure out how to access a specific DB. ...

  • MySql question

    OK ... kinda new to this, but I have a general question regarding mysql privileges.Suppose a certain user creates a database with tables, etc that he will access thru PHP on some hosted site.In the PHP code, to access the database, he needs to do a:mysql_connect(host, username, password);Since this ...

  • MySQL question

    I have a MySQL database with a table called bands. This has 4 fields: Band_ID, name, album and genre. Lets say i manually insert the following data: INSERT INTO bands VALUES("0","Pink Floyd","The Wall","Rock");INSERT INTO bands VALUES("0","David ...

  • Simple MYSQL question for n00b

    I have a question about MySQL. How can i transfer my database (the one stored on this computer) to the MySQL database on a dedicated server?Pretty much... how do you create a database on a server over the internet?Thx ...

  • MySQL Question Concerning (innodb_buffer_pool_size)

    I'm currently running RHEL4.1 64-bit, mysql 4.0.26 w/ 4GB RAM and have my innodb_buffer_pool_size set to 2GB, My question is, can I increase my ram to 8GB and set innodb_buffer_pool_size to 4GB or even 6? ...

  • MySQL Question about bug 12308

    I want to upgrade our MySQL servers from 4.1 to 5.0, so I have been doing a lot of digging through the manuals, change logs etc on this site and others. I came across this Bug, 12308 which has been committed to 5.0.13. Basically it says: When getting a lock timeout or deadlock, Innodb rollbacks the ...

  • MySQL Question about UNIQUE_RANGE flag.

    I've got a question about the usage of the UNIQUE_RANGE flag in MySQL. It seams to me that this flag is set differently when using a composite key compared to using an key consisting of a single field (both unique). When I execute the query in the following example, the UNIQUE_RANGE flag is *not* se ...

  • PHP MySQL Question ...

    I've got a login script, and on it I open the DB, authenticate user and session_register a bunch of variables. Throughout the session, all user info is retained.I've got an administration section, that I use to add, edit, and delete users, and once I've say, added a user, I reopen the database, run ...

  • MySQL question

    I'm fairly new to php and very new to MySQL. My question is this, how do I grab the value from the fields startdate and cycle from the database table customer_t? Basically what I want to do is this: I want to have a form for updating periodic billing information. The startdate and cycle that the cus ...

  • Need help with simple MySql question

    Simple questionI'm want to return a set of results from mysql where the fields are empty. I've tried the following to look for empty strings but it returns no results even though there are plenty of records that have no data in 'field'. I have the data type set to varchar(50) NullSELECT * from table ...

  • MySQL question marks on insert of Unicode Japanese text with Perl

    When I try to insert Unicode Japanese text into a column, it gets converted to question marks. I have a test table, t, with one column, kw: mysql> select hex(kw), hex("?") from t; +---------+----------+ | hex(kw) | hex("?") | +---------+----------+ | 3F3F3F | 3F | +---------+- ...

  • MySQL Question about LOAD DATA LOCAL INFILE command from a PC to webhosting server

    Question about LOAD DATA LOCAL INFILE command from a PC to webhosting server: I'm using MySQL on my webhosting providers server, as well as PHP. I have data in CSV format that I frequently need to insert into MySQL tables. What I am currently doing is using the phpMyAdmin on my webhosting providers ...