| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | This is my TABLE
ID_1 ID_2 DAY MONTH
-----------------------------------------------
1 1 MON JAN
2 1 ...
stockton
|
02-29-2008 06:04 AM
Captain Paralytic  | 6 | 21 |
| | | Hello,
I have a database on my server with InnoDB and MyISAM engine for
differents tables and data are stored for a part of table in UTF-8 and
for...
Arno
|
02-29-2008 05:18 AM
Jerry Stuckle | 3 | 38 |
| | | Given a database with names like "Joe Bob" and "Fred Allen Jr.", the
following correctly sorts them:
ORDER BY SUBSTRING_INDEX(TRIM(TRAILING ' Jr.'...
Shannon Appelcline
|
02-28-2008 02:56 PM
Shannon Appelcline | 0 | 33 |
| | | This seems like it would have a very common answer, I just haven't
stumbled upon it. Apologies in advance for my ignorance, and thanks
in advance...
bk
|
02-28-2008 02:13 PM
Rik Wasmus | 2 | 27 |
| | | Does anyone know of a tool/util which could map out our DB and pages?
Here's where I'm coming from:
We have a list of changes to make to our DB and...
Mo
|
02-28-2008 12:29 PM
Mo | 0 | 32 |
| | | Hello,
I have a (big) table which is not normalized, but for i need at the
moment i think
that's no problem. Indeed, what i would like to do is to...
rui dias
|
02-28-2008 05:31 AM
Pavel Lepin | 3 | 18 |
| | | OK, the guys at my project don't have a ton of experience with
database design and performance planning, so we're hoping someone can
give us some...
wrburgess
|
02-27-2008 06:01 PM
Michael Austin | 1 | 20 |
| | | Hello all,
I'd like to do a Full text search but am having trouble using the
quotation operators in Boolean mode in this line:
$query = "SELECT *...
LAN MIND
|
02-27-2008 04:01 PM
Lan Mind | 3 | 23 |
| | | Hi
I am trying to insert into a table a bunch of rows from a select and a
constant. I tried this which seems like it should work:
INSERT INTO ...
mcardeiro@yahoo.com
|
02-27-2008 07:33 AM
mcardeiro@yahoo.com | 3 | 23 |
| | | Hi all,
I am executing a mysql script through My Query Browser windows. & I am
getting this error message.
'Unknown system variable done'.
The...
Dipesh
|
02-27-2008 06:47 AM
Jerry Stuckle | 4 | 22 |
| | | Morning All,
I have a MySQL database with privileges set up for access locally and
from a remote server. Both sets of priviliges use the same...
Al Henderson
|
02-27-2008 04:18 AM
Al Henderson | 0 | 17 |
| | | Hi,
imaging you have this database with these tables:
table A
table B
pieter.thoma@gmail.com
|
02-27-2008 03:05 AM
pieter.thoma@gmail.com | 0 | 24 |
| | | Consider this sequence of operations (on an InnoDB table):
begin a transaction
insert new row in a table with an auto-increment ID field
note the ID...
Tim Smith
|
02-26-2008 04:12 PM
Tim Smith | 4 | 30 |
| | | Hello all
I generate the CREATE statement for table X and with minor modifications
execute it to create table Y.
Both tables have as their first...
Jan Doggen
|
02-26-2008 12:18 PM
Peter H. Coffin | 1 | 23 |
| | | Hi all,
i have a problem, i have a table like this:
A | B
------------
1 | 1
1 | 2
2 | 1
2 | 4
Igor
|
02-26-2008 09:45 AM
Jerry Stuckle | 1 | 28 |
| | | Hi...
Why is this OK:
create table xxx(a int, b int auto_increment, primary key(b,a))
engine=innodb;
and this is not (Error 1075...note ordering...
JoeT
|
02-26-2008 08:10 AM
Peter H. Coffin | 13 | 64 |
| | | When I try to run an insert in the prompt command of mysql, the value
of my column "Distribution" is truncated in the 256 position. It has
about 500...
leoh
|
02-26-2008 06:23 AM
leoh | 2 | 19 |
| | | Hello all
Can I create a mysql database graphically such as with MS Access, that is
filling tables by hand without using
INSERT INTO ... ?
People...
NestoR
|
02-26-2008 05:28 AM
superfly | 1 | 31 |
| | | Hi,
I have a table used to store frequently updated datas. Only the last
data available must replace the other. This means that every time I...
Florent Clairambault
|
02-25-2008 08:53 PM
Michael Austin | 5 | 26 |
| | | Hi All,
I must be missing something basic. I'd like to use MySQL Connector
with Mono on Suse Linux. Is this available? The only installs I...
Steve Harp
|
02-25-2008 06:39 PM
Steve Harp | 0 | 33 |
| | | I have a query
select * from table order by column1 limit 10
I then want to sort the limited result set (of just 10 records) by
another column.
So...
IanReardon@gmail.com
|
02-25-2008 01:35 PM
Luuk | 1 | 24 |
| | | ok, hi, I know the post's title's not very clear so I'll explain what I
want.
I'm working on a keyword search. I have two tables to search from,...
henribaeyens
|
02-25-2008 11:41 AM
henribaeyens | 2 | 23 |
| | | someone know an editor????
Mariano
|
02-25-2008 06:33 AM
rolf_unger@hotmail.com | 6 | 24 |
| | | Is there a way to query a particular table in a database and
return the date that the database was last updated?
Regards,
Fred
Fred Atkinson
|
02-24-2008 09:17 PM
Peter H. Coffin | 2 | 22 |
| | | I am trying to create a database on a XP PC using the create sql
script that works on a red Hat 4 mySQL database. This is the table:
CREATE table...
John T. Kerich
|
02-24-2008 04:51 PM
Jerry Stuckle | 1 | 20 |
| | | Well, I've just installed MySQL and tried to create a table using MySQL
Admin in the test schema. When I attempt this, the client responds with
"The...
Newsgroups
|
02-24-2008 09:52 AM
Newsgroups | 0 | 36 |
| | | I need to import data into a simple table
The table has three fields. The first is an auto increment value, the
second the current time and date...
GarryJones
|
02-24-2008 09:13 AM
Jerry Stuckle | 4 | 22 |
| | | How do I create a database "foo", not under /var/lib/mysql but under
/somewhere/else?
I tried moving a database and creating a symlink, but it did...
Ignoramus13325
|
02-24-2008 03:26 AM
ThanksButNo | 2 | 23 |
| | | hi
i have to select the most new 10 rows from 3 different tables. how
to?
thanks
from Peter (cmk128 (AT) hotmail (DOT) com)
cmk128@hotmail.com
|
02-23-2008 09:33 AM
Gary | 3 | 27 |
| | | Can anyone give me a link containing data that explains the
correct procedure for setting up a batch file to backup and InnoDB
database and set that...
Fred Atkinson
|
02-23-2008 03:33 AM
Fred Atkinson | 4 | 28 |
| | | How do you check if an installed MySQL server is a community edition.
When I connect to the server the version is reported as...
Vimal Earnest
|
02-22-2008 03:13 PM
Vimal Earnest | 1 | 25 |
| | | Hi!
I have a table in my mysql5 that roughly looks like this:
id foreignid status
1 1 1
2 1 2
3 ...
Haentz
|
02-22-2008 11:04 AM
Haentz | 2 | 27 |
| | | Hello there,
Is it possible to have mySql use CamelCase for table names?
My appologies if this has been asked 100 times before. I have researched...
John Sheppard
|
02-22-2008 08:05 AM
Martijn Tonies | 9 | 20 |
| | | Hi :)
I'm trying to create a php function that will generate a form to
insert data in any table of my database.
I use the mysql_fetch_field...
Axelar
|
02-22-2008 07:23 AM
Willem Bogaerts | 1 | 28 |
| | | Hi. All.
..
I am sorry my english little...
..
my question is about "The error according to a MySQL table size which
is the system inside"
..
We...
rokmc781
|
02-21-2008 06:31 PM
rokmc781 | 2 | 26 |
| | | Hi all,
I am trying to restore my Bugzilla DB through the MySQL Administrator
V1.2.4
rc. This seems extremely straightforward in terms of what...
David Carr
|
02-21-2008 05:24 PM
jaxx0rr | 2 | 22 |
| | | Hello all,
I have a Sequence that has a number of Phases. These Phases are
ordered.
Each Sequence also has a number of Shots. These Shots are...
beef
|
02-21-2008 12:31 PM
beef | 0 | 33 |
| | | Hi at all
I'm a programmer but I'm not expert in SQL queries. I want to use a Nested
Set alghoritm for a web application using multile trees for...
Maxxx
|
02-21-2008 10:49 AM
Maxxx | 2 | 27 |
| | | Hello,
I am using this tutorial:
http://code.google.com/support/bin/answer.py?answer=65622
I can't seem to get the php file to output xml....
LAN MIND
|
02-21-2008 04:43 AM
Rik Wasmus | 1 | 31 |
| | | A few days ago, Rik gave me the following code that renumber the fieldname
column with consecutive numbers.
It worked fine when I ran it directly,...
Jeff
|
02-21-2008 12:30 AM
Jeff | 0 | 34 |
| | | hi,
whats the command to dump the database into sql file
Damodhar
|
02-20-2008 11:38 PM
Michael Austin | 4 | 26 |
| | | I'm a win32 developer and I need to embed in my distributed application some
"light" database.
Since its not an open source application I can't...
Jack
|
02-20-2008 11:30 PM
Michael Austin | 4 | 97 |
| | | Am Wed, 20 Feb 2008 14:56:22 +0100 schrieb Erick T. Barkhuis:
Hmm yes, I should rethink that...
Thanks,
Christian
Christian Neumann
|
02-20-2008 12:26 PM
Kees Nuyt | 4 | 31 |
| | | Say I have two tables:
table_a
----------
a_id (primary key)
b_id
table_b
----------
b_id (primary key)
doug
|
02-20-2008 08:55 AM
doug | 3 | 31 |
| | | Hi everyone,
I have a group of tables representing golf courses and users can rate
them.
I want to sum up the pars, and average out the ratings, so...
unabogie@gmail.com
|
02-19-2008 12:57 PM
unabogie@gmail.com | 2 | 24 |
| | | HI ,
Am trying to create trigger in mysql table i received some error any
one help me to correct or give simile trigger example ,
MY table...
Damodhar
|
02-19-2008 12:22 PM
Kees Nuyt | 1 | 61 |
| | | Hi Folks,
I am Bugzilla v3.0,3 user. I have installed Mysql 5.0 for this purpose.
However, with some of the attachments (pdf, zip, etc) I get the...
Sean
|
02-19-2008 11:30 AM
Sean | 4 | 28 |
| | | Hi Folks,
Does any one know where I can download "MySQL v4.0.14" for Win32 (x86)
platform?
Thanks,
-Sean
Sean
|
02-19-2008 10:38 AM
Rik Wasmus | 1 | 26 |
| | | Hi,
When I configure the loopback ip address as listening address
for the mysqld I can passwordless logon as root.
when I change the address to the...
adirtymindisajoyforever
|
02-19-2008 10:20 AM
Peter H. Coffin | 1 | 25 |
| | | Hello, I am trying to find the documentation for using libmyisam.a but I'm
lost.
I need to use the myisam engine from within C just like with good...
PCool
|
02-18-2008 08:49 PM
PCool | 0 | 24 |
