[mysql] Forum Topics

Im trying to figure out a way to access a row I 'just created' via the primary key. As it being a primary key it is auto incremented. I am using php/mysql to create the row then I require to access that same row (via the primary key) to be …

I've created my own forum and would like to display username - from users table title - form topics table and a count of comments - from replies table I 've got the first bit sorted ok SELECT username, title FROM users, topics WHERE users.userid = topics.userid ORDER BY RAND() …

Hello, I have a problem with sorting record in my access 2000. I have created a query (name - BOP Month wise) which has a date field where records are grouped month wise. When i first create the query, it shows correct figure i.e. records are grouped and properly sorted …

Ok, ran into some problems in one of the newsgroups so thought here would be an excellent place to turn. Actually have only posted once or twice here and was real surprised at the pleasantness of the answers. So. You have [B]bOrders [/B]and [B]bUser [/B]listed respectivly below. In the simplest …

i have three table 1st viewleave 2nd applyleave 3rd personal based on the leaveid in viewleavetable i wnt to fetch the spid in the second table,based on the spid i want to select spid email address........please tell how to do tat.. CREATE TABLE `viewleave` ( `leaveid` varchar(25) NOT NULL, `message` …

Hey everyone, I'm attempting to delete records within my database but I'm having problems writing the query. What I need to do is delete records from my database that, within a field in this record, have a substring that I will pass to the mysql command. So for example, A …

Hi, I'm having a having a hard time trying to insert some data into a mysql DB, so I'd like to know if there is some kind of error log that could help me. I've already looked into the binary log but it didn't help me. I also started mysql …

when i run this query ...... update item set description=(select description from item where itemid=5384); i get this error message... Msg 279, Level 16, State 3, Line 1 The text, ntext, and image data types are invalid in this subquery or aggregate expression. there is a lot of text in …

I am unclear how to write a query where I want all the entries in a specific month and date format from a MySQL table. I am not using DATE_FORMAT() with a NOW() correctly. I need to write a query that has a time field in the yyyy-mm-dd format to …

Hi. I am fairly new to mysql, so help is appreciated. I have two tables and I wish to count some results from two tables and combine them onto one row, and then join an ID to another table. The problem is as follows: Table A: This lists information of …

hi ! i m new to IT.i want to know ,how the data from a mysql database can be sent to excel sheet...............kindly help me..............thanks

I've a table named [transaction] [B]idtransaction [/B] is my primary key ---------------- [transaction] ------------------------- idtransaction | customerID | amount | transDate [B]Amount[/B] is the credit or debit / they differ when amount < 0 it is credit and when amount > 0 it's debit Sample Data idtransaction | customerID | …

Hi everybody, I am Hugo . I want to know something more about SQL. please can anybody give me some idea about some basic SQl questions? First of all i want to know, 1.What is the SQL Data Manipulation Language(DML)? 2.What is the SQL Data Defenition Language(DDL)?

Favorite 3rd party software with MySQL Results of a poll conducted on favorite 3rd party software with MySQL: [url]http://mysql-dba-journey.blogspot.com/2007/12/favorite-3rd-party-software-with-mysql.html[/url]

Hi I would really appreciate some assistance on the following as I suck a bit when it comes to joins i have 3 tables consultants,points,orders all tables have the column id_number I need to run a query that will give me a list of all the consultants with a total …

I made a query that joins 3 tables. Products, parts, and sales invoice tables. The thing is, the common key between the 3 tables is the sales invoice number, but when I try to execute the the query it displays duplicates. One example is when I make a query on …

Hi everyone I'm looking for advice on building up a database. Any sort of general do's and don't s. The one and only thing that I realize is that putting ALL my info into one table is not a good thing. This is the first database I'll be creating so …

I need a very strong PHP, MySQL programmer for a large Web development job. The freelancer will be required to work at the client site ONLY in the western Chicago suburbs. The project will begin in 2008 with the following high level criteria: 1) The main focus of the project …

Hi all, I'm not sure how to phrase this question... I have a table that requires a foreign key of anything table - this foreign key is automatically generated and the key field in the 'foreign' table. So I have the following situation (kind of): Table Observation [INDENT][B]Time_Stamp[/B] - [I]primary …

please can anybody give me some idea about data warehousing

I'm trying to keep all my dates and times to a standard GMT (UTC) time when I store it into the database. When I pull the data however, I want to be able to do the timezone adjustment within the query. I've tried something like this with no luck: [CODE] …

hi i have a form where the user will enter the data based on the user input i want to retrieve data ex 1st textbox one get the standard (class of the student) 2nd & 3rd textbox get the range (ex rank 1 to 10) when the user clicks submit...i …

i currently have a database that someone else created a while ago and i have been tasked with speeding up the data entry and search functionality. currently the database is one table with the following field names: bid_id = primary key date_num = date of project proj_nm = name of …

Am trying to develop a front-end to Mysql database. I do not intend to use it for web purposes so I do not need PHP. which slanguage can I use?

Hello! I have a query with multiple table joints and where clauses. Tables are huge and query runs for a very long time. I need to run another query, which is exactly the same apart for one Where clause (first time price = "P", second time price = "S"). I …

Hi Everybody, i found out that to create a trigger i have to remove the BEGIN and END and it works, but as i put an IF STATEMENT inside like this one: CREATE TRIGGER status_history_upd AFTER UPDATE ON projects FOR EACH ROW IF NEW.project_status != OLD.project_status THEN INSERT INTO project_status_history …

Hi, Im only used to basic sql queries. wonder if anyone can help with the below - or at least get me pointing in the direction of the correct resource to solve. I have a table, with fields a,b,c,d,e,f I need to run a query that shows from the above …

I've two tables where their composite keys are foreign keys that references each other. table1 (projId, userId, name, add) table2 (projId, userId, status, responseDate, reason) I need to retrieve table1(name,add) and table2( status, responseDate, reason) with projId only.. my query is [CODE]Select ap.name, ap.add, p.status, p.responseDate, p.reason from table1 ap, …

hi... i have setup the mysql replication but i dont know for some reason its not replicating the data.. i may be missing some configuration.. please help me... to do the same.. Thanks in advance.. Pooran Jaiswal my.cnf entries on slave server [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old …

hi, i want to kill all the sleep process in mysql , since it is unnecesserly taking the server memory and process.. Regards Pooran Jaiswal