7,494 Archived Topics
Remove Filter  | |
| | long blob size is way too small for me. how can i make it bigger??? i want thing when i making col image. i can set Attributes to or lenth/value? but i dont know what to type in help plz Databases |
 | I am building this database : http://imageshack.us/photo/my-images/217/diagramg.png/ I have a difficilty Regarding Renting. Because in this system one can order either DVD Or Game. Therefore how am i going to link the Game or/and the Dvd to the Rent table ? Currently it does not work due to the fact … Databases |
| | could you please tell me what is high water mark in oracle terminology? Please explain with example. Databases oracle |
| | Hi, I have table (MyIsam) and want to set an index but fail to do so. Field : Varchar(10) Not Null Index Type : Unique Index Method : Hash Everytime I try, index method automatically assigned as BTree. Is this combination wrong for setting an index defined above? Thanks Databases mysql |
| | I have table of three column like Identifier Description Value P1 x 20 P2 y 20 P3 x 20 P4 y 20 P5 x 20 P6 y 20 P7 x 20 P8 y 20 P9 x 20 y 20 x 20 y 20 x 20 y 20 x 20 y … Databases mssql  |
| | Guys, I having problem converting the sql server function to mysql function. It work perfect at sql server now it now working at mysql. Please help.Thanks delimiter $$ CREATE FUNCTION SortingAlphanumeric(ColValue NVARCHAR(255)) RETURNS NVARCHAR(1000) BEGIN DECLARE p1 NVARCHAR(255); DECLARE p2 NVARCHAR(255); DECLARE p3 NVARCHAR(255); DECLARE p4 NVARCHAR(255); DECLARE Index1 TINYINT; … Databases mysql |
| | Ok, I'm developing a chat bot for a client. But I'm having a hard time figuring out the best way to do this. Because the bot isn't that big, I thought use a table with the phrase and the response. Then use LIKE. Not as easy as I thought though. … Databases client-server mysql  |
 | HI All, I have three tables tbl_category, tbl_subcategory, tbl_product . where categoryid is foreign key in subcategory table and subcategoryid is foreign key in prduct table. I want to show category and subcategory on home page menubar. I just reach upto display category on menubar but not able to get … |
| | Is there a way to use Order by RAND() for a query so that it returns a list of results and guarantees that adjacent values will be at least 'x' from each other, on either side? The results are all numbers, no strings. So if it returns 5 results r1 … Databases mysql |
 | Hi I'm trying to decide which **SQLite** book to get and was wondering if anyone has used either of the ones or others listed below? I could rely on Amazon testimonials but not sure I trust them. I have never used any database software outside of Microsoft access before so … Databases gui microsoft-access sqlite |
| | |
| | The query below performs fairly quickly, however when hit by several visitors at once causes the SQL Server CPU to spike greatly. How would you rewrite this query to reduce the impact? SELECT * FROM (SELECT TOP 1 a.adID, a.type, a.position, a.image, a.altText, a.caption, a.link, isNull(v.viewCount, 0) AS viewCount FROM … Databases mssql  |
| | I am trying to write a query to update multiple tables. Here it is: DECLARE @old_team_id AS int; DECLARE @new_team_id AS int; UPDATE Players SET team_id = @ new_team_id WHERE team_id = old_team_id UPDATE managers SET team_id = @ new_team_id WHERE team_id = old_team_id UPDATE draft SET owner_id = @newteam_id … Databases mssql |
| | Hi, I'm new to the forums and could really do with some help on the following... I've got a mysql query which i'm running to log a user in to a secure section of a website. I've successfully managed this on another website, however with the query i'm running it … Databases mysql |
| | Was wondering if anyone could recommend both free and not free report generator programs for use with SQlite. I'll need charts, colours and the ability to generate some pretty flexible reports. Any suggestions? Thanks danny2000 Databases sqlite |
| | Hi all, I have problem getting data from mysql table . What i am trying to do is that i want to get data from specific Category-id column and search a specific word or starting letter search from Name column , suppose this structure, -Database ---Table ------Category-id, Name My query … Databases data-structure mysql |
| | hi, iam not sure if this is sql question or not. but i just download "sql developer". from oracle website. and i need help setting it up. i want to connection to my localhost (myphpadmin). how can i find these things. connection name: no idea username: using myphpadmin username which …  |
| | Hi I have a real conumdrum here - I just can't expalin this behaviour!! A colleague has designed a view that contains the following : `CONVERT (nvarchar(4),YEAR(dbo.SYSFinancialYear.FinancialYearStartDate)) + N'/' + RIGHT ('00' + RTRIM(CONVERT (nvarchar(2), dbo.SYSAccountingPeriod.PeriodNumber)), 2) As YearPeriod` When you are in the design view, of the view and … Databases client-server microsoft mssql sql |
 | There are two tables - posts and comments: create table posts ( id integer not null primary key auto_increment, body text not null ); create table comments ( id integer not null primary key auto_increment, body text not null, post_id integer not null references posts(id) ); Now I want to … Databases mysql |
| | Hi guys, I'll doing a car rental database with 4 tables. Below is my the data after normalization..Could you guys pls tells me is it correct? If it's wrong, what to amend? Thanks so much.. Customer {CustomerID, FirstName, LastName, Address, ContactNo, Email} Agent {AgentID, FirstName, LastName, ContactNo, Email, RentaLID(FK)} Vehicle … Databases |
| | REATE TABLE [dbo].[BiddingTable]( [cAuctionId] [int] NULL, [idUserId] [int] NULL, [cItemId] [int] NULL, [vcBidamount] [nvarchar](50) NULL, [vcBidcount] [int] NULL, [bidQty] [varchar](5) NULL, [vcBidtime] [datetime] NULL, [status] [varchar](50) NULL ) ON [PRIMARY] INSERT [dbo].[BiddingTable] ([cAuctionId], [idUserId], [cItemId], [vcBidamount], [vcBidcount], [bidQty], [vcBidtime], [status]) VALUES (10, 36, 21, N'93.6', 1, N'0', CAST(0x0000A05500F83B44 AS DateTime), … Databases mssql  |
| | Hi, everybody I need to conduct a large amount of data analysis on database. Could anyone recommend an interactive application for data analysis? The requirements are: 1. Able to cope with the unexpected requirement rapidly. 2. Able to perform further computations on results interactively. 3. Easy to confront even a … Databases |
| | Hi, i got tis trigger CREATE PROCEDURE updateG AFTER INSERT ON gnojidba FOR EACH ROW BEGIN DECLARE box int; SELECT quantity INTO box FROM stock WHERE name = NEW.name; IF (box >= NEW.Qty_value) THEN UPDATE stock SET quantity = (quantity-NEW.Qty_value) WHERE name = NEW.name; ELSE UPDATE 'Error!' SET x=1; END … Databases mysql |
 | hi All, I have two tables table-1:customeramount table-2:customerpurchaseamount table1 have customers bonus amount and table 2 i have customers purchase amount now i need to calculate balance bonus amount i tried with following query but It shows unexpected result , could any one guide me.. SELECT CM.`custid`, SUM(CM.`amount`) - SUM(CP.`Amount`) … Databases mysql |
| | trying to build a database for user can upload images and stuff. i want to do so that 1-user can upload image 2-name image 3-discribe image 4-how many views that image have 5-how many fav image have 6-list all the messages(comments) 7-number of comments so i could need 9 fields? … Databases sql  |
| | That is my query. I am trying to select the item details for the items the user has in their inventory, but I DO NOT want to select the ones that are in their collection. So I'm trying to say where item_id IS NOT in the user_collection with their user … Databases mysql |
| | I have a starting query that displays appointments and I am trying to expand to get different statistics: SELECT apt.user_id, apt.appt_id, apt.client_id, apt.time_start AS stime, FROM_UNIXTIME(apt.time_start,'%Y-%m-%d') AS ftime FROM tl_appt apt LEFT JOIN tl_rooms r on r.room_id = apt.room_id WHERE apt.appt_id IS NOT NULL AND apt.appt_status_id = '3' AND FROM_UNIXTIME(apt.time_start,'%Y-%m-%d') … Databases mysql |
| | Hi, I'm writing a database for a computer shop and need some examples to look at. (It's not for a real shop, just a little project of mine) Where Can I find some templates for Access Database templates for a business like this? Databases microsoft-access ui-ux |
| | Hey Guyz I have a SQL Database Assignment i've done the first two tasts out of 7 and i need some help with the rest i can pay 150$ for anyone can help me with it ASAP !! Databases sql |
| | Hi, I have following table structures. # Table1 # link - varchar hlink - varchar top-cap - varchar (FK) sub-cap - varchar (FK) lk - varchar(PK) # Table 2 # cap - varchar(PK) caps - varchar captype - varchar top cap and sub-cap in Table1 are FK. They refer cap … Databases oracle |
| | hi, just want to maek sure some thing. so i have a table called user. in user table i want to add a field called date of birth. but i dont know which type to choice. it has int, varchar, date, datetime etc. but no date of birth. do i … Databases mysql |
| | Too weird but still I have a doubt.... I have two table.... -> OutpatientDetails -> InpatientDetails But the fieldnames are same except for the ID....i.e. OutPatientID and InPatientID respectively..... I want to combine both the tables and produce one output.....I dont know whether it is possible or no.... I want … Databases mssql |
| | I have two tables namely student and subject joined by a table called student_subject. With the following structure student: +----------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+--------------+------+-----+---------+----------------+ | student_ID | int(11) | NO | PRI | NULL | auto_increment | | studentCode | … |
| | Hi, I'm wondering if someone can help me with a problem I've been trying to solve for almost a week now which concerns shared ranking (i.e. whilst I am trying to rank things in order of one field, if two or more entries share the same value then they receive … |
 | Hey everyone, Is a database design based on Data Flow Diagram? Like, the number of datastores should be the same as the number of tables in the database? Cheers, Databases database-design web-design |
| | I have been working all day on sql developer but now i am trying to work again and when i try to connect it is giving me the following error what shall i do? oracle.javatools.db.DBException: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection at oracle.jdevimpl.db.adapter.CADatabaseFactory.createConnectionImpl(CADatabaseFactory.java:66) at oracle.javatools.db.DatabaseFactory.createConnection(DatabaseFactory.java:534) … |
 | Hi I have a single search field ' agent_name' in a form which is a dropdown field of data based on the concatonation of 2 fields: reg_fname and reg_lname When I do the SELECT Query though I'm getting a bit mixed up..... The data from reg_fname & reg_lname does not … |
| | Hi, I would like to know how to set a character set once and permanently, since when i alter the character_set% variables that are shown on 'show varables like 'character_set%', when i alter them the next day they are back with the old values? Thank you very much Databases mysql |
| | **I have been automatically collecting machine breakdown info to a database for 12 months, so I have thousands of entries in a 'Machine Downtime' table. However, I have found that the time_down column is offset by one row. The 'time_down' in the top row needs to be moved to the … Databases mssql |
| | Trying to do Parameters for Report in Reporting Services from a database that's in mysql . My Where clause looks like this: Where HD_TICKET.HD_QUEUE_ID="6" WHERE HD_TICKET.CREATED BETWEEN [Start Date] AND [End Date] GROUP BY (HD_PRIORITY.NAME) I get this error: ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.1.54-log]You have an error in your SQL … |
| | This is a dumb question, but I have honestly spent a long time today trying to figure it out, and I'm sure I'm not the only one who has trouble with this. How do you import a CSV directly into a MYSQL DB? I've tried using [CODE]LOAD DATA LOCAL INFILE … |
| | Hey everyone, I am just wondering what is based on what when designing a database.. Is an ER based on DFD? and Is a database design based on ER or DFD? I have got different names for data stores in my DFD and my other group member has different names … Databases database-design |
| | My table: $query = "CREATE TABLE categories ( id int(11) NOT NULL auto_increment, name varchar(100) NOT NULL, parent int(11) NOT NULL, visible tinyint(11) NOT NULL DEFAULT 1, PRIMARY KEY (id) )" ; The query: SELECT t1.id ,t1.name FROM flipkart_categories AS t1 LEFT JOIN categories as t2 ON t1.id = t2.parent … Databases |
| | Hi, I'm passing through hard times in d hands of this. I have created my database and i'm having issues replacing the content of my database table with the values i.v posted from my form. Please someone shld help Moi. |
| | Hi, i need to know how to convert ms access database to work on sql. Any help would be appreciated. Thank you Databases sql |
| | For the purpose of synchronizing data in sql server, such as: **1. Synchronize data between servers and client 2. When loss of internet, the client can still work based on the data required to run on the client. 3. When have the internet connection, data from workstations to be synchronized … Databases client-server mssql sql |
| | I'm not very good with php or mysql so I can't figure out what I'm doing wrong. I get this error: Failed You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'tests,'20120508,'5.5,'20120508)' at line … |
| | I really hope someone can help me with this one. It is a Hotel Booking System: Tbl Room (RoomID, Floor, Notes) Tbl BookingsRoom (RoomID, BookingID) Tbl Bookings (BookingsID, StartDate, EndDate, Comments) I have to create an SQL select statement for checking if a room is bookable during a given time … Databases sql |
| | I have an ssis package the loops through an entire folder importing records into a sql 2005 database. I pull these records from a table in my database through an "execute sql task" then that gets pushed into the foreach loop container. However when one of the filenames is missing … Databases mssql |
| | I know there are multiple variations of this question here, but not in this form. My Ledger table, in a basic form have the following columns. TransactionID | DateOfEntrydate | TransactionDate | ClientID | TrIsDebit | OpeningBalance | Amount | ClosingBalance DateOfEntry is a colums which stores time of insert … |
The End.