Hi friends,
I have a table with cols ( gameid , score , userid ) where gameid is a value from {1-10} represting a unique game . I store only top 10 scores for any game to see the top...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi i have got a database with the following tables below:
Patient (PatientCode, PatientSurname, PatientFirstname, PatientSex, Age, PatientOccupation, PatientHeight, PatientWeight, Pa...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi All,
Is there any possibility to change the date format in mysql to dd/mm/yyyy format.If Possible please explain me with an example.
Thanx.
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello,
I have multiple DBs on one webhosting account they are running similar versions of a shopping cart. Many of the table names are the same but all of the scripts are located in...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi all,
I hope someone can help. I'm a PostgreSQL veteran but have found myself working on a client system based on MySQL, and the transition has been a little rocky
Right now I'm tryin...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I have a MYSQL database with several large tables (approx 30million records in each)
We received a daily update of approx 50k of records in 2 of these tables.
As you'd imagine over a 3 year pe...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
hi, how do i insert images into mysql database 5.1 upwards?
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I have an educational program that stores its information in a "flavor" of mysql. Unfortunately our tech support has run out and i need access to this database directly because it has cr...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi,
I am new bie to MYSQL. I have a requirement of data migration from one DB to another DB in MYSQL.Tables structure and column names are different in both source and Target.I need to Auto in...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I have a query that I put together which combines 3 tables. There is a WHERE clause applied to a field in one of the tables. The problem is if there are no records to satisfy the where clause for ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi all
Tell me the advantages of MySQL over other databases
Thanks
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi all,
Server in question:
WinServer 2003 (x64)
IIS6.0
PHP5
MySQL Server 5.0
The problem:
I am receiving the following error message:
Code:
Warning: mysql_pconnect() [fu...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Do you know why when I am using PhpMyAdmin I am getting rows like ::
1 [BLOB - 8o] [BINARY - 1o] [BINARY - 1o] 0
and not the text values ?
the columns are varchar(45)
and the table E...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello all,
I'd like to know how to clear down mysql binary logs from a script.
I have a script which runs this:
"C:\Program Files\mysql\bin\mysql" -uroot -prootpasswd < C:\Cle...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi, I am an IT student and now I am writing my degree thesis that talks about HOLAP and MDX query (and much more). I am reading this tutorial: http://www.databasejournal.com/featu...0894_1495511_1...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi,
I'm new to MySQL and I'm trying to make a command which will check database integrit(dead links, when a table is linked to another table which was deleted...)
Code:
DELETE FROM `characte...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi guys. I would like to send SMS messages from a MySQL server to mobile phones. Can you recommend a solution? I have already found a solution but it is quite expensive. Do you know a similar solu...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
-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...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
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...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi,
In select query i want to display the time difference between 2 datetime field like(00:01:30), PLEASE HELP ME.
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
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...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
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...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
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...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
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...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
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...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Browse sub-categories 
