7,494 Archived Topics
Remove Filter  | |
| | Hello everyone :) Sorry for bothering you, but I have a problem with solving one query, in general query is much more compllicated, but I will try to simplilfy it Lets asume that we have table named info and it looks like this: id , name,price, from_date, to_date, 1 , … Databases mysql |
| | Hey guys I have installed SQL Server 2005 Developers edtion and I have noticed that I dont have SQL Management Studio feature available. I am currently in the process of reinstalling just incase I missed out an option during installation. What concerns me is: Is Management Studio available on SQL … |
| | Hey there everyone! I'm just about to start a database assignment for uni but don't know whether to use MS Access or MySQL. I am an adequate use of both but does anyone know the advantages and disadvantages of them??? Thanks ;) Databases microsoft-access mysql |
| | Hi Code below generates this error "Table 'sis_audit.pay' doesn't exist". [code]UPDATE pay SET Ref='111', date='2008-11-11' WHERE id=29[/code] When i create same table in different database, no error at all. Why? Thanks Databases mysql |
| | Is there any easy way of mirroring a mysql database, without having access to the config files?? Reason I ask is that I have 3 servers all running of the same mysql databases. 95% of the access to the DB is read data. So what I'm thinking is for both … Databases mysql |
| | i am assigned to convert data from microsoft excel to mysql... pls tell me how. pls help. thanks ! :( Databases mysql |
| | Hi, How do we save person's pictures in database?Do we just create column "pictutePath" and enter this value "../pictures/user1.jpg" for each person or is there any other way? Thanks Databases mysql  |
| | Hi This might be a basic question for all of u, but i need help from you guys. here is my query select (sum(datediff(dd,DateAdmitted, DateDischarged))/count(*)) AS Avrvg from table1 where DateDischarged is not null this gives me the result as 4 in the column Avrvg. but the actual result should …  |
| | I have a php webpage file that contain all the file and the code i want to edit that database content from all the file extrcted from the www folder of the wamp serve rthat will be use to connect to the database pls where will i get the database … Databases mysql |
| | hi, I would like to delete duplicate rows in MS ACCESS. Note: There are no PKEY in Database also the DB allows duplicate records. Please help Regards, DINIL Databases microsoft-access |
| | hey guys, I have made a database using mysql and php. I have also put in a search option. But what i want is that if the item which is being searched for is not in the databse it should return "Database Not Found". I am not able to execute … Databases mysql |
| | Hello, I am a graphic designer who does some web design on the side. The store I work at had a website that the boss wanted transferred to a different host. So I downloaded it off the server and uploaded it onto a new one. I knew that I was … Databases database-design mysql web-design web-server |
| | Hello all, I'm having a problem with converting a script from MySQL to MSSQL .. the problem is within this query: [CODE]select * from data where name LIKE '$name' AND spot LIKE '$line' AND piret LIKE '$piret' [B]AND timestamp >= '$before' AND timestamp <= '$after' ORDER BY timestamp DESC[/B][/CODE] the … Databases mssql |
| | Well Friends, I am thinking to get Oracle Global certification OCA. For this, I need to get some good ebooks of the oracle press,can anyone here can provide me the link? Thanks in advance. Databases oracle  |
| | Hi I have 4 comboboxes..and any value that I choose.. I get a whole set of fields displayed in my datagrid view.. I want to make a difference..the value that I choose in the combobox, has to appear green in color in my datagridview. How do I do this ? … Databases dataset mssql open-source  |
| | I got a table that looks like this: ACCOUNT---------NAME------------BROUTE------------BACCOUNT-----------VALUE ---[COLOR="Red"]NEED[/COLOR] 111111................BILL...............77777777...............88888888...............345.34-- 222222................BOB...............77777777...............88888888...............0.0-------- 111111................BILL...............77777777...............88888888...............454.34------[COLOR="Red"]2225.67[/COLOR] 111111................BILL...............77777777...............88888888...............657.67---- 222222................BOB...............77777777...............88888888...............768.32-- 444444................JIM...............55555555...............66666666...............23.12---- 333333................TIM...............55555555...............66666666...............36.58-------[COLOR="Red"]685.02[/COLOR] 333333................TIM...............55555555...............66666666...............625.32--- There are over 62 thousand entries with different values for columns listed above. I want to use (BROUTE + BACCOUNT) as a primary key for this query. "Bank account + bank routing … Databases mssql |
| | Hi, I am using the following syntax in VB 6.0 to copy distinct values from strTableName to TableName [code]strOpen = "Select distinct * into" & " " & strDupTableName & " from " & strTableName rst.Open strOpen, db, adOpenDynamic, adLockOptimistic[/code] But I am getting a runtime error "-2147217833". I have … Databases microsoft-access |
 | hello friends.... I am PHP programmer using mysql as my database... Now it is the time to make fast all my queries ,which im using in my programming... I heard about indexing... Tel me what is indexing,how to put indexing to my table... mainly what are the advantages and disadvantages...or … Databases mysql |
| | We have a filemaker db collecting email subscriptions. We need to export those on a regular basis and import them into a listserv. We would like to write a script to have this all happen on it's own. Is this possible with FileMaker? There is a script in it that … Databases microsoft-access |
| | Can a stored procedure be written with a column name? For Table1 with ColA, ColB, ColC, I want a query like: EXEC sp_Mine 'ColA', '100%' I want the results to be like: SELECT ColA, ColB, ColC FROM Table1 WHERE ColA Like '100%' I tried setting up this stored procedure, but … Databases mssql |
 | Hi! Is there any way I can save a database as an SQL file? Or at least save schema if saving data is not possible. Thanks in adv. |
| | Hi, I have the following data in a table called staging, and it is in the format. C1,C2 and C3 are column Headers. C1 C2 C3 41 te cc 51 te cc 42 te cc 41 te cc 51 te cc 42 te cc 41 te cc 51 te cc … Databases mssql |
| | I'm working on a project that just needs to know that its 08:00 or 14:01. I dont need or want to store anything about date. When I store the time and then try to check it against the current time I'm runnig into problems. where (timeofevent = Convert(char(19),current_timestamp)) this doesnt … Databases mssql |
| | Dear folk, what should I use for [COLOR="Red"]Price[/COLOR] Field in Data base I have used BigInt But I know I could do it with Decimal , I ned to do it without any Limitation of the size of the digits and the numbers after dot ( . ) so what … Databases mysql |
| | I was wondering how to store this date into the database: Friday, August 28, 2015 and this time: 8:00PM I have one field that collects the date and another for the time.. Im looking to store them in this format, 0000-00-00 00:00:00.. Is there some way to turn this date … Databases mysql |
| | Hey all, I have a weird query and I'll try to explain it simply. I am building an application inventory for my work. The database includes a single master table (tb1) and many slave tables. Some of the slave tables have a language code on them (so it can store … Databases oracle |
| | |
| | i was just doing a simple thing in C#, just trying to put the values feeded in the text boxes in sql database. i am giving the code below the code executed perfectly but when i went to look into the table data there was no data inserted...... pls HELP...!!! … Databases mysql open-source  |
| | Would anybody happen to know which of these ways is the better way to run your queries?? Would it be better to have all your SELECT queries before the actual <html> code starts, or would it be just fine throughout the page in the <body> tags?? Is one slower than … Databases mysql |
| | i want to insert new row in second table and this table connected to first table. How can i do that? Databases mysql |
 | I have a table which counts messages sent to a particular department. the important structure is basically ID Department Message DateSent I want to be able to retrieve a resultset where that looks like this: Department MessageCount something like a SELECT COUNT(ID) Where Department=XXX but collect each individual department count … Databases mssql |
| | |
| | Bit of a php and sql issue, so thought I'd try here... for a registration form, I have created an sql file such as... [icode]firstname varchar(30) not null[/icode] ...etc...for all the fields, which I then import to the database. But then the form also has 15 checkboxes where the user … Databases mysql |
| | I have to create database of student having different subjects and marks in respective subjects. Now many students will many subjects so there is many to many relationship. My database design: Table 1: Student table (PK)Stud_id, Stud_name Table 2: Subject table (FK)Stud_id, Sub_id, Sub_name, Marks. Table 3: Stud_Sub table Stud_id, … Databases database-design |
| | hi i want to join four tables.i used left join.thougn value are there in my db all the datas from seekers_qualification, seeker_target tables are getting displayed as Null.but there is no Sql error [code=sql]SELECT seekers.firstname, seekers.middlename, seekers.lastname, seekers.totalexperience, seekers.mobile, seekers_qualification.qualification, seeker_target.jobtitle, seeker_target.ann_salary, seeker_target.state, seeker_target.relocate FROM seekers LEFT JOIN ( SELECT … Databases mysql |
| | Can anyone help? I have been fumbling around with a SQL statement for days trying to make this work. I am looking for a Statement that will output a table based on an incremented number. Example Table1: Value1.......Value2.......Incremented Number 14...............null.............1 12..............15...............2 12...............98..............3 15...............14..............4 17...............15..............5 1.................14..............6 5.................98..............7 Example Table2: Value1.........Value2 X030............1 … Databases mssql |
| | I have an invoice type of system and am having troubles trying to update an item.. I have 3 tables that deal with the orders.. Here they are: [code] CREATE TABLE `dw_orders` ( `order_id` INTEGER unsigned NOT NULL auto_increment, `customer_id` INTEGER unsigned NOT NULL, `order_date` DATETIME NOT NULL DEFAULT '0000-00-00 … Databases mysql |
| | Dear Forum, Apologies if this seems like a trivial question, but I'm a noob and am having a tough time cracking this problem. I have 3 tables: 1 for a table of plant species, 1 for a table of cultivars for each species, and 1 table for organizations that have … Databases |
| | Hey Guys, I was hoping someone could help me with designing a database? Basically, I want to design a database that will hold a bunch of test cases. For those of you that don't know, a test case simply documents a test that is to be executed on an application. … Databases database-design |
| | Hi I have table2 and table1. I want to check if table2 values exist in table1. If they do, I want them to be displayed on datagridview in a form. The table1 and table2 have same fields except that the primary key in each table is the serial number. Even … Databases mssql |
| | I have an Access database that I use to keep track of account and inventory information for my job. I am currently writing a C# app to allow me to search through and pull up the information from a couple different tables and display them. How can I access the … Databases microsoft-access |
| | I'm trying to figure out a way to get this if statement to work.. [code] $array = $_POST['field']; foreach ($array as $key => $value) { if ($value does not exist in database) { $query = "INSERT INTO..."; elseif ($value >= 1) { $query = "UPDATE... "; } else { $query … Databases mysql |
| | Hi Friends, I need your help. Whenever I do a query on localhost it retrieves a value, but when I try on live it shows an error? What could be the problem? Databases mysql |
| | I want a button click event to do this: can i use "UNMATCHED" keyword in the same SQL Statment using a UNION ? pls help me with this!! table1 is my master Db and table2 is my work DB.. both have same columns expect that primary key in both tables … Databases dataset mssql open-source |
| | Hi All, I need a hlp how to connect Mysql wit outlookexpress, so that i hav to retrive data from mysql to outlook express. Regards, Sugan Databases mysql |
| | the code worked perfect on Friday and when I come back today and try.. the RAM alone works fine in the T-SQL but the Mfg, Make, GraphicsCard and GraphicsVersion do not work atall.. they dont give me any queries atall in the data grid view o/p.. why am i stuck … Databases dataset mssql open-source sql  |
| | Hi; This is my first project. I am developing a project: student feedback system for an institution. Here each student will get an userid and password . There are six tables in database to support project 1. User—consist of user information like username, password etc. 2. Groupid—consists of various groups … Databases data-structure |
| | My team( all freshers) are developing a project that will involve many Modules. I want to know if it is a good practice to have different databases for a single project!!! I know that this could lead to a bad design, if you make the wrong decisions of placing the … Databases database-design |
| | Which keyword should be used in a SELECT statement to retrieve only parts of the result set? Databases mysql |
| | Can anyone help? I have been fumbling around with a SQL statement for days trying to make this work. I am looking for a Statement that will output a table based on an incremented number. Example Table1: Value1.......Value2.......Incremented Number 14...............null.............1 12..............15...............2 12...............98..............3 15...............14..............4 17...............15..............5 1.................14..............6 5.................98..............7 Example Table2: Value1.........Value2 X030............1 … Databases microsoft-access |
The End.