Jesse wrote:
This may be a really stupid question, but I hate looking stupid if I
can avoid it. :-)
I have been using Microsoft SQL Server for a while, and I'm now trying
to switch all our applications over to use MySQL. Microsoft SQL
Server is pronounced "Sequel Server". Is MySQL pronounce
queries run as "system user". There is no
"system user" in the privilege tables, so I can't give the account the
privileges necessary to run triggers. As a result, the triggers always
fail and break replication.
- ian
--
+----
triggers to be fired off my replicated queries.
- the error log gives a stack dump, and says this "could be because you
hit a bug". I'm looking for a little more information than that...
- ian
--
+-
- ian
--
+---+
| Ian Sales Database Administrator |
| |
| "All your database are belong to us" |
| ebuyer
Co.
Paperback - October 31, 2004
£29.26
- the second one is German language.
- ian
--
+-------+
| Ian Sales
problem I have is that the triggers
themselves are not being replicated; they exist only on the 5.0.17 slave.
- ian
--
+---+
| Ian Sales Database Administrator
w
DEFINER that was added with 5.0.17 that seems to be causing the problem.
- ian
--
+---+
| Ian Sales Databas
EFINER as a
specific user and then assigning INSERT, UPDATE, DELETE, SELECT and
SUPER privileges to that user. To no avail.
Anyone have any ideas how to resolve this?
Thanks
- ian
--
+---+
| Ian Sales
about... Our core database
platform contains some 2,600 tables in 50 databases. And that's only one
of 8 platforms...
- ian
--
+---+
| Ian Sales Database Adm
RE customers.id= invoices.customer_id
GROUP BY customers.id
ORDER BY customers.creation desc
Thanks!
- you need a LEFT JOIN. See http://dev.mysql.com/doc/refman/5.0/en/join.html
- ian
--
+---+
| Ian Sales
he trigger. E.g.,
CREATE TRIGGER InsPopCoord AFTER INSERT ON locations FOR EACH ROW
UPDATE zipcodes
SET zipcodes.lat=NEW.lat, zipcodes.lon=NEW.lon
WHERE zipcodes.zip=NEW.zip;
- ian
--
+---+
| Ian Sales
3 times and i got the follwing
error
Invalid Query Lock wait timeout exceeded; try restarting transaction
- try using SHOW INNODB STATUS. That will give you more info on table locks.
- ian
--
+---+
| Ian Sales
--
+---+
| Ian Sales Database Administrator |
| |
| "All your database are belong to us" |
| ebuyer http://www.
ith 1000s of
tables/files...
- don't split data into separate tables by location. Seperate it by the
type of information.
- ian
--
+---+
| Ian Sales
- ian
--
+---+
| Ian Sales Database Administrator |
| |
| "All your database are belong to us" |
| ebuyer http:/
r DVD collection.
- ian
--
+---+
| Ian Sales Database Administrator |
| |
| "All your databas
ent on whether RDBMS are *really*
relational, check out http://www.dbdebunk.com/index.html :-)
- ian
--
+---+
| Ian Sales Database Adminis
ll have to
enforce referential integrity programmatically. MySQL won't do it for you.
- ian
--
+---+
| Ian Sales Databas
--
+---+
| Ian Sales Database Administrator |
| |
| "All your database are belong to us" |
| ebuyer
://dev.mysql.com/doc/mysql/en/string-functions.html
- ian
--
+---+
| Ian Sales Database Administrator |
| |
| &quo
esary.
- I'd recommend not using float for money. You get rounding errors.
- ian
--
+---+
| Ian Sales Database Adm
ql/en/union.html)
--
+-------+
| Ian Sales Database Administrator |
| |
| "All your database are belong to us" |
| ebuyer
loging.
- MySQL will only allow you to join 32 tables in a single SQL statement.
- ian
--
+---+
| Ian Sales Database Administrator
using date_format and now(). See
http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html
- ian
--
+---+
| Ian Sales Database Administrator
wever,
is appalling...
- ian
--
+---+
| Ian Sales Database Administrator |
| |
| "If your DBA is busy all the time... |
|
m i t
h', in that order, such as Smithfield, Aerosmith, Nasmith, Smithsonian...
- ian
--
+---+
| Ian Sales Database Administrator |
|
location ids and location names
in a lookup table, and simply write the query as a join between the
animals table and the locations table? Hard-coding the meaning of ids
into the code itself is never a good idea.
- ian
--
+---
what. Any help is greatly appreciated!
Define DoS?
- Denial of Service...
- ian
--
+---+
| Ian Sales Database Administ
columns in the link for each role might work...
performer_group_id, performer_person_id, lyricist_person_id, etc. There
will be one row per recording of a song, although some columns on that
row may be empty.
- ian
--
+----
s the case.
- ian
--
+---+
| Ian Sales Database Administrator |
| |
| "If your DBA is bu
r my.cnf
- ian
--
+---+
| Ian Sales Database Administrator |
| |
| "If your DBA is busy all the time... |
| ...he's n
) to see
what caused mysqld to die.
- ian
--
+---+
| Ian Sales Database Administrator |
| |
| "If your D
.
- ian
--
+---+
| Ian Sales Database Administrator |
| |
| "If your DBA is busy all the
SET FOREIGN_KEY_CHECKS = 0 to turn off referentiality checking.
- ian
--
+---+
| Ian Sales Database Administrator |
| |
|
atus, in this case) with a
unique ID field in order to be absolutely certain I'm counting every
instance of each value of status. I've not investigated to see whether I
*really* need to do this, but it feels safer...
- ian
--
+----
(CONCAT(status,id) LIKE 'send%',1,0)) as send,
SUM(IF(CONCAT(status,id) LIKE 'cancelled%',1,0)) as cancelled
FROM
account
GROUP BY date;
- ian
--
+---+
| Ian Sales Database Admi
.
- delete the master.info file in the data directory, and then use CHANGE
MASTER ... to set the required values before starting replication on the
slave.
- ian
--
+---+
| Ian Sales Database
dump file and see.
- ian
--
+---+
| Ian Sales Database Administrator |
| |
| eBuyer http://www.
erver logs of anything special
going on at these times.
- one possibility could be DNS refreshes taking place... Do you have the
web server's name and IP in the hosts file on the database server?
- ian
--
+-
ya", "HSDN
350" , "041-267733 / 077-7 " are all under clients field, Yet the info is
supposed to be distributed to all the columns of the table. What could i be
doing wrong here.
- add FIELDS TERMINATED BY ',' ENCLOSED BY '
luck there
either...
Any suggestions?
- you've got a Cartesian results set because you haven't joined the
tables. Try joining on name, or writing two queries and then using a UNION.
- ian
--
+----
solve this .
- if you're copying the csv file between a Windows and a *NIX box, you
might have issues with carriage-return characters. Try running dos2unix
against the file to convert it.
- ian
--
+---+
| Ian
m the command line run a SQL script containing
SELECT CONCAT_WS(',', ...column names...) etc., and pipe the output into
a .csv file. Excel will happily import the data. There'll be no column
headings, though.
- ian
--
+----
[EMAIL PROTECTED] wrote:
Need to know the similar one in MySQL. Do we have views or any other
system tables in MySQL 4.0.21 which OUTPUTS the constraints and indices
in a particular table?
- show indexes from DATABASE_NAME.TABLE_NAME
- or, show create table DATABASE_NAME.TABLE_NAME;
- ian
--
My
rns the expected results.
- but thanks for the help.
- ian
--
| Ian Sales Broadband Solutions for |
| Database AdministratorHome & Business |
| PlusNet plc http://www.plus.net |
+ ---
set (0.00 sec)
Common sense expects the number of rows returned to be four. So where's
the Cartesian coming from?
- ian
--
| Ian Sales Broadband Solutions for |
| Database AdministratorHome & Business |
| Pl
WE DELIVER TARGETED UNIQUE SEARCH ENGINE
TRAFFIC TO YOUR WEB SITE
BOTTOM LINE >> IF YOUR POTENTIAL CUSTOMERS
CAN'T FIND YOUR WEB SITE YOU JUST LOST MONEY!
IT'S THAT SIMPLE!
Improving search engine TRAFFIC means:
MORE HITS
MORE BUSINESS
MORE SUCCESS
The most important advertising dol
Dear mySQL list members
I'm writing to inform you that ATAF version 6.0 is released today, and is ready to be
downloaded under Http://www.ataf.dk
ATAF's amazingly easy way to convert your MS-Access or ODBC database to an Internet
web application is now drastically improved compared to the old 5
First of all please CC me since I'm no longer a member. I had to unsubscribe
since I receive too much already... Sorry about that.
I think this is just me and my not so good understanding of the GROUP BY
function.
What happens is that it returns less lines than I expect it too. Perhaps it
has
Hey there,
first of all please CC my email address as I'm no longer a member of this
list. Recieving too much stuff already (1000+ mails a day)
Anyways I found a general SQL manual which uses oracle to show it's demos. So
I tried some of the examples in there some work but don't do the expecte
please CC [EMAIL PROTECTED] as i'm not a member
in addition to my earlier email this doesn't work either
regards
INPUT:
SQL> SELECT * FROM SOFTBALL
2 MINUS
3 SELECT * FROM FOOTBALL;
OUTPUT:
NAME
BAKER
DEAN
FALCONER
---
Hey there,
first off all, please CC me any replies, as I'm no longer a member of the
list... Sorry about that but I just receive too much... Over 2000 emails a
day is no exception and I can no longer keep track of them.
Ok, for the problem, I want to list the possible values of a enum variable
b from MySQL manual
but... There is no information about this problem.
Please, help me ok?!
Leandro.
Leandro Melo de Sales.
CEFET/AL - Centro Federal de Educação Tecnológica de Alagoas
Gerência de Tecnologia da Informação
Administração de Rede - GTI
Hi,
When I try to start mysqld.exe under Win98 I get error:
C:\mysql\bin>mysqld
Can't initialize InnoDB as 'innodb_data_file_path' is not set
Can anyone help with this?
Thanks,
Sean .
Hello
I have just installed MySQL on a Win98 machine and on trying to load mysqld.exe I get
the following error:
can't initialise InnoDB as innodb_file_data_path is not set
can anyone help with this?
Many thanks,
Sean Browne.
55 matches
Mail list logo
