7,494 Archived Topics
Remove Filter  | |
| | Is there a simple and straightforeword way to limit mysql's general query log to a certain size? Keeping the log quickly gets out of hand, it grows by nearly 10mb per minute. I only need the recent 30 minutes or so though. Is there a way to just limit it … Databases mysql  |
| | Hello to everybody I have a problem with a MYSQL query and I almost got it but am stuck for a while now. I would appreciate if anyone could help me or point me in the right direction. I have 3 tables: [icode][B]t1 (products)[/B] id | name ---+------- 1 | … |
| | Look at this image: [URL="http://www.roflsaurus.com/users/durexlw_QuickUL/SQL_join5Tables.jpg"]http://www.roflsaurus.com/users/durexlw_QuickUL/SQL_join5Tables.jpg[/URL] I want to select everything of tblPersons where all taskorders are connected to that person and where tblSteps.done = 0 and where tblPersons.id = a certain ID... needless to say: my head hurts and I can't seem to figure this one out. Any help is … Databases mssql |
| | Hii i am building a financial database. And I have data for each stock for all the days. I want to avoid multiple entry of a stock for the same timestamp in the database. For eg I dont want to have the data for google on 30 jun 2010 twice. … Databases mysql |
| | Good afternoon everyone, I am trying to figure out the best solution for the following database. Any comments would be appreciated. The product will track recurring training. The part that I need suggestions is this. For simplicity, let's say the org has 20 employees and there are 20 training classes. … Databases |
| | the below code is causing two records to be inserted into mysql. I have no idea why. when i remove it no record is entered. When i add it two duplicate records are entered. Any idea why? it is in an if statement. What would cause it to be inserted … Databases mysql |
| | Hi..... How to access the MySql using servlet.... Now am using Mysql 5.0 & MyOdbc 3.51 What type of connector to be used?... We used the following syntax..is it correct?or not? Class.forName("org.gjt.mm.mysql.Driver"); Connection cn=DriverManager.getConnection("jdbc:mysql://192.168.1.38:3306/suba","root","erp"); Whenever i execute this program i got the error like this [B]ClassNotFoundException: org.gjt.mm.mysql.Driver[/B] Databases mysql |
| | Hello.. I need to query out most demanded products from my database... i have order table(order id, date, ...), orderitem table(order id, product id and quantity), and product table.. i don't understand how to write a query for this.. can someone kindly help me? Databases mysql |
| | Hello, i am trying to update a table row from a form the code is: [CODE]<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" name="votim" id="votim"> <p> <input type="hidden" name="email" id="email" value="<?php echo $usernamepervotime ?>"/> <input type="hidden" name="vota" id="vota" value="<?php htmlentities($row_VotaMiss['vota']+1); ?>"/> <input type="hidden" name="ID" id="ID" value="<?php echo $row_VotaMiss['ID']; ?>"/> </p> <p> </p> <p><a … Databases mysql |
| | I am trying to populate a SQL entry with data from a php script but it doesnt work. I have the config file set up right and everything. This is the code I have [code] <? include_once "secure/dbconfig.php"; //check md5 $SECRET = 'xxxxxxxxxxxxxxxxxxxxxxxxx'; $sig = md5('userId'+":"+'appId'+":"+'SECRET'); if($_REQUEST['sig'] == $sig) { … |
| | Am having serious problem with creating and installing membership registrations and login database, the most troublesome is the area of creating a database table on the mysal php5 +, Please anyone with a brief and understandable A to Z Coding of these tables should please post it to me, i … |
| | hello i am working on this application where i need to import 60k+ user data and insert into different table. i have made a C# application which selects the database and inserts from a text file.like [CODE]insert into dbo.dbname ([user_name],[u_id]) values (a,b)[/CODE] but this apps hangs for 60K+ data so … Databases mssql |
| | Hey guys, I was hoping someone could help me out here again. I've seen people pulling entries from multiple MySQL tables by using the JOIN clause, but I can't seem to get it to work with what I am trying to do. I have 3 tables which I wish to … Databases mysql |
| | Hi Im still quite new when using MS SQL but I have a pretty good understanding of it. -I am using Crystal Reports to retrieve and manipulate data from my database. -I am creating small tables for certain data. -This data is selected from a constantly updating table. So i … Databases mssql operating-system |
| | Can any one tell me, what is the difference between SQL and MySQL? |
| | Hi, I have created a data entry user form in MS Access 2007 which pulls out and puts in data from/in 3 different tables, When I create a new form(a new record should be created in all 3 forms with my primary key), I can enter data in fields from … Databases microsoft-access |
| | I am developing a website,where I am using windows authentication for my connection. I want to change that to server authentication. I want to know what are the steps needed, at what should I watch out, and is there any problems that will appear in my project due to this … Databases mssql windows-server |
| | Hello, I don't have technical problem. I was just thinking the difference between arrays and SQL. I am currently learning OOP in java and C# but my employment history is based on SQL Server. So I was thinking about this subject in my head and I don't see why bother …  |
| | Hi..I'm new here, posted my problem before but can't really keep track of it, don't know where it is so i decided to start a new thread,, i hope this is not a problem... I'm trying to create a database for a school..it should be able to incorporate virtually everything … Databases |
| | Hi, been looking all night on net but cannot find ORDER BY Month anywhere. This is my query: [CODE]SELECT MonthPaid AS XLABEL, SUM(Amount) AS YVALUE FROM monthlycommission WHERE YearPaid= NOW( ) GROUP BY MonthPaid[/CODE] However when i display this it goes June, March then May I want to add an … Databases mysql |
| | Hi I have encountered the following error: Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server during query in I don't know what is exactly the local host: shell I use only my domain or I need to use a special path...I would appreciate if somebody can help on this. Thanks! … |
| | Hi I have designed a database for use in an academic arena, but I have come across a problem that I can't find an answer to in the help files or on the web. I think it is something really simple but frustrating to put right! I have designed a … Databases microsoft-access |
 | Hi there. how can i limit the value of records in Access. Is there a LIMIT function in Access like in MySQL? tnx in advance.. Databases microsoft-access |
| | Hi, I got a question to check if a date time is within another date range (So as to check conflicting schedule) There are various possible types of schedule: 1: One time start - end event. Typically such schedules is like a tour / outing / camp event, and hence … |
| | Help I am very new to MySql. I have inherited a website. The previous webmaster used a MySql database for news items. I took a back up of the whole site using FTP, then restored simply by FTP the files back up, but the database now seems corrupt I have … Databases mysql |
| | how do i fix this? the error says that the column count does not match value count. thanks in advance!:) -- -- Definition of table `assets` -- DROP TABLE IF EXISTS `assets`; CREATE TABLE `assets` ( `_id` int(10) NOT NULL auto_increment, `_controlNum` varchar(255) NOT NULL, `_category` varchar(255) NOT NULL, `_subcategory` … Databases mysql |
| | Hello How can I clone a database in MS SQL 2005 Express? I have the original database and I want to create a new database that has to be the same as the original one. regards, Vedro Databases mssql |
| | Hi This is John I'm currently developing web based application for a company.And Iknew about Web design,Visual Basic.Net,mysql,php,java,c++,System analysis...etc.[B]But my question is i don't have any adea how to tart, What is the necessary component(based on knowledge,software,hardware) must i have.[/B] This system has many data base,There may be a transactin … Databases database-design visual-basic web-design |
| | hi,can any one help me in my project.actually, i have decided to do project on ebanking but the problem is where to start from and how to decides the content of the table and its schema as banking has many dimension but i think i would like to focus on … Databases database-design |
| | i get an error here Can't create table '.\itams\assets.frm' (errno: 150) [icode] -- -- Definition of table `branch` -- DROP TABLE IF EXISTS `branch`; CREATE TABLE `branch` ( `_id` int(10) NOT NULL auto_increment, `_branchName` varchar(255) default NULL, `_branchAddress` varchar(255) default NULL, PRIMARY KEY (`_id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1; -- … Databases microsoft-office mysql |
| | Hello: listed below is the order for the creation of tables and execution of ALTER TABLE resources in an Apache Derby Embedded db; Note the error at: alterInstructor. I create the instructor table then the booking table. The instructor table has book_num FK. After the booking table is created I … |
| | Hi! I'm trying to create my own little community for learning purposes and I'm having some trouble with getting the data I want from the table. I'm not that high on SQL but I know the basics but when you get into the more complex mysql-lines I get lost. The … Databases database-design mysql sql |
 | Hello, I am brushing-up on SQL (using MySQL). It has been many years since I have worked with this and I'm having some trouble getting started. I have looked at a tutorial and entered the code below: [CODE]CREATE TABLE employees ( employeeNumber into(11) NOT NULL, lastName varchar(50) NOT NULL, firstName … Databases mysql |
| | I'm currently linking two different tables in two different databases. One contains all the info from a product, while the othe contains information about the installation of the product. The SQL I use only returns those products that HAVE an entry in my install table, but many don't ie they … Databases mysql  |
| | When I try to design relation database using MSSQL Server 2008, I find that the MSSQL Server 2008 allow designer can create two relationships with one direction from a table to other table (for example, I have two table A an B, I can create two relationship from table A … Databases database-design mssql web-design |
| | Hello, for a database project (music festivals) several search options are to be included. While some search fields will be filled from a dropdown list (like "countries"), other will have a fuzzy option (like "song titles"). For this I want to use the full-text search (you may remember the words … Databases mssql programming-construct sql |
 | Hi, I'm currently designing the schema of my database for an application. and there's this table that has a default content or records. i'm torn between what type should i use for its key, because im always using autonumber, i was thinking that because i have a default content for … Databases mssql |
| | Hi! I need some help please! I have to create a DB that has to be normalized to 3NF. I have a table 'Products' that contains info about all the products - product_ID, product_name, quanitity (left in warehouse), procurement_price, sales_price. And I have [B]TWO[/B] more tables that contain info about … |
| | I am trying to insert data from one column in one database into a column in another db. the tables already have the column in place. they both have a unique identifier column (userid) I wrote a little insert statement, but when I try it I get the following error … Databases mssql |
| | Hi, I'm actually drafting a MySQL query to be fed into Jasper Reports, and since I can no longer manipulate the resulting data in PHP as it will automatically be translated into a chart by jasper, I need my mysql statement to be able to generate what I need on … Databases data-structure mysql |
| | Hi, got some help from tesu on another thread but i am struggling to get this working. my individual query returns 2 results which is correct from the database. however when i try it with a view joining the multiple table with same query it returns 2 results but only … Databases mysql |
| | Hi, I am setting up a notes table, and wondered what the best type would be? Currently i have set it to Varchar with length 500 Would that take up more space than say a Lontext type in the database? Thanks Databases mysql |
| | Hi, I got some great help on the forum to create my total due query. However it produces it with just total due, how could i have it by month? each table has a DueDate column which i would like to show on the query along with the users FullName … Databases mysql |
| | Hi guys, Need some help here. I have created an individual query for each product which works absolutely fine. However i want to be able to join it so i can display on my page who is due for a review. [CODE]SELECT clients.*, protection.* FROM (clients JOIN protection ON protection.clients_ClientID=clients.ClientID) … Databases mysql |
| | Hi, I need help bad, im trying to make an E-R diagram from the following: The City House Service (CHS) is an onoprofit service that advocates the development and inprovement of low-income housing. The CHS operates in a metropolitan area of approx. 2.2 million people in a mid-west city. The … Databases |
| | hello all! Anyone know how to count all the constraints in a given table? I'm new to stored procedure and need it to finish some work. Databases mssql |
| | please tell me how i make a sql query for selecting data's from a table where that data repeated 4 times in that column |
| | Hi all, i want to transfer data one sql database to another database in same sql server. i try to insert into table2 select * from table1 , but this query useful for same database, but i want to use different database, in same sql server. help me here to … Databases mssql |
| | Hi, I'm trying to build an Access database on Access 2007 and I'm unsure of how to do a few things. I have 2 fields: field1 and field2. Both are dates. I want field2 to change to exactly a month after the date in field1 and I want it to … Databases microsoft-access  |
| | Hi, I am somewhat new to PHP and MySQL and I am having a little trouble with what I want to do, which is assign a cell for each option selected and a price or insert the price into MySQL table depending on the option selected. Whichever is easier or … |
The End.