BoardTracker - MySQL

database survey... the old link was wrong...

Fri, 22 Aug 2008 00:00:00 GMT

-i'm so sorry about the first survey... the link was totally wrong... i just found out now, i looked like spam... darn it... please check the new link... thank you- Hi everyone! We have fini...

db design or query...

Thu, 21 Aug 2008 00:00:00 GMT

hi, I am fairly newb to mysql, so excuse my silly question. I am working on a vbmysql application for a warehouse. Here I am importing an excel sheet to mysql which has weekly status of the pro...

Sql Server 2005 - Time Difference...

Mon, 11 Aug 2008 00:00:00 GMT

Hi, In select query i want to display the time difference between 2 datetime field like(00:01:30), PLEASE HELP ME. ...

Numeric data type for 17,6...

Wed, 06 Aug 2008 00:00:00 GMT

Hi, I need to store a dollar value for NUMBER(17,6), but when I use Decimal(17,6), I keep getting syntax error. How can I store a number with 17 significant digits w/6 numbers after the decima...

MySQL stored proc vs MS-SQL stored proc...

Thu, 17 Jul 2008 00:00:00 GMT

I have tried this a few different ways, but I keep getting the same error message: MySQL Error Number 1064 You have an error in your SQL syntax; check the manual that corresponds to your MyS...

MySQL WHERE clause using LIKE...

Wed, 02 Jul 2008 00:00:00 GMT

I have a column in a table that contains domain names. I want to use the $_SERVER['HTTP_HOST'] value to see if the domain name exists in my table. If one of the rows has 'abcdomain.com' in the dom...

JOIN with multiple WHERE...

Fri, 20 Jun 2008 00:00:00 GMT

Hi all. I am currently trying to achieve the following I have the following two tables TABLE 1 - USERS Ident | Name -------------------- 34 | Dave 35 | Adam 36 | L...

Insert Array 2 Dimensional Into Database...

Wed, 18 Jun 2008 00:00:00 GMT

hello.My problem is,I want to insert the value in my array into the database. Here is my coding.(Im using PHP). ------------------------------------------------------------ for($i=5;$i<=1...

MERGE STORAGE ENGINE Vs UNION ALL...

Wed, 14 May 2008 00:00:00 GMT

Hi, Can anyone tell me if and how, a MERGE STORAGE ENGINE results in a better performance or a faster query than using a UNION ALL? Let me explain my requirement in detail. I have the foll...

database...

Tue, 06 May 2008 00:00:00 GMT

Can any one help me out with creating a rearrangeable mysql database? The database will have the information already loaded for the time being. Eventually I need to create a form to add and delete...

arrangeable Database...

Tue, 06 May 2008 00:00:00 GMT

I have a question about creating a MYSQL Database structure. I want to create a table full of information that would look similar to that of an excel spread sheet. How would I create such a databa...

Grant's order in sql...

Thu, 01 May 2008 00:00:00 GMT

First of all iam so sorry because my english is very bad...I hope you can understand what i want to ask... first that I wanted to ask what was that had heard or knew about the control of data ...

Transfer information from an access database to MySQl database...

Sat, 19 Apr 2008 00:00:00 GMT

I am new to working with databases. What I need to do is to transfer information from an old system that has been ran through access on a local server inside an office to a new system that is buil...

How to get the machine name?...

Tue, 15 Apr 2008 00:00:00 GMT

How do you get the machine name of the current computer in MySQL? e.g. KevinPC. In MSSQL, I could use: Code: CONVERT(varchar(200), SERVERPROPERTY('MachineName')) to get a strin...

problem query from access to mysql...

Sat, 15 Mar 2008 00:00:00 GMT

sorry my english bad, i have trouble from my query, before migrate to mysql i use MS access, now i have problem query here select `qrstock`.`ID_BARANG` AS `ID_BARANG`,`qrstock`.`BARANG` AS `BA...

mysqli prepared statement (parameter limit)...

Tue, 11 Mar 2008 00:00:00 GMT

Hello, I just started to switch to mysqli. PHP version is 5.1.4 and MySQL 4.1.2 It is working fine until I would like to use a 16th parameter. The error message is that the amount of...

group by giving odd results....

Fri, 07 Mar 2008 00:00:00 GMT

I'm using: mysql Ver 14.12 Distrib 5.0.26, for pc-linux-gnu (i686) using readline 5.1 within a PHP Version 5.2.2-pl1-gentoo script. I have 3 tables: members: usernames with unique id...

Help with query (sorry if double posted)...

Fri, 14 Dec 2007 00:00:00 GMT

Hey all, my last msg didn't post. I thought it might be because of the link so here it is without.... If anyone has a second to look at a query I would be incredibly grateful. My SQL skills a...

Select Statement that join to different tables based on Field Contents...

Fri, 30 Nov 2007 00:00:00 GMT

Purpose of Post: To create a SELECT statement that returns results from multiple tables, choosing which tables to retrieve values from based on NULL fields within the main (comics) or intermediate...

about normalization...

Tue, 20 Nov 2007 00:00:00 GMT

hi , i m new here, and doing some project in mysql , can any one help me out, its about the normalizing the tables, in what kind of circumstances we do not need to normalize the tables pls guy...

store incoming MySQL connections to a table...

Wed, 31 Oct 2007 00:00:00 GMT

I am trying to store incoming MySQL connections to a table. I currently run mysql 4.1.22 and can�t seem to set it up in a way. I have been looking around but unable to find data that will assist m...

could you help us?...

Wed, 24 Oct 2007 00:00:00 GMT

hello, that server supplier was down our website, they said our database is overload, detail info: " Here is a copy of the queries that have caused the overload: 1.Time: 36% (3252 sec...

WAMP Setup - error undefined function mysql_connect()...

Wed, 26 Sep 2007 00:00:00 GMT

Hi, I am trying to set up a WAMP - Windows, Apache, MySQL, PHP combination environment on a Windows XP machine. Apache and PHP together seem to be configured and working fine. MySQL works...

Can anybody please help??...

Wed, 26 Sep 2007 00:00:00 GMT

I have set-up a MySQL database called test_db with table authorised_users. user_name varchar(35) user_id varchar(16) user_password varchar(16) account varc...

Help with Godaddy - I Know Nothing :confused:...

Wed, 26 Sep 2007 00:00:00 GMT

Hi every body, let just say that I'm kind of new at everything having to do with server-side web anything. I'm currently taking a class, to learn a little about SQL, however I'm trying to appl...