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.

MySQL Question on Stored Procedures

Is it possible to schedule the stored procedures wriiten in MySQL to execute at regular intervals. Suppose I have a stored procecure MyStorProc, I would like to execute this every one hour. What are the different methods available to check the status of the job? ...

Newbie Mysql question

Has anyone got Mysql to work properly on b-One.net I can create tables and manually enter data, but I cannot upload a database in txt format via 'phpMyAdmin 2.3.2' and I cannot LOAD DATA INFILE Any ideas or advice ??? ...

MySQL Question with time and day

I need to create a mySQL database to store information about weekly meeintgs that meet once a week at a the same place the same day of the week and the same time. I think I should set up a single table that has multiple fields to hold the information. I have tried a few differnet ways to store the d ...

Perl DBI MySQL question

I'm trying to use MySQL to do the following.. After a person submits a form with one of the fields being "username".. I want the Perl script to check my database for the username, if it doesn't exist, it should add. if it doesn't exist it should give an error message... i have an idea how ...

MySQL Question about data types

I'm trying to create a web based program that allows members to link to other members. What datatype is appropriate to go about doing this? ...

MySQL question re: ft_min_word_len

I tried setting this in my.cnf as so: [mysqld] ft_min_word_len=3 But when I rebooted, all I got were streams of socket errors. I am running 3.23.58 ...

MySQL question about a select statement

This is probably super easy, but I cannot get it. I have 2 tables one has the list of clients the other the shipments the client has received. Table 1 name is client id first_name last_name Table 2 name is shipment id clientid shipped_date productid My question is how do I setup my query to show the ...

MySQL Question about uploading files and storing in BLOB column

We currently upload MS word files to our web server (Win2000/IIS 5 - using traditional ASP) and save them in various folders, depending on the customer it is intended for. For security reasons, I would like to begin storing these files in a database table, medium BLOB column (using MySQL 4, MyISAM t ...

MySQL Question on Loop, please help

I am trying to delete records from 1 table based on what is contained in another table. I build the compound statment below to try to do it. However, there seem to be a syntax error somewhere I can't understand, Can anyone help me please? The code below is all I typed: ---------------------------- B ...

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

Solaris-Apache-JServ-MySQL question

I've gotten JServ installed with Apache on a Unix box and I've been playing around with some servlets. Now I want to tie in to some MySQL and Oracle databases. I've already got PHP accessing the MySQL databases without JDBC. Is there a ./configure option to add support for MySQL or Oracle when build ...

MySQL Question about "bit length"

I have a question. If I make an SQL query, lets say: CREATE TABLE 'test' ( 'id' INT(5) UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY('id') ); How big of a number is INT(5) ? I read the manual on it, and I can't quite understand it. How can I determine a good value for an index based on a bit value? ...

MySQL Question about my.cnf file and its' role

I am setting up a central logging server using Slackware 10.1 and MySQL 4.0.23a. I actually have everything setup and working great - but want to move onward with replication to a second (identical) server to ease backups, have a failover etc. To enable replication I read that I need to make some ch ...

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

MySQL question about DISTINCT

i have a table in MySQL that is updated about every 5 minutes with about a hundred new records. For an application i am building, i only need the info from the most recent entry for each specific unit. But, i need all of the info in that row. i was going to use DISTINCT like this, SELECT DISTINCT Un ...

easy mysql question

im an extreme newbie with mysql. my site is hosted on my friends remote server, he created a database for me to use. i have a book that explains how to create a table with sql but i dont know what to do with it. can someone please help me? ...

MySQL Question about BINARY fields

I have a field in my table that is BINARY. I do this because I want to be able to store 'Word' and 'word' and 'WoRD' as their own entries. Though, when I display the words on my website, I want them to be in non-binary alphabetical order. Is there a way to do this during a query? Otherwise I will ha ...

MySQL Question regarding graphing a set of data values

Hello. I have a database that contains per minute data and I am currently graphing it and it works. However, I want to take the first 5 mins worth of data, average it and than graph it and then take the next 5 min worth of data, average it and graph it and so on and so forth. Please help !!! ...

Online Game - Quick PHP/MySQL Question

I am quite desperate for help with this small PHP problem!I am creating an online game in PHP and have almost completed the script, although there are a few small things that I just can't seem to figure out.Within the game each user has a character, which is interactive (can be fed, played with, etc ...

MySQL Question on type decimal

i have a little problem with the type decimal(p,s). I am working on a large e-banking product and we are creating a demo-version that is using mysql. Normally oracle is used for the database part, which actually leads to my problem. I need a lot of digits on both sides of the decimal point. It would ...

MySQL Question about Network Connectivity

What I am trying to do is set up a Database Server so that I can access/update/edit databases over the nwtwork via a desktop pc or a Pocket PC, or a Palm. I currently have MySQL 4.1 setup and running on a server pc, and I was able to use the admn utility on my desktop computer to connect to the data ...

MySQL Question on Query / with better description

Sorry to post this again, but now I have a good description: I have these 2 tables: 1) User Table jos_users: which has these attributes: id | name | email |... 1 | walter | walter@walter.de 2 | werner | wer ...

MySQL Question about GROUP_CONCAT()

when i use the GROUP_CONCAT() like this GROUP_CONCAT(FIRST_NAME, LAST_NAME) it displays this: JoeSmith with no space between the first and last name. is there some kind of formating that i can put in so that it will display the name like this: Joe Smith ...

MYSQL question

I trying to nail a sql call, but i need some help.I am attepting to capture who(submitting_user_id) has sumbitted the most amount of stories(article) and how many stories that user has sumbitted. I don't think i can do this with a WHERE in the submitting_user_id field. any help?+-------------------- ...

MySQL Question on Update

Please if somebody could help. Thanks. I have 2 tables, Table A and Table B. I would like to update a field A.fld1 from Table A based on Table B 's B.fld1 entries B contains 3 records. So, update A,B set A.fld1=replace(A.fld1,B.fld1,concat(B.fld2,"***")) where A.fld1 like concat("% ...

MySQL Question about generated ID

I and building my own site which will be database oriented. I am wanting to reuse the generated ID's that's no longer relevent. For Example: if I have generated id's for 20 people (20 rows) in the db table and 4 of those rows are deleted (say rowid's 3,5,9,18), I want the next generated ID's to be 3 ...

MySQL Question for speeding up the update query operation.

I'm using MySQL 5.0.19-nt and the storage engine is MyISAM. There is a table which has 7 columns and first 5 key columns. From clients, my program receives 1200-rows-items(maximum,all have unique key combination) and should update them in 10-seconds. How can I reduce the query time for this update? ...

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

MySQL Question

how can i find my database name ...

MySQL Question about older versions

Is the mysql default database included in versions lower than 5.x? ...