7,368 Topics
| |
Hi, Is it possible to have a subquery within a case statement and perform greater than / less than comparisons on the value returned in the subquery? i.e. [code] select case (select price from product) when < 100 then 'cheap' when < 150 AND > 101 then 'fairly expensive' else … | |
Its urgent please help!!!!! animaldetails(Table 1 ) Animal_Id int (primary key) IsMilking boolean Milking_Capacity varchar milking (Table 2) Animal_Id int (primary key) Month_Year varcahr (eg. '6 2009' -- Means June 2009) Day1 varchar Day2 varchar and so on (till 31) milkingevent(Table 3) milking int (primary key) Requirements: 1. I need … | |
I have used sql for a while but never to any advanced degree I would very much appreciate some help. I have 3 tables: [code] member, member_details and reg_options [/code] member holds all of a member's details like email, password, username and it has a primary key called id. member_details … | |
| I recently came across an example where binary data was stored in a column which related to the sum of all foreign key id integers. This was the scenario: id [int] from [int] message_title [varchar,100] message [text] to [int] I assumed the 'to' field was a foreign key on the … |
Hi, [B]This was Mysql Backup Batch Script [/B] Script named as [B]mysqlbackup.bat[/B] REM [at] echo off for /f "tokens=1" %%i in ('date /t') do set DATE_DOW=%%i for /f "tokens=2" %%i in ('date /t') do set DATE_DAY=%%i for /f %%i in ('echo %date_day:/=-%') do set DATE_DAY=%%i for /f %%i in ('time … | |
Its urgent please help!!!!! animaldetails(Table 1 ) Animal_Id int (primary key) IsMilking boolean Milking_Capacity varchar milking (Table 2) Animal_Id int (primary key) Month_Year varcahr (eg. '6 2009' -- Means June 2009) Day1 varchar Day2 varchar and so on (till 31) milkingevent(Table 3) milking int (primary key) Requirements: 1. I need … | |
Hello all... Anyone plz help for "TRIGGER CONCEPTS" & "STORED PROCEDURES". Materials wanted. | |
Hi, I have 2 questions regarding the auto increment datatype in mysql. Q1) Since we all know that if we create an auto increment column, it will start from the number '1' but is there a way we can force it to start with the number '300' and it should … | |
EDIT: I just realized I should have posted this in the MySQL section. If a mod can move it there I'd appreciate it. Thanks :) Hi all I have two tables. The first one has the details of each fruit, its code, markup percentage, it's cost price and the amount … | |
Hi, PO-1-09/09 is a data stored in varchar column. When i do [inlinecode]select * from table myid='PO-1-09/09'[/inlinecode], it doesn't return any value. If i change PO-1-09/09 to 5, and search for it, 5 returned related data. Why PO-1-09/09 doesn't work? Thanks | |
Hello... I need to get data from one table while omitting data that exist in the other table. This is the query I am running but I keep on getting duplicates since there are more the one row in the second table. Table1 - 'countries' with fields 'Country_Code' and 'Country_Name' … | |
Hi all, I have 2 tables.i.e. Table1 and Table2. Table1 --------------- Code --------------- a_b c_d e_f f_g Table2 ------------ Msg ------------ s_c_d_1 r_a_b_o t_f_g_k A_e_f_D I want to compare the two columns of the respective Tables and get the output as.. Table2 ---------------------- Msg || Code --------------------- s_c_d_1 || c_d … | |
I created a job site using my web masters, now I wanted to use the same script for my other job domains. I tried copying all my php web pages in to the server, and also changed the database configuration to match the new server password, I created tables in … | |
Hello everyone i have been looking on ebay and i went to mysql home page to trying follow their directions but for some reason I cant create a new user. I do not know how to get started, i choose the mysql file in the temp folder and that opens … | |
I would like to have a graphic interface for MYSQL database, most people use PHPmyadmin for browsing DBA stuff [B]any other alternative software that will connect to MYSQL database[/B] -- i.e. alternative to PHPmyadmin and look more pretty and can do most stuff by MOUSE ?? many thanks | |
I am using mySQL to develop a database collected from internet sources. Python is used for the spider coding, but I'm having issues with the mySQL portion. I'm pretty new to mySQL, so I'm a bit lost. I need a way to lock a single row of a table and … | |
Hi, i really need help with this :/ the export field in my localhost PHPmyadmin has many fields and I must be doing something wrong, because the receiving end doesnt load the database at all. I set: SQL in STRUCTURE: Add AUTO_INCREMENT value Enclose table and field names with backquotes … | |
I'm writing a query to summarize survey results. There are two tables... 1) The Profiles table contains the users' answers. There are four columns: ProfileID (for the unique key), QuestionID (a number representing canned questions from another table), Answer (a number representing multiple choice answers from another table), and UserID. … | |
Hi, How to find number of rows affected in update statement using mysql (not using php mysql). Thanks, Pradeep | |
Hi, I have the following query, which does not return any results. [ICODE] select (sum(t.minutes) / 60),d.fiscalmonthnum from kpifntime t inner join kpiddate d on t.datekey=d.datekey inner join kpidacts a on t.activitykey=a.activitykey inner join kpidfees f on t.feeearnerkey=f.feeearnerkey where a.activitycode in (11,12,13,14,15,16,17,18) and d.fiscalmonthnum=11 and d.fiscalyearnum=2009 and t.feeearnerkey=520 group by … | |
hai am using a stored procedure in mysql. in that stored procedure i have an temporary table. i want to check if that temporary table is already exist then drop it. else create it. reply your comments | |
Hi, I've having a bit of difficulty with an update statement. The following select statement returns 34 records... [CODE] select b.* from budget as b inner join ntime t on b.feeearnerkey=t.feeearnerkey inner join date d on t.datekey=d.datekey inner join acts a on t.activitykey=a.activitykey where a.activitycode in (11,12,13,14,15,16,17,18) and b.fiscalmonth=d.fiscalmonthnum and … | |
Can Crystal Reports be used with MySQL? If not, what reporting tool do you recommend? | |
Length/Values1 what do i put there. this is a collumn in one of my tables its bigint so the number can get increased by alot. its a point system. it asks for length/values whn i edit the name of the column but i dont understand what to put there. i … | |
I have a mysql table that was working fine. I'll try to be brief. I have a table that has two primary keys, both are also foreign keys to other tables. The primary keys are qid and pid. If I try to enter a record, using pid > 10, I … | |
Hello All. Is there any syntax for [COLOR="Red"]getting fields in a column in an alphabetical order[/COLOR] in mysql? See, for example... I have a two column with "NAME & NUM". NAME NUM BHANU 6 KIRAN 3 ADAPA 8 CHANDU 7 I need to get the names in alphabetical order. There … | |
its a mess. i dont know why it would be doing this. considering the message it says its in the inbox in the mysql database and then its not. i dont know what to do. its php and mysql database. is there a posiblitily its showing up on the webpage … | |
i m using ORANGEHRM, for dis first of all i installed basi package of XAMPP,i have created my account on the site of orangehrm.The account run on localhost i.e it runs on single system.My problem is i have to RUN IT ON D ANOTHER SYSTEM,is it possible to run d … | |
Hi all, Goodday...! Im delevoping a struts project of my own. Having doubt in database connection. Actually where i have to write code for connection, there itself my doubt starts.... whether i hv to write a connection code in (1) execute method in Action class, OR in (2) servlets, OR … | |
I have been unable to figure out how to insert data into My database. I am just learning PHP so please ignore comments [CODE] <?php if (isset($_POST['submit'])) { if (isset($_POST['question'])) { $DBhost = "localhost"; $DBuser = "root"; $DBpass = ""; $DBName = "exit_poll"; $table = "exit_reason"; mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to … |
The End.