Sponsored Links

comp.databases.mysql comp.databases.mysql

Page 4 of 128

104

Last »

Threads in Forum : comp.databases.mysql

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
mysqli connection error On Thu, 01 Sep 2011 15:52:35 -0700, Michael Vilain wrote: He said the logs say mysql server is waiting for connection. But we do need to find out... css-discuss.org	09-04-2011 01:26 AM Gordon Burditt	5	6
SELECT * works but SELECT FIELD1,FIELD2.. gives "supplied argument isnot a valid MySQL result" Hello People, here is a problem I don´t know how to solve. I would appreciate some clue for it. In all my tables I use normally SELECT... mig	09-03-2011 03:35 PM The Natural Philosopher	5	6
Checking if a String match to a list of values. Hi everybody, I'm new on the list, this is my first topic. I was wondering if it's possible to check for a string ( a url, name, etc ) matchs with a... Leandro Costa	09-02-2011 02:49 PM Peter H. Coffin	3	4
Video - Big Data: It’s not the size; it’s how you use it CEO of Yellowfin's talks at 'The New World of Data' conference on the tactical use of big data Video Link http://www.youtube.com/watch?v=5VK11WBco2Q Jan	09-01-2011 09:50 AM Jan	0	1
Identical views with identical data return different results How is this possible? Deployment is on a slightly older version than I have on my development machine, but since I am not doing anything exotic it... Robert Hairgrove	08-30-2011 02:04 PM Axel Schwenke	4	5
Adding a record from PHP ( 1 2 3 4 ) I'm trying to add a record to a database, and it's not working properly. The general thought is to call a data entry form, fill in the form, and use... Charles	08-30-2011 05:22 AM Axel Schwenke	38	39
Parallel access to the values of a table ( 1 2 ) Hi all, I have a table containing a list of unique words, defined as: CREATE TABLE word_list ( id int(10) unsigned NOT NULL auto_increment, word... gervaz	08-30-2011 05:04 AM Axel Schwenke	12	13
Is it possible to change single column in INSERT - SELECT query? I want to do this: INSERT INTO Table2(column1,column2,column3) SELECT column1,column2,'somecustomvalue' FROM Table1 WHERE id IN(1,2,3); Of course... A	08-29-2011 04:25 PM A	3	4
Yellowfin's 18 design don'ts for effective Dashboard design Time to Tee up and play Yellowfin's 18 design don't for effective Dashboard design course. The Front Nine: Use flashy visuals and chart types when... Jan	08-27-2011 08:25 AM Jan	0	1
How to import more .dbf files to MYSQL hi: I need to import more .dbf files to MYSQL with Collation big5_chinese_ci . Navicat can make .dbf to MYSQL , but only 1 file one time. I have... kokookao	08-26-2011 03:40 AM fabrice régnier	4	5
How do I do this? In sort of pseudocode I want: select ID, A from TableI where field_B = 'a value' and (if A not in ('value 1', 'value 2', ....) then set A to... anonymous	08-25-2011 07:36 AM anonymous	7	8
Empty field? On 8/24/2011 7:20 AM, The Natural Philosopher wrote: So, what did you screw up when you first installed it? Did you go back and delete the... Charles	08-25-2011 02:19 AM Álvaro G. Vicario	9	10
limit inside group in one query i have this table architecture: table user_media user_id \| media_id \| date_media_added_ts what i need to do is to select 10 newest media_id's for... friglob	08-18-2011 09:39 AM friglob	1	2
A query problem I have table I which when has G, F, L I can query to get a list: select L, U from I where G='111'; This gives me a list in ascending order... sheldonlg	08-17-2011 03:33 PM sheldonlg	5	6
Mobile Business Intelligence: 9 tips for success 9 tips for Mobile BI success Full... Jan	08-14-2011 09:34 AM Jan	0	1
Creating an index This feels like a stupid question, but I was unable to find the obvious answer. I have a simple SELECT query, like this: SELECT id, name, street,... jwcarlton	08-12-2011 09:51 PM Gordon Burditt	2	3
Return most likely results from MATCH - AGAINST Thanks for the well-thought-out reply, Gordon. I realize, though, that I need to make something a tad more clear. I'm not referring to people typing... jwcarlton	08-12-2011 12:55 AM Gordon Burditt	3	4
Index a table created with a select I am creating a table with a SELECT statement. CREATE TEMPORARY TABLE XYZ (SELECT A.key AS key, otherfields FROM A JOIN B on A.key = B.key); I want... Joseph Hesse	08-10-2011 06:27 PM onedbguru	2	3
DB Design: Extending the DB schema over time ( 1 2 ) Dear all, I'm about to design a MySQL data base. I have some basic knowledge about relational databases but am no expert. In particular, it's my... Ulrich Scholz	08-10-2011 01:02 PM Jerry Stuckle	10	11
Syntax of query? Hi, I have a simple table with the following data: mysql> select * from mytable; +---------------------+------+ 6 rows in set (0.00 sec) I would... Queux NoID	08-10-2011 04:22 AM strawberry	1	2
Help with a query I have a table where I keep track of my employee's weight and the date their weight was taken. Here is the table. mysql> select * from... Joseph Hesse	08-08-2011 08:15 PM Joseph Hesse	6	7
Stats comp.databases.mysql (last 7 days) "Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 08 Aug... me	08-08-2011 04:33 AM me	0	1
Can this be done? I have two tables A: field1, field2 B: field1, field2 field2 always has a value in table A. table B may or may not have a record with a value of... sheldonlg	08-07-2011 05:32 PM Peter H. Coffin	1	2
How to construct query? Hi, I have a simple table with some data looking like this: mysql> select * from mytable; +---------------------+------+ 6 rows in set (0.00... queux@hotmail.com	08-06-2011 09:43 AM Luuk	7	8
Prepared statement syntax for INSERT ... ON DUPLICATE KEY UPDATE? Hi, Is the following the correct syntax for a prepared statement to carry out an INSERT ... ON DUPLICATE KEY UPDATE statement? INSERT INTO... David	08-04-2011 09:26 AM David	2	3
move data folder from version 5.5 I have problems from version 5.5 to move the D: drive on the folder containing the database. The procedure I use is to move / date d: / server /... ferradini	08-03-2011 05:34 AM Gordon Burditt	1	2
Looking for commonality. (Hypothetical Example) I have a database of people and the cars they've driven. Fred Ford Chrysler Volkswagen George Jeep SpreadTooThin	08-03-2011 03:09 AM Lennart Jonsson	9	10
Possible to view last SQL action on a connection? Is there any way to view the last SQL that was run on a connection for which "show processlist" shows the command status as "Sleep"? I suspect that... Brian Cryer	08-02-2011 10:32 AM Brian Cryer	3	4
Stats comp.databases.mysql (last 7 days) "Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 01 Aug... me	08-01-2011 04:33 AM me	0	1
Replication not working - replication newbie ( 1 2 ) I studiously followed the documentation on replication and set up replication. The master and slave are connected by a VPN and the transaction load... bill	07-31-2011 12:40 PM The Natural Philosopher	17	18
[xpost] MYSQL + phpmyadmin: UNIX_TIMESTAMP in un campo? ciao a tutti, sto impazzendo nel cercare di impostare un valore di default (UNIX_TIMESTAMP) per un campo (miadata) di una tabella di un db mysql... sweetman	07-29-2011 05:11 AM sweetman	0	1
[ASK] Foreign Key error I try to create a database with the command below: CREATE TABLE `dagang`.`kecamatan` ( `no_kecamatan` INT( 4 ) NOT NULL AUTO_INCREMENT PRIMARY KEY... zaqi syah	07-26-2011 07:48 AM zaqi syah	9	10
[ask] WHERE Clause with many values? I want to combine the values â€‹â€‹of the two fields are still in one table, with the command below : update kabupaten set id_kabupaten = ( select... zaqi syah	07-25-2011 05:38 PM onedbguru	2	3
Stats comp.databases.mysql (last 7 days) "Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 25 Jul... me	07-25-2011 04:34 AM me	0	1
Document MySQL Tables ( 1 2 ) I googled and found a number of tools that claim to document MySQL schema, both at the column level and the table level. If you have found any that... Joseph Hesse	07-24-2011 01:58 PM Thomas 'PointedEars' Lahn	16	17
Re: DELETE operations on large tables On 2011-07-16 16:43, Ignoramus29044 wrote: Have you considered range... Lennart Jonsson	07-21-2011 01:13 PM Luuk	4	5
Search query, adding weight to exact result ( 1 2 ) For a simple message board search engine, I'm using the following query (in PHP, although I don't think the language matters): $query =... jwcarlton	07-21-2011 01:11 PM Luuk	11	12
Social Business Intelligence Q&A Session The use of Social and Collaborative Business Intelligence (BI) will allow information to be directly linked to decisions made within... Jan	07-19-2011 08:36 AM Jan	0	1
restore only one record from backup Hi, I have a db with some tables: users (main table), orders, auth, ecc. (related tables). This morning one user, and all related records, has been... remigio	07-19-2011 07:35 AM J.O. Aho	1	2
Authenticating MySQL user against PAM Hi folks, As per subject really... I have to set up some new MySQL servers. Is there a way to have a subset of user@% accounts auth against the... Tim Watts	07-19-2011 04:35 AM Tim Watts	2	3
[newbie] Schema Relation in SQL I want to create search engine in MYSQL & this is my scheme... zaqi syah	07-18-2011 06:09 PM Jerry Stuckle	1	2
Stats comp.databases.mysql (last 7 days) "Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 18 Jul... me	07-18-2011 04:32 AM me	0	1
Bi analysis of Tour de France Business Intelligence breakdown of the Tour The 2011 tour is an already tantalizing prospect, with three-time winner Alberto Contador (Spain)... Jan	07-13-2011 08:20 AM Jan	0	1
Excel to MySQL table ( 1 2 ) I currently convert an excel file to a mysql table in the following way. Open excel and delete not needed columns. Select date columns and format... Joseph Hesse	07-11-2011 10:23 PM Jerry Stuckle	14	15
SQL Error Message - Incorrect String Value ( 1 2 ) Server: ipower Platform Type: Debian MySQL Version: 5.0.45 Perl Version: 5.8.8 PHP Version: 5.2.12 Program: phpbb v 3.0.8 - installed from... Newbie_phpbb	07-11-2011 06:44 AM Jerry Stuckle	13	14
Stats comp.databases.mysql (last 7 days) "Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 11 Jul... me	07-11-2011 04:35 AM me	0	1
Is someone using Libre Office Base with MySQL? I have got a strange behaviour of Libre Office Base with a remote MySQL. The database loads, but i can only get _the first character of each... Laszlo Lebrun	07-09-2011 09:00 AM Laszlo Lebrun	2	3
Newbie lament on SASL authentication with Postscript... Hello, Please accept my apologies in advance for what is only venting my frustration with my own combination of hubris and incompetence... I am... Bernard T. Higonnet	07-07-2011 05:00 AM Bernard T. Higonnet	1	2
DB design: storing "this" or "that" (..or "the other")? ( 1 2 ) On 2011-06-17, Gordon Burditt <gordonb.q44sw (AT) burditt (DOT) org> wrote: Hi Gordon, My rationale was that while I develop the test website, I'm... David	07-07-2011 02:20 AM Lennart Jonsson	13	14
Stats comp.databases.mysql (last 7 days) "Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 04 Jul... me	07-04-2011 04:32 AM me	0	1

Page 4 of 128

104

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