2,403 Solved Topics
Remove Filter  | |
| | Hi there, I am having trouble with making an inner join whilst concatenating two of the fields. I can do both separately but have not yet mastered both at the same time. Here is what I have. It does work, however not in the intended way. It produces the only … Databases mysql |
| | hi guys, i`m new to the data base systems i currently work in a school and i have been asked to design a database for all the computer items in school the problem i have is because i no very little about how to setup and make a database i … Databases database-design |
| | Hi, I have tried to Google this but cant find anything. I want to use a select AS statement to select multiple columns. i.e. [CODE]Select unitno country price AS propertyref[/CODE] is this possible using multiple columns AS one reference? many thanks Databases mysql |
| | Hi Guys, I have a predicament here which I think is really easy if you get it right. I just cant wrap my brain around it for the moment (probably been staring at the screen too long) I have two table (financial data) Table 1 looks as follows id account … Databases mysql |
| | Hi everyone! I recently created a MySQL table that has three columns: (1) integer ID (2) integer num1 (3) integer num2 Now, I have a C program that waits for the user to input an integer ID and when there is an input, the corresponding num1 and num2 in the … Databases c mysql windows-xp |
| | Hi Guys, Back again. I'm having an issue with my java with mysql. I have the following query generated through my java, which reads in about 3k records from an excel file and churns out an sql query for me. For the purpose of this forum, ill show the first … Databases mysql |
| | This is not a homework assignment. :) I'm a MySQL newbie and we just bought a product that uses it. The vendor has indicated that what I want is a special request and wants to schedule professional services time (several weeks in the future) to write us a personalized script. … |
| | hi when i check apache status there is too many line like 198-92 - 0/0/4 . 0.00 78719 0 0.0 0.00 0.00 127.0.0.1 noc1.server.com OPTIONS * HTTP/1.0 i think this is related mysql or not is there anyway to close this pid in 5min or 10min? [CODE]0-112 1881 0/16/24053 _ … |
| | I have been searching for ways to do this but I was not able to find any. What I want to do is this: movie_genre (Table) movidId movieTitle movieGenre (Varchar) 1 Copying Beethoven (2006) Biography 2 Copying Beethoven (2006) Drama 3 Copying Beethoven (2006) Music movie_plot (Table) movieId movieTitle moviePlot … Databases mysql |
| | I'm trying to run a date range query which works, but I also need to get data outside of the date range inside of the same query which I get to work. The issue I'm having is when the start date is in say 2011 and the end date is … Databases mysql |
| | I am displaying data from an sql database in a textarea which will be altered by the user then re-submitted to the database. The problem is displaying a line break. I get <br /> displayed in the textarea rather than the newline. Can anyone help? Databases mysql |
| | I'm building a local database with VS.Net, using C#. I have constructed the database and filled it with data. I've already been through the process of connecting to the \bin copy of the Db and setting the file to "Do Not Copy". Now, I want to design Views in the … Databases database-design mysql |
| | Hi everyone! Is there a way to set a MySQL server to not automatically start execution until prompted by the user? I recently installed a MySQL server on Windows and I'm having a little bit of problem at start up. Everytime I go to the command prompt to type the … Databases client-server microsoft mysql |
| | Hello all, I am new to MYSQL programming, although i have been working with MSSQL for a while now. I am using delphi on a project and the query below does not return any results, just cant find what is wrong with it Select Airwaybill, SDate, BLAccount, RCountry, PackageCodeDesc, TotalWeight, … |
| | Hi, Is there anyway to insert/add a new column between two column in a table without deleting any other column??? Databases oracle |
 | Hi geeks, I really need your help. I want to query in a table in MS SQL using a data in another table. This might give you an idea on what I am talking about. This is the query I've constructed : "SELECT TABLE1.FIELD1,TABLE1.FIELD2 FROM TABLE1, TABLE2 WHERE TABLE1.FIELD3 = … |
| | I have been trying to download the community server edition of MySQL for 2 days with no success. I was able to download the installer and found the ZIP archive (both downloaded and mirrored properly) which I was also able to download but I cannot for some reason open the … Databases mysql |
| | I want to find out days gap between two dates excluding sunday. How can i do this in oracle. Please help me. Databases oracle |
| | I have a table with one record per certification a user has. So, user SMITH can have multiple records, one for DMV another for CPT and another for ICD. SMITH has three certificates but can have up to 20. The desire is to have a second table with one record … |
 | I am new to SQL .. [code]SELECT status FROM statuses ORDER BY date;[/code] I know this will order by date but i want to alter the table and rearrange them by datestamp.. Is it possible to alter like that ? Databases mysql |
| | Hi I am running a PHP-based intranet site where the main page has to refresh its view every minute in order to show the most up-to-date information from an MSSQL database. At any one time there are only about 20 entries that need to be shown, but the main database … Databases mssql |
| | Okay, So I want an array to get userinformation by the username that is provided. But in the other tables, it only has a ID field to link with... [CODE]$sql = "mos_users.id as userid, block, username, email, lastvisitDate, firstname, lastname, avatar, cb_age, userip FROM mos_users, mos_comprofiler, mos_comprofiler_plug_iplog WHERE mos_users.username = … Databases mysql |
 | Hello )) Please tell me - How to receive surnames of students and their mark in all subjects? in this form -[CODE] SURNAME1 1hismark1 1hismark1 1hismark1 1hismark1..... SURNAME2 2hismark1 2hismark1 2hismark1 2hismark1.....[/CODE] I use this database - [CODE] table STUDENT ( STUDENT_ID NUMERIC not null, SURNAME VARCHAR(60), ); table SUBJECT … Databases mysql |
 | I have a photo management system that I have build locally which uses mysql to store the images. the problem is that I exceed the max_allowed_packet value when my images are too large. I know how to set the max_allowed_packet value through the CLI with: [CODE=sql]SET GLOBAL max_allowed_packet=16*1024*1024*1024;[/CODE] The problem … Databases mysql |
| | Hi, I have this database based on this logic: There are projects in a company. In each project, different employees different roles. One employee could have different roles in a single project. Also, can work in different projects at the same time. Some projects could be added but role of … Databases microsoft-access |
| | Is there any ways to allow the text box in a report to show the lastest date from the database? For example: 24/2/2007 15/4/2009 21/6/2009 14/7/2010 13/10/2010 i want the text box to have 13/10/2010, which is the lastest date out of the 5 date(which I have more in my … Databases microsoft-access |
| | I have these few dates in my database and I would like to have the latest date to be shown at my report footer. 03 dec 2001 15 may 2010 08 mar 2007 14 jan 2004 29 sep 2009 can any kind soul plz help me?=) thx alot in advance=) Databases microsoft-access |
| | [B]how can i disable the save function. The database that I am making now is being shared by many users and i do not want them to mess up with my design and programming stuff that i had done. I have tried making the file into ACCDE format but it … |
| | I have data value of a table column. I want to know in which database and in which table and in which column the data value appeared in mysql. Databases mysql |
| | I have an idea for a friends list based off a user's account info. 'guid' is the character id number 'account' is the player's account number 'friend' is the player he is friends with 'online' 1 = online; 0= offline Here's what the layout is like: Friends List [CODE] `character_social` … Databases mysql |
| | Hi guys ! Please help make a sql-query - There are three tables - [CODE] table STUDENT ( STUDENT_ID NUMERIC not null, SURNAME VARCHAR(60), ); table SUBJECT ( SUBJ_ID NUMERIC not null, SUBJ_NAME VARCHAR(100), ); table EXAM_MARKS ( EXAM_ID NUMERIC not null, STUDENT_ID NUMERIC not null, SUBJ_ID NUMERIC not null, … Databases mysql |
| | |
| | I have made this stored procedure DELIMITER // DROP PROCEDURE IF EXISTS find_max; CREATE PROCEDURE find_max (IN type INT,OUT maxx INT) BEGIN SELECT max(card_id)+1 INTO maxx FROM cards; END; // DELIMITER; and i want to have this stored procedure DELIMITER // DROP PROCEDURE IF EXISTS add_card; CREATE PROCEDURE add_card (var_member_id … Databases mysql |
| | Hello everyone, I have a database with a list of characters and I would like to display which characters are currently logged in on a webpage I have. My database looks like this: [CODE]`characters` (`account`, `name`, `online`) VALUES (6, 'Frod', 1);[/CODE] I hope that makes sense. So if 'online' = … Databases mysql |
| | I'm trying to pick up the latest record for 6 groups, and I'm using the following Select statement: [CODE]SELECT * FROM newproducts LEFT JOIN (suppliers, newsrchGrps) ON (suppliers.supplierName = newproducts.supplierName AND newsrchGrps.groupCode = newproducts.groupCode) GROUP BY newproducts.groupCode ORDER BY newproducts.updated DESC LIMIT 6[/CODE] which does pick up a total of … Databases mysql |
| | Hi, If I run the following mysql_query: [ICODE]SELECT * FROM products WHERE product_name LIKE '%SOM%'[/ICODE] I get the following results: [INDENT]SOM 1 - Coloured option SOM 2 - Magnetic Roof Sign SOM 4 - Magnetic Roof Sign - Centre L SOM 6 - Magnetic Roof Sign - Curved Top SOM … Databases mysql |
| | So, I need to let a Visual Basic application connect to my XAMPP MySQL server. I set up the .Net/SQL Connectors, XAMPP, and all that other good stuff. When I try to connect to the server using 192.168.1.2 (my static IP) it will work. When I try to connect to … Databases mysql visual-basic |
| | Hi, I require some help in making the following possible with mySQL. My [simplified] database layout is as follows UserID Timestamp League Field 1 Field 2 Field 3 Field 4 Field 5 Field 6 Fields 1-6 values are either "yes" or "no" Basically a user submits a form selecting the … Databases mysql |
| | Dear All, im given a hard copy of a form that is used by a hospital to gather information about its patients ! the form is divided into sections and each section has A LOT of YES/NO check boxes. [B][U] For example, one of the section is the History section … Databases database-design |
 | As the title goes how can i transfer a table from one DB to another but first i need to delete the table1 from DB1 coz table2 from DB2 has the same name as table1... |
| | Hi there I'm having trouble a with a forum query here are my 3 tables [B]categories[/B] [U]category_id[/U] category_name category_description [B]threads[/B] [U]thread_id[/U] [I]category_id[/I] thread_title thread_text [B]posts[/B] [U]post_id[/U] [I]thread_id[/I] post_text I want a query that selects all of the top level categories and displays them however in that query I am aware … Databases mysql |
| | hello, I need to display contents with their tags, and in same page all the tags of the page contents the problem is having a limit on contents doesn't work if join tags on them (the number of tags change the number of select contents) [B]THE TABLES ========== [/B] I … Databases mysql |
 | Hey everyone. I have a mysql project that requires only some basic queries except one. Nothing more challenging than some really basic select/insert statements. No problem there. But the one complex one isn't working out. I typically work a little with SQL server and wrote the following at work in … |
| | This looks pretty simple on the face of it but I can't get my head around it. I have two tables that I'm querying: dbo.tblrespondents RespondentID FirstName Surname dbo.tblrespondentschildren RespondentsChildID RespondentID ChildFirstName ChildSurname ChildDOB ChildSex I am trying to find which Respondents who have only sons - one must be … Databases mssql  |
| | Hi, I want to take backup of all my tables in my system and i want to use in other system.Tell me how to take back up tables in oracle 9i and how to import or use those backup table in another system??? Databases oracle  |
 | Ok, I am trying to access my table via php. I have a successful connection to the server and a successful selection of the right database on the server. But I keep getting this error message when I try to run my query line through the mysql_fetch_array() finction: Warning: mysql_fetch_array(): … Databases mysql |
| | Hi Guys, I'm having an issue with my sum() function on my queries. My DB has 3 tables 1. plans 2. handset 3. matrix [B][U]plans;[/U][/B] - planNum - planCode - planName - planLength - simRebate - commission [B][U]handset;[/U][/B] - handset - RRP [B][U]matrix;[/U][/B] - planNum - handset - subsidy The … |
| | This trigger is making me nuts! I've written about a dozen triggers before but nothing where I have ever pulled data from another table. What this is supposed to do is make sure that any inserted rows have a latitude/longitude (lat/lon) value. The users table has the lat/lon and these … Databases mysql |
| | I'm having problems creating the following trigger as I keep getting the syntax error listed below the sql code and well, that error is about as clear as mud! LOL Two things to note: users is a valid table name and it does contain fields called lat & lon (latitude … Databases mysql |
 | Hey, I have a problem in my database. I have these two tables: [CODE] Table "File": +----------+--------------+-----+----------------+ | Field | Type | Key | Extra | +----------+--------------+-----+----------------+ | idFile | int(11) | PRI | auto_increment | | path | varchar(255) | | | +----------+--------------+-----+----------------+ Table "Media": +----------+--------------+-----+----------------+ | Field | … Databases mysql |
The End.