Sponsored Links

comp.databases.mysql comp.databases.mysql

Page 1 of 66

Last »

Threads in Forum : comp.databases.mysql

Forum Tools

Search this Forum

Rating Thread / Thread Starter	Last Post	Replies	Views
Error during restore 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	0	325
Table with 400000 rows takes a long time to count 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	0	73
order by problem 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	4	65
Preserving old records states 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	2	68
Good GUI query builder 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	3	66
query with an AND condition over a same column 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	4	72
Command Line Client 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	2	67
DROP TABLE name IF EXISTS 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	4	69
Run MySQL stored procedure from VBA in Access 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	0	73
no root user in mysql user table 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	1	66
Many-to-many simple SELECT [newbie] question 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	1	62
adding information to existing existing data 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	1	64
Two Oldest Records 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	1	66
Two oldes records query 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	0	61
Archiving Data 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	1	64
Selecting between 2 dates 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	3	67
two tables two databases 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	7	66
how do I combine 2 tables???? 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	1	64
WHERE expression comparing with set of values 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	5	68
Outer Joining Multiple Tables 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	4	59
insert and get ID 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	5	65
Incrementing a unique field by one ( 1 2 ) 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	10	98
INSERT INTO Return value // LAST_INSERT_ID() problem 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	1	59
problems ordering result by paramters Hi! I have a table: +-------------+---------------------+------+-----+---------+ I want to order the results by language (column... Tamer Higazi	01-08-2008 10:03 PM Tamer Higazi	3	65
stats database structure - design suggestions ( 1 2 ) 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	19	98
Re: MySQL uninstall, hack, password restore? 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	0	61
Alternative to DATEDIFF in MySQL version 4.0 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	6	62
Re: compiled mysql 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	1	67
Return Values from INSERT 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	9	64
database has a semicolon 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	3	66
Connect to mysql on home network ( 1 2 ) 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	11	91
excel macro to create insert statements 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	1	72
Re: Can IntraWeb be used with MySQL without Borland/Retarded/BDE Crap and still interface with DB Web components ? 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	8	73
Make a replica on a remote DB 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	8	64
Re: Retrieving formatted date in select query 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	1	63
where in select; should be simple 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	4	64
Storing tags / array 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	4	154
update field with increment values 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	4	110
'Access denied for user 'root' 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	3	130
MySQL problem: date calculation 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	8	61
Convert .myd file to SQL Query? ( 1 2 ) 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	12	556
choosing a date 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	4	127
can't read file into a table 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	8	127
After Insert Trigger 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	4	131
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and(utf8_general_ci,COERCIBLE) for operation 'if' ( 1 2 ) 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	13	176
How to write this update statement? 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	6	113
Query running very very slow 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	4	119
Help with Update 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	3	112
Loose ODBC conection with access 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	1	128
newbie: how to change admin email? 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	7	112

Page 1 of 66

Last »

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	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