2,403 Solved Topics
Remove Filter  | |
| | hi everyone when i tried to import my web site database to local sql server myphpadmin show me this errors i dont know why ?? please help me [QUOTE]Error SQL query: -- -- Database: `hakaek10_alqemaalhakaek` -- -- -------------------------------------------------------- -- -- Table structure for table `rafia_admin_menu` -- CREATE TABLE IF NOT … Databases mysql |
| | Dear All, I got one table as the tblMasterData then I left join it with another table like this tblEventAlert. So what I want to do if there is a match between tblMasterData and tblEventAlert then for that tblEventAlert I would like to match it with tblDevice to to get … |
| | I am facing the problem when i m attaching the ms sql 2005 database file in win7... MICROSOFT SQL SERVER ERROR 5120 |
| | Hi all. I come from an MS SQL background and a newbie in MY SQL. Im trying to run a simple query to populate a table: [CODE]Declare @I As Int Select @I = 1 While (@I < 100) Begin Insert into tbWhatEva Select @I Select @I = @I + 1 … Databases mysql |
 | Simple Q. I have... Why is there a need have multiple forms with in a database? Does it just make it more simpler and more organized? Databases  |
| | Here is the link to download my database with sample data (Management Inventory): [url]http://www.mediafire.com/?9o5ycrqot2risa8[/url] I am making a query to access redundant or missing quatity of material. [B]Report[/B] MatId CusMatName TDK NTK XTK ... . . . . . . . . with: TDK: [CODE]select detail.MatId as ID_Nhap, SUM(Quantity) as … Databases mssql |
 | I need to check if a databse user exists and if not, create that user. However, I do not know the statement to check if a user already exits. How to check if a user already exists in MySQL? Databases mysql |
 | Hello all. I have never updated a single column in a specific record. I am using Apache derby embedded database. I have used the update prepared statement to up date a single field with the String value but it updates all the like of every record. How can I update … |
| | Dear All, I got a query where I would like to select the clientName from tblClient but with condition that this clientID does not exist in another table call tblCDSValidity. I tried like this but it failed. [CODE] SELECT tblClient.clientID, tblClient.clientName FROM tblClient,tblCDSValidity Where tblClient.clientStatus='a' And tblClient.clientID!=tblCDSValidity.clientID ORDER BY tblClient.clientName … Databases mysql |
 | hai, can somebody help me, how to change root password for mysql in CPANEL? i tried to put my website online, but it send message : Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) in /home/akmajuco/public_html/_class/cms_class.php on line 9 Access denied for user 'root'@'localhost' (using password: YES) … |
| | Hello, folks. Well, I can't get my head around that particular function. I want to calculate and then return the total amount of hours assigned for a given stage_no. I got confused. Do I have to use COUNT(*)? [CODE]CREATE OR REPLACE FUNCTION total_numbers_hours(hours NUMBER, stage_no NUMBER) RETURN NUMBER IS return_val … |
| | I know this is php but it has MYSQL in it and I didn't really know where to post it. :$ The problem is, I have a check that checks if the username and password inputted matches the database's username and password. [CODE] if ($username==$dbusername&&$password=$dbpassword) { echo "Welcome, <b>$username</b>."; }else{ … |
| | Hi everyone, we have constructed a content management system that gets updated quite frequently and is used by many clients for their day to day opperations for their websites. We have decided to build a section of the CMS with additional modules that we will host on our cloud and … Databases cms coldfusion mssql sql  |
| | hi i have a query which should work however it returns nothing. i have at least 2 entries where completed = No and the date of the task is today. the code is: [CODE]SELECT count(TaskID) AS DueToday, DATE_FORMAT(`TaskDueDate`,'%d.%m.%Y') AS XLABEL FROM tasks WHERE 'XLABEL' = CURDATE( ) AND Completed = … Databases mysql |
| | Hello, I'm currently working on a database application where the application can show a number of risks and counter-measures. Now i'm updating the application so it is possible to upload new risks without having to open the database. However, each risk has an riskID, a number that was being put … Databases mssql |
 | Is it possible to export MySQL database to SQLite? If possible, how do you do that? |
| | I just started learning mysql (today) and I figured out how to insert data into a table and how I am learning how to echo the data. Here is what I have so far: [CODE]$email = mysql_query("SELECT * FROM mail") or die (mysql_error()); $row = mysql_fetch_array($email); echo $row['email'];[/CODE] This does … Databases mysql |
| | hi, i was wondering if any you guys knew of a simple way to sync from an access database offline to a mysql online database? currently my system is running on php/mysql. there is another company who have a system that uses an access database behind it. i can access … Databases mysql |
| | Hello friends, I am looking for a bit of help. Here is the scenario. I am trying to compile sales data for a number of stores from multiple databases and import them into excel for the current month by day. I have a field for date and sales. The problem … Databases microsoft-access |
 | Hi, I have a mysql database for stock records in the pub I work in. The code below displays the list of items and sizes, what I need is to be able to update several rows by subtracting the number in the qty column from the bal column in the … |
| | A table contains results of a match. Each match is a series of 7-9 games (different leagues share same match schedule table and play different best of "x" matches), such as: id teamA game1 game2 . . . game9 Need to calculate average based on game total and number of … Databases mysql |
| | This seems like it should be a simple query but I think I have my eyes in backwards... Give me all the users living in Jefferson, Bingham, Butte, Bonneville and Madison counties in the state of Idaho. [code]SELECT * FROM table WHERE county='Jefferson' OR county='Bingham' OR county='Butte' OR county='Bonneville' OR … Databases mysql |
| | Hi all, this is maybe a big stupid question, but cant get this to work thing is that i have 5 tables: airlines - hotels - costs - projects and payments being costs my main table. In this costs table I need to have in the 'total' column the sum … |
| | I'm new to stored procedures and, really anything about sql beyond the basic SELECT/INSERT/etc... so this is probably just something I don't understand but my problem is that my stored procedure seems to only return the last row of the result set (i.e. if it should return 10 items it … |
| | I try many tips but not able to connect two table with each other! Actually i want something like that , I insert into one table and if data also used by another table (Data automatically insert in another table also by submitting data in first table) Databases mssql |
| | I came again across "http://www.mysqludf.org/lib_mysqludf_str/index.php" and found the library useful but I could not figured out how to install and use them on WAMP Server version 2.0 with MySQL version 5.1.36 on Windows 7. I did followings steps but did not get the work done: 1. Created a directory named … Databases mysql |
| | Hi, I would like to track students activities by the teacher and this is visible by the students parents "dependents" and therefore the parents could give comments to the activity issued by the teacher and the teacher could respond to parents comment too. So I designed the ER Diagram, but … Databases |
 | I'm having problem to update the data into mysql database. for insert new data, it works nicely but if i want to update the existing data, it will hang my pc. even if i debug line by line, it shows like infinite loop. which part has gone wrong? i'm totally … Databases mssql |
| | can someone help me with this pls.. [CODE]DELETE FROM site_post, site_comments WHERE site_post.id=$id AND site_comments.matchid=$id[/CODE] needing to delete two rows one from each table. Databases mysql  |
| | Hello, I am trying to query a table for todays date based on this format mm/dd/yyyy hh:mm:ss AM/PM I tried date() but it only returns results based on the mm/dd/yyyy formate. Any assistant is apprecaited! Thanks, Wez Databases microsoft-access sql |
| | Hello, I am a computer science student working as a bartender in a restaurant. My boss was complaining that his monthly inventory audit was taking too much time (as he has about 2000 unique items to count) and I suggested I could build a mysql database to help him (and … Databases android data-science mysql |
| | Hi guys, I'm wondering if there is a way to solve this problem. Currently, I have an SQL statement that goes this way: [CODE]SELECT distinct name,id from list [/CODE] My understanding is that it selects the things that are distinct on both tables. Example: id name 1 Joe 2 Joe … |
| | Heya people, Here's my problem: i have a (for me quite lengthy) piece of SQL code which is automagically generated by my own application. However, when i try to execute it, it gives me an recordSet error ("Either BOF of EOF is true, or the current record has been deleted"). … |
| | Hi . I am building a live chat using mysql and the database is updated because of users entries . So the number ow rows in the table changes constantly . And need to use a query which will select the rows that hasnt been selected. SO how do I … Databases mysql |
 | I have tried this : [CODE]update customers set customers.acc_balance = (select sum (invoices.inv_amount) from customers left join invoices on customers.cust_id=invoices.cust_id group by customers.cust_id)[/CODE] this [CODE]update customers set customers.acc_balance = (select sum (invoices.inv_amount) from customers inner join invoices on customers.cust_id=invoices.cust_id group by customers.cust_id)[/CODE] error is : Subquery returned more than 1 … |
| | am geting this error while testing the login panel of my website that am currently developing. Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/smartie1/public_html/checklog.php on line 43 which is in red this is the php script used for login <?php session_start(); function session_defaults() { $_SESSION['logged'] … Databases mysql |
| | i'm trying to get data of 30 minutes ago to now.. any idea with the query [CODE]SELECT DateDiff("n",Now(),[TimeStamp]) AS [Time] FROM RIMData_RAW GROUP BY DateDiff("n",Now(),[TimeStamp]) HAVING ((Now()>30)); [/CODE] Databases microsoft-access |
| | I need to get data between year and period. 1 year have four periods. i.e; year = 2010 period = 1,2,3,4 the problem is on the period part where i could not select second period smaller from the first period. for example, i choose year=2010 to year=2011 and period=4 to … Databases mssql |
| | Hi guys, I am writing some query from winforms. I am getting error with the following query: [CODE] string query = "Select [Doctor Name], Day, DateTime, Med_Sur from Doc_Pat_App where (lower([Patient Name])= '" + name + "') and (DateTime >= GetDate()))";[/CODE] I know that there is no mistake till lower() … Databases mssql |
| | hey...i need to ask ..how to put two field in one column? let say, i have one field call Quantity for weight. Now i need to put the quantity unit which is store in other field call unit. how i concat two field in one column....? Databases mysql |
| | Guys I have a table with image datatype and I wana insert an image in the image field, for example [CODE=SQL]insert into dbo.Products(ProductID, ProductName, ProductPrice, ProductImage) valeus(144, '8 Gig Lenovo memory Stick', 250.00, 'Image from C:Drive or where ever the image residing')[/CODE] Thanx in advance |
| | i am looking for some advice on what is the best approach to get this done :) my datababase holds a table categories with the columns [CODE]|category_id|category_name|category_parent_id|[/CODE] i am showing my users a html sortable table with the following columns |category_id|category_name|category_parent_name| so what i want, is to do a ORDERBY … Databases mysql |
| | Need help to [B]update 2 rows in the same table[/B], been searching & testing with no real luck. I need to update 2 rows based on the URL below... [ICODE]id=145&contactuname=json101&contactid=7&memberid=1&confirm=2[/ICODE] Updating these fields: [ICODE]ustatus, memberid, contactid, contactuname[/ICODE] Table structure: [CODE]CREATE TABLE `contacts` ( `id` INT(40) NOT NULL AUTO_INCREMENT, `ustatus` TINYINT(1) … Databases mysql |
| | Main Form = Frm_Engineer_Search Sub Form = Frm_Engineers Frm_Engineers populated by Tbl_Engineers I've been trying to link together a textbox with a subform so when a surname is entered into TxtSearch and CmdSearch is click it will run a query/refresh the subform displaying the correct record which correspond to the … Databases microsoft-access |
| | guy i was given a qeustion for my exam that What is the most commonly booked room type for each hotel in London? to this i replied [CODE]SELECT MAX(R.roomno)AS most room selected FROM ROOM.R,HOTEL.H,BOOKING.B GROUP BY roomtype WHERE H.hotelno=B.hotelno AND city='london' [/CODE] my problem is that i dont know if … Databases mssql |
| | Is it possible to create a stored procedure to delete all records from a table (i.e. DELETE FROM <tablename>), but pass the table name to the procedure as a parameter? My desire is to have only one procedure for deleting multiple tables' records; I would simply pass in the table … Databases mssql |
| | Hi, I have two tables. Cla_case cc and Cla_event ce. The join between the two tables is on cc.cla_event_no = ce.cla_event_no. In cla_case i have the following columns : Discover_date and Notification_date. In cla_event I have the column Incident_date. I need to perform a SUBQUERY that will find the latest … Databases oracle |
| | Hello every1, I want to ENTER Sr.No. and Name in the table using procedures. My table has attributes 1. Sr.No. (which is my primary key(int datatype)) 2. Name (which is not null(string datatype)) I want to write a procedure in mysql to automate the process of entering data in the … Databases mysql |
| | I'm pull gaming stats from a database, but I'm having issues with one of the cases and I can't seem to figure out why. The first two cases work fine, but the last one just returns null. What's strange is when I replace the third case with one of the …  |
| | I have 3 tables: A, B, C. How to insert 100000 rows into table B, while inserting have data is the random data are taken from Table A and C Thanks for help!!!! |
The End.