dbTalk Databases Forums  

Sponsored Links


comp.databases.mysql comp.databases.mysql


Discuss in the comp.databases.mysql forum.



Post New Thread
Threads in Forum : comp.databases.mysql Forum Tools Search this Forum
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
When I try to restore a backup on a local machine ... during the restore I obtain this error Error while executing this query:CREATE TABLE...
Valeria
01-13-2008 08:18 AM
Valeria Go to last post
0 325
I have a table with 400000 rows and when I do a: SELECT count(*) FROM table1; it takes over three minutes to come back - the table is...
InvestorTrade
01-13-2008 07:52 AM
InvestorTrade Go to last post
0 73
In a mysql database is a field called 'number' which is actually filled by numbers. In a query I want my results ordered by number so the last clause...
Jannis
01-13-2008 07:36 AM
Paul Lautman Go to last post
4 65
The relational db advantage that is after normalization data is not duplicated like in old flat-file days. But I am trying to understand how I would...
Jonathan N. Little
01-12-2008 09:51 PM
Michael Austin Go to last post
2 68
Hi: I'm looking for a GUI query builder for a non-technical person who is fluent in excel. I'm thinking like pivot tables in excel. Anyone know of...
Miked
01-12-2008 02:56 PM
nickyb Go to last post
3 66
Hello, I would need to query with an AND condition over a same column. I have a table like this: LANGUAGES( ID varchar(100) NOT NULL, PERSON_ID...
nntp.aioe.org
01-12-2008 01:22 PM
Paul Lautman Go to last post
4 72
Hello, I'd like to install JUST the command line client.I go to MysqlAB and download the Essentials package and run it. I click that I dont want the...
AMP
01-12-2008 01:00 PM
AMP Go to last post
2 67
What standard defines the "IF EXISTS" clause of the DROP TABLE or CREATE TABLE syntax? Sorry if this if off topic, asked out of curiosity as to why...
CJ
01-12-2008 10:26 AM
Michael Austin Go to last post
4 69
In MySQL I have a stored procedure which uses one integer parameter - stored_proc(n). In Access I have a form which sets the parameter "n", either in...
Gary
01-11-2008 08:51 PM
Gary Go to last post
0 73
Hi all, I am using a 1and1 dedicated linux server. They already have mysql database installed ready to use. But it doesn't have root user in...
bbc.bby@gmail.com
01-11-2008 07:14 PM
Gordon Burditt Go to last post
1 66
Hi, I'm starting to learn SQL and trying to use it with PHP. I'm stuck on a textbook example of many to many relation. I have a Books...
Andrzej kK
01-11-2008 04:18 PM
Rik Wasmus Go to last post
1 62
On Fri, 11 Jan 2008 20:23:35 +0100, J.O. Aho wrote: Not that the WHERE clause doesn't have to be there, or can be based on any other selection...
Auddog
01-11-2008 01:45 PM
Peter H. Coffin Go to last post
1 64
Hi, I have a inventory transaction table with a couple of millons entries. It has at least 3,000 types of inventory. Date Range from 2000...
Bre-x
01-11-2008 11:06 AM
Captain Paralytic Go to last post
1 66
Hi, I have a inventory transaction table with a couple of millons entries. It has at least 3,000 types of inventory. Date Range from 2000...
Bre-x
01-11-2008 09:48 AM
Bre-x Go to last post
0 61
I would like to archive data that we no longer need on a regular basics. We will need to query it maybe once every three or four months. I would...
Bre-x
01-11-2008 08:13 AM
Peter H. Coffin Go to last post
1 64
Hi There I have a holidays table with the following structure:- hols_recid - int hols_employee - int (Relates to an empoyee table) hols_datefrom -...
bmguk01@googlemail.com
01-11-2008 07:05 AM
Captain Paralytic Go to last post
3 67
I have two databases database1 and database2 in each database i have a table called Suppliers. the suppliers are the same and I want that any change...
Pianto Tardivo
01-11-2008 03:29 AM
Captain Paralytic Go to last post
7 66
hey everyone, I know this is a total noob question but please help. I have 2 tables that I was given that I would like to combine into one. ...
agilehack
01-11-2008 02:36 AM
Kees Nuyt Go to last post
1 64
Hi folks, I want to find all rows where a certain column's value is within a set of values, e.g. HAIRCOLOR is in the set {'blue', 'red', 'green',...
plenty900@yahoo.com
01-10-2008 10:06 AM
Peter H. Coffin Go to last post
5 68
I have 3 tables that I want to join like so... table 1: USER --------- uid first_name last_name
DonO
01-09-2008 12:17 PM
DonO Go to last post
4 59
hey all there please tell me which query can i use to: 1. insert a new row to a table which has exactly one unique auto intrement field (let's call...
Peter
01-09-2008 09:32 AM
Peter Go to last post
5 65
Hi Ng, In my database, I have a column, containing identifiers (numbers), which I would like to keep unique. Some times, it is necessary to...
Kasper Lindberg
01-09-2008 03:01 AM
Kasper Lindberg Go to last post
10 98
Hi everybody, I'm working on a relational database and am facing a problem to build a SQL query which in ONE query that updates all the necessary...
Marijn
01-09-2008 02:39 AM
Willem Bogaerts Go to last post
1 59
Hi! I have a table: +-------------+---------------------+------+-----+---------+ I want to order the results by language (column...
Tamer Higazi
01-08-2008 10:03 PM
Tamer Higazi Go to last post
3 65
Hi, Currently on my site all my 'pages' are saved in the db. Each page has a 'counter' field. Every time the page is accessed I increase the page...
FFMG
01-08-2008 09:20 PM
Peter H. Coffin Go to last post
19 98
On Mon, 7 Jan 2008 19:36:20 -0800 (PST), Bunsenator <Auston.Bunsen (AT) gmail (DOT) com>...
Kees Nuyt
01-08-2008 04:17 AM
Kees Nuyt Go to last post
0 61
The host server I am using is MySQL version 4.0.27-standard, which does not have DATEDIFF. I am asking the host to upgrade, but in the meantime,...
Adrienne Boswell
01-07-2008 08:50 PM
Adrienne Boswell Go to last post
6 62
12 monkeys wrote: Pretty old. AFAIK the libc-dev package in 3.1 (aka Sarge) does not support NPTL. So everything you compile there will use LT by...
Axel Schwenke
01-07-2008 06:22 PM
Axel Schwenke Go to last post
1 67
This is probably a daft question. I want to know if there is a way to get a primary key value back from an INSERT statement for later use,...
Taliesin Nuin
01-07-2008 08:55 AM
Taliesin Nuin Go to last post
9 64
I have a database in MYSQL that has a semicolon on the end. ie: db1 db2 mytestdb; db3 .... I can't seem to drop this database, since the...
Reacher
01-07-2008 08:49 AM
Luuk Go to last post
3 66
Hello, I am trying to connect to a mysql db on a home WORKGROUP. I tried ip(given out by router) and Computer name. I get "Mysql is not a...
AMP
01-06-2008 08:07 PM
Jerry Stuckle Go to last post
11 91
are there any excel macros that will create insert statements. i tried the data loader, if the data looks like...
Junkone
01-06-2008 05:10 PM
Paul Lautman Go to last post
1 72
Hmm, that's the strange, When I used: mysql -u root -p and enter the password it didn't work. Then I tried:
Skybuck Flying
01-06-2008 02:15 PM
Jim P Go to last post
8 73
Sometimes I have to make a replica on a remote mysql database... how can I do? i tried with the backup utility but it will update also the data... I...
Dr. Fred on Vista
01-06-2008 08:20 AM
Steve Go to last post
8 64
seastl < wrote: Of course it does - you overrode the column name and used the results of the call to date_format(). Just change it to...
Jerry Stuckle
01-05-2008 05:08 AM
Paul Lautman Go to last post
1 63
For searching houses I want to make a form with two options: name of street and house number. I have a table of names of street in a town each with...
Jannis
01-05-2008 03:48 AM
Jannis Go to last post
4 64
I know there is plenty of info for this, however I'm having some trouble, and would love if someone could give me some info. I want to tag objects...
herbasher
01-05-2008 01:23 AM
herbasher Go to last post
4 154
Hi everyone .. i am wondering if it is possible to update a field where filed values are null with increment values i can do same in php by using...
php_mysql_beginer911
01-04-2008 02:13 PM
Norman Peelman Go to last post
4 110
I've just installed mysql5 under Solaris 10. I installed it as root. Every thins seemed to go well, and then I attempted to...
milan_sanremo
01-04-2008 12:32 PM
milan_sanremo Go to last post
3 130
Hi folks, I'm having a problem with MySQL. I have a table, one of whose columns is called `date`, which is a timestamp. I need to SELECT all the...
plenty900@yahoo.com
01-04-2008 12:21 PM
Luuk Go to last post
8 61
A table in my MySQL database has become corrupted and I need to restore it from a backup. Unfortunately, the only backups my web host provides are...
karljcox@gmail.com
01-04-2008 11:43 AM
karljcox@gmail.com Go to last post
12 556
Hi there, I'm trying to create a sql statement in which a date is compared to another date and depending on the comparison one is chosen. such...
Sjef
01-04-2008 10:58 AM
Sjef Go to last post
4 127
I am taking the MySQL tutor lesson http://dev.mysql.com/doc/refman/4.1/en/loading-tables.html but when I use the command LOAD DATA LOCAL INFILE 'my...
don
01-03-2008 05:28 PM
Kees Nuyt Go to last post
8 127
server: Server version: 5.0.38-Ubuntu error: MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your...
Bre-x
01-03-2008 04:47 PM
Bre-x Go to last post
4 131
Over the holiday we moved our production mysql database to a new server, and in the process went from v. 5.0.18-nt to 5.0.45-community- nt. An...
Steve
01-03-2008 12:54 PM
Steve Go to last post
13 176
Hi, I'm using MySQL 5.0. I have a couple of columns in my table T ... ID INTEGER UNSIGNED AUTO_INCREMENT, ORDER_ID INTEGER UNSIGNED The "ID"...
laredotornado@zipmail.com
01-03-2008 05:28 AM
Paul Lautman Go to last post
6 113
On Jan 2, 9:16 pm, "J.O. Aho" <u... (AT) example (DOT) net> wrote: I have to be certain that the id returned is in B.artist and that the name or...
gianpaolo
01-03-2008 02:53 AM
gianpaolo Go to last post
4 119
Dear List, Could someone point me toward a solution to this update? I have a table that might have duplicate values in the field p_h. I would like...
Bob Smither
01-02-2008 05:10 PM
Bob Smither Go to last post
3 112
I am very new to all this I have a access databse wich uses a ODBC conection to mysql server. I can open the and run the database find but if i...
S.Dickson@shos.co.uk
01-02-2008 10:45 AM
John Murtari Go to last post
1 128
Hello, I have installed MySQL 5.0. I have also installed PHP5 and phpMyAdmin. The problem is that phpMyAdmin cannot use MySQL because of error: #1045...
R.A.M.
01-02-2008 07:13 AM
Kees Nuyt Go to last post
7 112
Post New Thread

Display Options
Showing threads 1 to 50 of 3279
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.