Sponsored Links

comp.databases.mysql comp.databases.mysql

Page 9 of 128

109

Last »

Threads in Forum : comp.databases.mysql

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
reducing server load by crazy data distribution ( 1 2 3 4 5 ) On 1/5/2011 4:27 PM, Axel Schwenke wrote: I wonder why I keep trying to teach you something, Axel. -- ================== Remove the "x" from my... Jacek Krysztofik	01-06-2011 05:34 PM Jacek Krysztofik	46	47
missing constraint Hi My app is using SQLAlchemy0.5.6. I have a class defined as follows. class EmailSetup(DeclarativeBase): __tablename__ = 'emailsetup' id =... dhanil anupurath	01-06-2011 02:04 PM Peter H. Coffin	8	9
Error with freebsd Hello, I updated mysql to 5.5.8 with ports and now I have this error on maillog: postfix/cleanup: warning: connect to mysql server 127.0.0.1: Can't... promopoli	01-05-2011 09:22 PM onedbguru	1	2
Determining Primary Key ( 1 2 ) Is there anyway, using a SELECT statement, I can determine what the PRIMARY KEY is? I want the select a field from the last row in a database. I'm... bruce	01-04-2011 12:57 PM onedbguru	15	16
Multiple tables, or a single table with a lot of rows? I currently have 6 message boards) that are identical in structure, but have different data. Each board has 2 tables; one for "subjects", and one for... jwcarlton	01-03-2011 09:38 PM jwcarlton	2	3
self-join to delete dupes with a unique id I don't know how to create a self join to delete. I have a syntax error. thanks, delete FROM ci as a, ci as b max(id) where concat(a.bu,... jr	01-03-2011 05:29 PM jr	0	1
Stats comp.databases.mysql (last 7 days) "Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 03 Jan... me	01-03-2011 04:50 AM me	0	1
remove unwanted characters from column during select Ls, I want to make a select query. This query has to match on column x like: SELECT * FROM `table` WHERE `column` LIKE %value% I only get some of... Electricdummy	01-03-2011 03:41 AM Álvaro G. Vicario	3	4
Why is MySQL (still) not taken seriously as a DBMS by some developers? ( 1 2 3 4 5 ... Last Page) This probably isn't a very popular question here, but I'll ask it nontheless... In the past years, I've run into remarks about MySQL not being a... Karsten Wutzke	01-01-2011 11:12 AM Serge Rielau	83	84
Can a query return both a count and ensure that a particular valuedoes not exist within the counted records? I have a table with fields id, parentid, userid, and rowtype. I have joined it with itself where one parent row has a one to many relationship with... keytostars	12-31-2010 06:14 AM Axel Schwenke	2	3
Syntax error trying to return scalar value from query in stored function ( 1 2 3 ) I am (a newbie) having trouble creating a stored function to return a date from a table ('reporting_days') a given number of days after a specified... MartinH	12-29-2010 08:45 AM Axel Schwenke	25	26
Difference between community and standard edition Hi, The MySQL community edition is the no cost GPL version, the MySQL standard edition is the lowest cost ($2,000) of the paid versions. Please... Joe Hesse	12-27-2010 01:38 PM Axel Schwenke	4	5
Stats comp.databases.mysql (last 7 days) "Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 27 Dec... me	12-27-2010 04:28 AM me	0	1
mysqldump - non-destructive restore? Hi, I would like to do the following: 1) make a backup of my database using mysqldump 2) recreate the database by running the application's setup... Magnus Warker	12-27-2010 03:47 AM Luuk	1	2
MySQL WorkBench Questions... ( 1 2 3 ) I have a table that I want to split into two or more tables... Why can't I copy and past or drag and drop columns from one table to another? Feature... SpreadTooThin	12-24-2010 09:05 AM SpreadTooThin	28	29
LOCK TABLES inside transaction Hello, I created website using PHP5+MySQL. It contains 3 pages: 1. enter_announcement.php - enter/change real estate announcement 2.... Jivanmukta	12-22-2010 06:19 AM Álvaro G. Vicario	4	5
Mysql 5.5 for Windows development machine The MySQL web site recommends that I download a file named something similar to \|mysql-essential-5.5.8-win32.msi, yet there is no file by that name... Chuck Anderson	12-20-2010 07:36 PM Jerry Stuckle	9	10
Upgrading failure - Error Nr. 2003 ( 1 2 3 ) Hi all, Yesterday I tried to make an upgrading from MySQL 5.1.53 to MySQL 5.5.8 On a machine that runs under Windows XP. I did this: 1) I stopped... José Carlos Santos	12-20-2010 08:44 AM Jerry Stuckle	21	22
Stats comp.databases.mysql (last 7 days) "Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 20 Dec... me	12-20-2010 04:23 AM me	0	1
Foreign Key Constant Problem In my main table I have: CREATE TABLE maintable { id INT UNSIGNED NOT NULL AUTO_INCREMENT, ..... linkid INT UNSIGNED, .... .... lastfield... bruce	12-19-2010 06:45 PM bruce	2	3
Exporting a mysql table with links How can I create a CSV data file with a foreign key converted to its value? For example, in the table I want to export (mytable) I have a... bruce	12-19-2010 06:35 PM bruce	4	5
can connect to sql server through php but not with mysql cli client I'm able to connect to a MySQL database through PHP but not through the mysql command. When I try I get the following error: ERROR 2002 (HY000):... yawnmoth	12-19-2010 02:31 PM Sherm Pendley	1	2
days of a week hi all, I have 2 variables, varYEAR and varWEEK (ie: 2010 and 50) I'd like to know the days of this week (it starts on mondays). Or at least the... fabrice régnier	12-16-2010 01:35 PM Luuk	3	4
database engine creates problem with characters? Hi i developed a quite complex script for a migration job. It worked well. The database was a MyISAM. Lately the database has been changed to... pac Man	12-15-2010 11:29 AM Álvaro G. Vicario	3	4
innobackup failes Hi, tried meb 3.5 on a MySQL 5.5.7 test installation: ttt:/opt/mysql/meb-3.5/bin# innobackup --user=ttt --password=tttpw --compress... Bodo	12-15-2010 07:48 AM Bodo	6	7
From single table to relational. ( 1 2 ) If I have a database that has a table that needs to be split into two tables, is there a simple way to write a script to convert it from one schema... SpreadTooThin	12-14-2010 03:53 PM The Natural Philosopher	12	13
Large databases (100GB+) ( 1 2 3 ) In article <vilain-A5EEE2.20153009122010 (AT) news (DOT) individual.net>, Michael Vilain <vilain (AT) NOspamcop (DOT) net> wrote: Thats what a... Ignoramus28131	12-14-2010 10:46 AM Ignoramus21697	21	22
Windows 7 64 bit - FileMaker 32 bit: MySQL-driver 64 bit or 32 bit? My server works under Windows 7 Professional 64 bits, my FileMaker Pro10 Advanced is 32 bits. FM has to connect to a MySQL-database, which driver... Harry	12-14-2010 05:50 AM Axel Schwenke	1	2
Syntax error with simple Create Stored Function I am just starting out with MySQL and am having trouble with creating a simple stored function. I want to pass a date value and have the function to... MartinH	12-14-2010 03:18 AM Álvaro G. Vicario	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, 13 Dec... me	12-13-2010 04:44 AM me	0	1
Problem with Driver in Windows 7 In a test I used the MySQL ODBC 5.1 Driver to connect FileMaker to MySQL: it worked perfectly. OS: Vista Business SP2, 32 bits. In the 'real' world I... Harry	12-12-2010 05:15 PM Harry	0	1
Best practices for using Event Scheduler in Cluster? I had never before used the Event Scheduler with Cluster (only with InnoDB on a single machine). Now that I began to experiment with it on Cluster it... Theodore Hope	12-10-2010 04:42 AM Axel Schwenke	1	2
A guide to Yellowfin 5.1 Socialize, Visualize & Decide International Business Intelligence (BI) vendor, Yellowfin, has released the new version of its BI solution – Yellowfin 5.1 Socialize, Visualize &... JTP PR	12-09-2010 06:28 AM JTP PR	0	1
MySQL: permissions to databases, tables, views I've got some question about MySQL privileges MySQL version 5.1.30 running on FreeBSD (build from ports) I describe what i do: - I have created 2... alfa	12-08-2010 02:59 PM alfa	2	3
Backup problem When I try to backup a table, as root, I get the following message: The storage engine for the table doesn't support backup How do I change... bruce	12-07-2010 03:49 PM stukie	9	10
Pretty HTML Interface to MySQL Hi, My MySQL DB consists of an Employee table and about 6 other tables with either a 1:1, 1:N, or N:N relationships to the Employee table. The... Joe Hesse	12-06-2010 08:25 PM Jerry Stuckle	3	4
Using Business Intelligence to find the Worlds best Beer Finding the best beer by geography We kicked-off the selection process by perusing an awesome web site www.beerme.com , which has a great beer list... JTP PR	12-06-2010 06:36 AM JTP PR	0	1
group ny and latest records Hello I have this table: images id (int 19), user_id (int 19), creation_date (date), image (varchar 10) insert into images values(1, 1,... pac Man	12-06-2010 05:51 AM Captain Paralytic	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, 06 Dec... me	12-06-2010 04:30 AM me	0	1
single concatenated result from a table select. What is the correct way to do this? I want to select a subset email addresses from a table and present them as a comma delimited single... The Natural Philosopher	12-03-2010 10:42 AM Luuk	3	4
Stored Procedure Performance Timing??? Does anyone know if there is any way to get a high precision (think microseconds) time from within a sproc? I'd like to time a few of my sprocs to... fuglyducky	12-03-2010 08:12 AM fuglyducky	1	2
Plugging data from one table into another I have two tables for a message board; one showing the subjects (forum_subjects), and another showing the posts (forum_posts). Every once in awhile,... jwcarlton	12-02-2010 08:19 PM jwcarlton	7	8
Yellowfin 5.1 released on Friday. There is no ROI in Business Intelligence; unless you make a decision. Yellowfin has launched its 5.1 release to an expectant international audience... JTP PR	12-02-2010 06:43 AM JTP PR	0	1
useful MySQL tutorials that I wrote Downloading, compiling, and installing MySQL Server from source... nice_guy	12-01-2010 08:43 PM nice_guy	0	1
How to read TIMESTAMP field in UTC? TIMESTAMP fields are stored in UTC, but a SELECT returns them adjusted to the server's time zone. How can I get the timestamp in UTC, without... John Nagle	11-30-2010 03:03 AM Axel Schwenke	5	6
common programming interface to RDB's Michael Vilain wrote: Joe	11-29-2010 07:54 AM The Natural Philosopher	3	4
Efficient range query ( 1 2 3 ) Supposing I have a table of non-overlapping ranges thus: CREATE TABLE `ranges` ( `start` int(10) unsigned NOT NULL DEFAULT '0', `end` int(10)... Captain Paralytic	11-26-2010 06:37 PM Lennart Jonsson	20	21
Configuring Root User Hello, I just install MySQL server on Linux and want to configure users. The mysql.user table says I have the root users: root (AT) 127 (DOT)... Joe Hesse	11-26-2010 01:21 PM Jerry Stuckle	8	9
Cannot write utf8 data into a utf8 column ( 1 2 3 4 ) "Erick T. Barkhuis" <erick.use-net (AT) ardane (DOT) c.o.m> wrote: So how to decide if that third byte represents a 1-byte character or is the first... Tony Marston	11-26-2010 09:12 AM Lennart Jonsson	31	32
Update Script Help Hi, I need some help with this MySQL Update I've posted this in several forums, with no avail I've got three tables as below. drop table if exists... Nich	11-25-2010 05:49 AM Nich	1	2

Page 9 of 128

109

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