Hi all--
I googled around a bunch but couldn't find a good answer to this question.
How do I open the ERD diagram I made in MySQL WorkBench 5.2CE, which is a
.mwb file-- on another computer that does not have MySQL on it? I want to
be able to print out the file and so I need to be able to open i
the table, I use a temp table to import to
> as varchar, convert the column, the just select from temp table into prod
> table.
>
>
>
> -Original Message-
> From: Stillman, Benjamin [mailto:bstill...@limitedbrands.com]
> Sent: Monday, August 06, 2012 2:05 PM
> To:
wrong
way to solve the problem.
On Sun, Aug 5, 2012 at 9:53 AM, Hassan Schroeder wrote:
> On Sat, Aug 4, 2012 at 8:14 PM, Fred G wrote:
>
> > But I'm sure that I must be missing something here. Is there a way to
> use a
> > DECIMAL-like operator that treats blanks as bl
Hi--
I'm using MySQL 5.2 Workbench, and when I import a csv into MySQL, blank
values become 0 when I define the datatype to be a DECIMAL (in our case
(DECIMAL(12,2)). Since there is the potential for values to be 0, this
poses a problem for us. I initially wanted to make all the DECIMAL values
bec
What are the best ways to conduct financial data mining in MySQL? From
browsing the World Wide Web, it looks like using R to access MySQL and
using some pre-built R financial data analysis packages is the way to go.
Is there anything built-in to MySQL 5.2 Workbench, or, any other
possibilities tha
t
work.
Thanks again
On Tue, Jul 31, 2012 at 5:36 AM, Michael Widenius wrote:
>
> Hi!
>
> >>>>> "Fred" == Fred G writes:
>
> Fred> Thanks Dhaval. Putting the join condition before INTO outfile
> doesn't seem
> Fred> to work, either.
>
Thanks!
On Thu, Jul 26, 2012 at 12:05 AM, wrote:
> 2012/07/26 06:52 +0530, Dhaval Jaiswal
> SELECT * FROM test INTO OUTFILE '/home/test.csv' FIELDS TERMINATED BY ','
> ENCLOSED BY '"' LINES TERMINATED BY '\n'
>
> as above give your join condition before INTO OUTFILE.
>
> Right
QL connection was lost.
Does anyone have an idea of what is going on?
On Wed, Jul 25, 2012 at 9:22 PM, Dhaval Jaiswal wrote:
> SELECT * FROM test INTO OUTFILE '/home/test.csv' FIELDS TERMINATED BY ','
> ENCLOSED BY '"' LINES TERMINATED BY '\n'
&g
Hi--
I'm trying to do the following:
SELECT db.emp.emp_fname, db.emp.emp_fname, db.sale.sale_date,
db.sale.sale_no, db.sale.sale_total_amt
into outfile 'test123.csv'
FIELDS terminated by ','
FROM db.emp
LEFT OUTER JOIN db.sale
ON db.sale.emp_id = db.emp.emp_id;
The query without exporting the fil
Hi guys--
I am having some trouble importing a csv file correctly as a table in my
new database. In particular, there are 4 NA's in a column with 10,000+
other rows that have decimal values for that column.
How can I get MySQL to read in these "NA's" as some sort of null that is
accepted by the
Everything seems to go fine for me if I change the two 2007-3-23
to 2007-03-23.
Fred
-Original Message-
From: Rob Desbois [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 29, 2007 5:02 AM
To: mysql@lists.mysql.com
Subject: datetime type conversion problem
I am having issues with type
the same
CREATE. I believe the ibdata1 file as well as the
.frm files contain -- ironically, since the whole point of databases is to
avoid redundant data -- redundant schema-related
information. If they are not in sync the mapping between the .frm and ibdata1
information will probab
I had the same problem. Disabling it isn't enough. I had
to use the sc command from the Windows command prompt to
delete the service. Just enter sc on the command line and
a description of the command will be displayed.
Fred
-Original Message-
From: Scott Hamm [mailto:[
may have something to do with it. I
have addded the following in that file:
mysqld : ALL : ALLOW
mysqld-max : ALL : ALLOW
I did not change the default port of 3306. I assume mysqld automatically
opens up the port and begins listening for connections right?
Thanks for any help!!
Fred Aswad
--
My
er
clients to do some work. In an interactive application, your users will
love you for this :)
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fa
tabase operations.
>
If the primary goes down, how do you know that the database is in a good
state, even if the filesystem itself is consistent? I don't think MyISAM
gives you any guarantees in that regard. The secondary would need to run
myisamcheck on the tables be
ERT_ID() because some other process
may have inserted another record in the mean time.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 3
new every day.
>
How about the 'help' command? You'll learn even more ;)
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax:
> in this area:
> `affiliate_website aw WHERE aw.siteid = 1000`
>
A bit before that.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax:
n x m combinations, with n and m the number of records in table1 and
table2. You really want to do this for small tables only.
Consider an additional table to hold each of your 1, 3, 4, 6, ...
values together with the unique id of a record in table1.
Regards,
Fred.
--
Fred van Engen
ith this table only.
>
Your records don't have a fixed size because of a text column. I believe
this triggers MySQL to use a variable size for each column, converting
char to varchar. Functionally, it shouldn't make a difference I guess?
Regards,
Fred.
--
Fred van Engen
l? Especially the third set is important.
Mysqld probably runs under an account (mysql) that is not yourself or in
your group, so the file needs to be world-readable. Use 'ls -l' to show
these permissions.
Also, did the copying or renaming change the case of the filename, e.g.
because you a
l get in trouble if you have long running selects. These will
delay all following selects on the slave when an update is waiting for
the long query to end.
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36
or timestamps than a
signed int.
Also note that the range for timestamps is 1970 until 2038 (or 2106? for
unsigned ints), where DATE and DATETIME have a much greater range. Using
a UNIX timestamp for birthdays might not be appropriate.
Regards,
Fred.
--
Fred van Engen
Hi Matt. Thanks a lot again !
It worked pretty good.
There is no problem about the app, because
the use of the indexes is in charge of the DBMS (MySQL). The
app "doesn't know" about the tables and indexes details.
Best Regards,
Fred.
> Hi Fred,
>
> Also, you
nd regards,
Fred.
> Hi Fred,
>
> InnoDB does not support AUTO_INCREMENT on secondary columns of a
> multi-column index.
>
> > `id_registro` int(11) NOT NULL auto_increment,
> > PRIMARY KEY (`id_formula`,`id_registro`)
>
> There: id_registro is the second column of the index.
>
>
> Matt
Can you send me the configure file + makefile configured for cygwin ? Version 3.23.58
please thanks alot!
t to save a few
CPU cycles and already know the length. Look at the implementation of
mysql_query:
int STDCALL
mysql_query(MYSQL *mysql, const char *query)
{
return mysql_real_query(mysql,query, (uint) strlen(query));
}
> Well, whatever the reason, I guess this is what API gu
ed when the
table was created. The BINARY attribute means that column values are
sorted and compared in case-sensitive fashion according to the ASCII
order of the machine where the MySQL server is running. BINARY doesn't
affect how the column is stored or retrieved."
(http://www.mysql.com/d
the linefeed as it is:
INSERT INTO support_files (session_id,file_type,file_body) VALUES (123,456,'\0\0\'abc
x');
Your mail reader may mess things up, but there is a single line-break in
the example, just after abc.
Regards,
Fred.
--
Fred van Engen
ctly what you want to be
different between slaves and master.
> Is there another way?
>
Not that I know of. I just looked at the startup options but couldn't
find anything for this purpose.
Regards,
Fred.
> - Original Message -
> From: "Fred van Engen"
ot
> it?
>
Give their account different GRANTs on the master than on the slave(s)
and make sure that GRANTs (the `mysql` database) are not replicated from
the master to the slaves.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
rations with the current date and
time. If you have multiple TIMESTAMP columns, only the first one is
updated automatically. "
Use DATETIME instead of TIMESTAMP if you don't want this to happen.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAI
eldname (or tablename) by putting
backticks around it:
alter table tbl_name change `IN` NEW mediumtext;
> Pl. suggest how to rename particular "field name" for all the tables in
> a database
>
Repeat the alter table for each table. :/
Regards,
Fred.
--
Fred van Engen
On Wed, Oct 08, 2003 at 11:16:03AM +0200, Bob Brands wrote:
> What is the correct syntax for using a Exponentiation operator in MySQL?
>
It's not an operator but a function. Look at EXP and POW in the docs:
http://www.mysql.com/doc/en/Mathematical_functions.html
Regards,
Fred.
-
- note the last binlog file and size on the active server
- UNLOCK TABLES on the active server
- move the copy to the HS
- update the HS's master.info with the active server's binlog file and
size
- restart MySQL on the HS
Maybe there's an easier way, but this is (from memory) wha
ia dreamweaver's
> "test" window) all don't show any slashes in the data,
> but 'export' in phpMyadmin adds slashes to the text it
> outputs.
> magic_quotes_gpc is On
> magic_quotes_runtime is Off
> magic_quotes_sybase is
ry and connect through mysql client(DBTools) on remote PC I get the
> 'access denied for user: [EMAIL PROTECTED]' (using password:yes).
>
This suggest you tried to log on with a username 'user%' instead of
'user'.
Regards,
Fred.
--
Fred van Engen
the manual. Make sure your fields are
unsigned ints.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424 The N
Antony,
On Thu, Aug 28, 2003 at 06:45:27PM +0400, Antony Dovgal wrote:
> On Thu, 28 Aug 2003 16:37:41 +0200
> Fred van Engen <[EMAIL PROTECTED]> wrote:
>
> > Please elaborate.
>
> I've already answered:
>
On the list I just saw your 'bad advice' me
Antony,
On Thu, Aug 28, 2003 at 06:29:54PM +0400, Antony Dovgal wrote:
> On Thu, 28 Aug 2003 16:23:35 +0200
> Fred van Engen <[EMAIL PROTECTED]> wrote:
>
> > You need to make a separate connection to MySQL for the outer query to
> > prevent the inner query from m
g the update
> query might somehow effect the first one that is used in the outer loop.
>
You need to make a separate connection to MySQL for the outer query to
prevent the inner query from messing up the outer query's result set.
See the PHP manual for obtaining the connect
2 SET Table2.jobname=Table1.jobname WHERE
> Table2.jobid=Table1.jobid;
>
Not in 3.23.xx.
You would need to do this from a programming language or possibly by
creative use of temporary tables (SELECT INTO temp ...; REPLACE INTO
`Table 2`(...) SELECT * FROM temp; with appropriate locking).
R
rt is shown. I assume its then possible to remotely connect to the
> database? BUt how do i know where to connect to? Thats my doubt? By domain
> name? By ip? Nothing seems to work.
>
The server should be the same as the one running your website. You are
probably being blocked by their
On Sat, Aug 23, 2003 at 02:07:36PM +0200, Hans van Harten wrote:
> Fred van Engen wrote:
> > On Sat, Aug 23, 2003 at 10:54:32AM +0200, Hans van Harten wrote:
> >> My checks might not match those of (the next version of) MySQL and
> >> at that time the difference in t
On Sat, Aug 23, 2003 at 10:54:32AM +0200, Hans van Harten wrote:
> Fred van Engen wrote:
> > On Fri, Aug 22, 2003 at 01:16:48AM -0500, Hans van Harten wrote:
> >> that comes with neither warnings nor errors reported ...
> > Error reports would have been nice, but w
to decrease
slave_net_timeout ; see section 4.5.7.4 SHOW VARIABLES.
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#Replication_Features
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [
rrect dates anyway? Probably because some user typed them. And
what are you going to tell the user when you get a generic MySQL error
for an INSERT with many values? 'Oops, something went wrong'?
Just check the values in your application, like you should do for any
v
ocal/mysql/sql-bench' directory
> make: *** [install-recursive] error 1
> [EMAIL PROTECTED] mysql]#
>
It seems like you are (compiling and) installing _from_ /usr/local/mysql
and also _to_ /usr/local/mysql. You should compile and install from any
directory you choose, but it
PRIMARY KEY
| DROP INDEX index_name
| DISABLE KEYS
| ENABLE KEYS
| RENAME [TO] new_tbl_name
| ORDER BY col
| table_options
So what it clearly tells you, is to use this (note the 'ADD'):
mysql> ALTER TABLE EMPLOYEE
-> ADD FOREIGN KEY (SUPERSSN) REFERENCES EMPLOYEE(S
T USE INDEX (...).
Sometimes adding (redundant) fields containing a calculated value will
allow you to create a good index (at the cost of making sure that the
added field will remain consistent). There are lots of possibilities.
Hope this helps.
Regards,
Fred.
--
Fred van Engen
hese, which are more specific:
SELECT * FROM table WHERE Name = 'Author\\\'s'
SELECT * FROM table WHERE Name = "Author\\'s"
You need to escape the \ because it is the escape character and you need
to escape the ' in the first case because it is a string termin
bining records from multiple tables, which is not
what you seem to want to do.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424
(\u)Use another database. Takes database name as argument.
Connection id: 171359 (Can be used with mysqladmin kill)
mysql>
So it looks like you could try the 'source' command. Copying the query
through your clipboard is another option.
Regards,
Fred.
--
Fred van Engen
e
the InnoDB startup options listed in section 2 at
http://www.innodb.com/ibman.html
/opt/mysql-3.23.56/libexec/mysqld: ready for connections
So, look for something similar in your log. If it is there, then make
sure that you have innodb configured in my.cnf.
Regards
define foreign
> key constraints to guard the integrity of your data."
>
TYPE = InnoDB only works if MySQL is compiled with InnoDB support,
which is the default in binaries from MySQL. If you compile it yourself
you need to configure --with-innodb .
Regards,
Fred.
--
Fred van Engen
ror().
> $result = mysql_query($sql, $conn);
> while ($record = mysql_fetch_assoc($result)){
> while (list($fieldvalue) = each ($record))
> echo $fieldname.;
I'm not sure what the point (.) is doing here.
Check for error messages in the webserv
ery should work, with 'level < 3' of course.
SELECT uid FROM members WHERE level < 3 AND name between 'a' and 'b',
> but it does not work
>
Show us your sample data (SELECT uid, level, name FROM members) and the
results you get for the q
Hi,
On Tue, Jul 22, 2003 at 11:30:47AM -0400, Mojtaba Faridzad wrote:
> thanks Fred! that's better. actully I took a field with one character but
> it's better to run SELECT '1' FROM
>
> as I know, if there is not ORDER BY in the query, mySQL doesn't need
s would need to be
checked, even if the number of matches were less than 10001.
If your query is guaranteed to use an index, you add ORDER BY ... DESC
combined with a LIMIT to go to the last page of your form. You won't
know the actual count to display then.
Regards,
Fred.
> ---
mp table.
It probably allows for NULLs in some fields in your temp table as well.
Not much you can do about it, but just to make sure you're aware of this.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
On Sat, Jul 05, 2003 at 03:16:11PM +0200, Fred van Engen wrote:
> On Sat, Jul 05, 2003 at 01:03:17PM +, James Yang wrote:
> > I have a MYISAM table, which is about 2.2G and 19,000,000 records. When I
> > create indexs for it, I couldn't finish after 4 hours.
>
> You
he 2.2G table's index? MySQL
waits until disk space becomes available again. You wouldn't see much
disk activity while it is waiting.
Keep in mind that MySQL makes a copy of your table while it is adding
the index. You'll need twice the space of your initial table, plus
space
.0.13.
mysql> select version();
If you use an earlier version than 4.0.13, you could try to upgrade.
> InnoDB: We intentionally generate a memory trap.
> InnoDB: Send a detailed bug report to [EMAIL PROTECTED]
Well, you did that now :)
I don't use InnoDB currently, so maybe som
ically, on unices at least.
Check the mysql error log to find out if it crashed.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424
the first alpha release in august 1999 (few people would
use that)
I see no dates for 3.21.x, but it should have been the production
release in the beginning of 1999 and was probably supported for a while
after 3.22.x was the production release in march.
--
Fred van En
the
> Funds_Recd table?
>
I guess you want to use a GROUP BY because the SUM makes no sense
without it. You seem to want results for unique combinations of Job,
Sub and Task. This means:
GROUP BY Jobs.Job, Jobs.Sub, Jobs.Task;
Regards,
Fred.
--
Fred van Engen XB
ach page. Any help would be appreciated.
mysql> pager /usr/bin/less
mysql> tee somefile.log
I guess this is documented somewhere, or try:
mysql> help
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]
version for the right syntax to use near
> '[EMAIL PROTECTED] IDENTIFIED BY 'update'' at line 1
> mysql>
>
Try [EMAIL PROTECTED] instead. UPDATE is a reserved word in SQL.
Regards,
Fred.
--
Fred van Engen XB Netwo
be out of place not to mention the security implications:
You should 1. not be querying your DB as the root database user if
possible, and 2. you should stick your password (which shouldn't match
your UNIX password) in a textfile readable only by you so that you don't
pass the pa
Thanks for your help! I might wait or look elsewhere
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Monday, 23 June 2003 12:16 PM
To: Lecul, Fred
Cc: '[EMAIL PROTECTED]'
Subject: Re: APT-GET Help with upgrade to 4.1
On Mon, Jun 23, 2003 at 12:00:
Hi
I want to upgrade my mysql 3.23 to 4.1 as I want to convert a mssql app that
has lots and lots of subselects. I hear that 4.1 now supports this (I hope).
I used apt-get to install 3.23 so how can I install 4.1 over the top and not
get into any trouble is what Im after?
Ive tried apt-get inst
databases to
> MS SQL databases. It would be highly appreciated if you could send me the
> details at the earliest.
>
Sorry, but I have no experience with this.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Te
--+
1 row in set (0.00 sec)
mysql> select (5 | 7) & ~(5 & 7);
++
| (5 | 7) & ~(5 & 7) |
++
| 2 |
+----+
1 row in set (0.00 sec)
mysql>
Regards,
Fred.
--
Fred van Engen
it would be useless in multi-user cases. It gives you
information on what you just inserted, not what someone else did with
another connection.
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#IDX1362
Regards,
Fred.
--
Fred van Engen
t; command that I just did??
>
Sorry, you'll need a backup. If your backup is not recent enough and you
have a binary log (e.g. for replication), you can use that log to restore
the database state.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
xactly how you'd do this with a SQL query, short of using 'n' joins.
Of course if it's possible, it'd be best to modify the table such that
you separate colorID into two columns, and then use an AND.
-Fred
danchik wrote:
thats effectively an OR statement, isnt it?
h
is between 5 and 10,
SELECT ID FROM theTable WHERE colorID >= 5 AND colorID <= 10
-Fred
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ter_id = $row['register_id'];
> echo $register_id = At this time the value is blank when I print the value
>
}
}
}
}
>
> Please, If someone know how to print the record value and Select function in php
> send to me.
>
Read the manual, c
Hmm...
Yeah, its not connecting!
Im getting:
ERROR 1130: Host '10.x.x.x' is not allowed to connect to this MySQL server
Any idea's??
Fred
-Original Message-
From: Daniel Kasak [mailto:[EMAIL PROTECTED]
Sent: Friday, 4 April 2003 1:42 PM
To: Lecul, Fred; [EMAIL PROTECT
Tried that and it didn't work
Is it possible that the port 3306 is blocked? And if it is, how can I open
this?
Thanks
Fred
-Original Message-
From: Daniel Kasak [mailto:[EMAIL PROTECTED]
Sent: Friday, 4 April 2003 12:09 PM
To: Lecul, Fred
Cc: '[EMAIL PROTECTED]'
Subjec
Hi
Im new to mysql and am trying to connect externally.
I have hashed out the skip-networking in the my.cnf, created a new user and
gave permissions but it seems it just doent want to accept the connection. I
am trying to connect using free-Mascon.
Any idea's on what I can do?
Frederic Lec
hould be at the end of the query.
Also use addslashes() to properly escape quotes in your variables.
> $result=mysql_query($sql,$db);
>
> if($result) {
> echo ("Data$nome, registro nº$nid was
> successfully updated.");
>
applet alert asking if I
> really want to xyz, then it gives an error in MyPHPAdmin)
>
> delete * from 'item' where 'quantity_of_item_in_stock' <= 10;
>
Yes, this is incorrect syntax.
Regards,
Fred.
--
Fred van Engen
Tanggal : $tanggal\n
> Nama file: $namafile\n
> ";
>}
> echo "Akhir baris.\n";
>
> } else echo "Gagal konek.\n";
> mysql_close($konek);
> ?>
>
> Thank you ve
ality in 4.0.x and it was never added to
3.23.x. Be careful with the online manual, because it is for the latest
version of MySQL.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36
gt;
[snip] :)
> Unless I discover something else, I'm going to assume this is not a mysql
> problem.
>
This all happens at the level of the TCP stack, so MySQL couldn't be
involved I guess. Could you try running tcpdump -n to make sure the
DNS or host tables aren't goof
swamp my
> network. I would like to identify the source and understand the cause.
>
My guess is that you're showing only packets sent by herzegbol and not
packets received by herzegbol and that shelbyville is really trying to
connect. What is your tcpdump line and wh
('', '${_REQUEST['testField']}')";
>
Make that:
$sql = "INSERT INTO testTable values ('', '" . addslashes($_REQUEST['testField']) .
"')";
Or you would just have coded your first exploitable line of code.
e ID I just inserted?
>
Yes. The last inserted id is kept per connection. So unless YOU insert
another record using the same connection, the last_insert_id isn't
changed. Also, last_insert_id in a new connection will give you NULL,
regardless of what you did in a previous connection.
R
m to have setup the privilege tables.
See http://www.mysql.com/doc/en/mysql_install_db.html for details.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
't find file: './mysql/host.frm' (errno: 13)
> 030326 14:35:47 mysqld ended
>
> how do I correct this
You don't seem to have setup the privilege tables.
See http://www.mysql.com/doc/en/mysql_install_db.html for details.
Regards,
Fred.
--
Fred van Engen
ss.
>
In other cases than above, e.g. network problems, the replication should
start again automatically. Again, you would see this in the error log.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Tele
On Thu, Mar 20, 2003 at 10:32:07AM -0600, Dan Nelson wrote:
> In the last episode (Mar 20), Fred van Engen said:
> > > See msg 135092 for sample script if you want to see a physical example.
> >
> > Which message is 135092? I'm reading a mailing list, not a new
L,
Trips.TripID,
Trips.Mileage
FROM Trips
INNER JOIN Cars ON Trips.CarID = Cars.CarID
INNER JOIN Users ON Cars.UserID = Users.UserID
WHERE Users.UserId='2')
ORDER BY 'Cars!2!CarID!hide',
'User!1!UserID!hide',
Tag
;
Rega
uot;
> Is there some database option that will make a UNION behave properly in mySQL?
>
Please define 'properly'. What are you trying to do?
> See msg 135092 for sample script if you want to see a physical example.
>
Which message is 135092? I'm reading a mailing
' (Using password: YES)
Use FLUSH PRIVILEGES after updating the mysql tables directly.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400
permissions ?
>
Securing a table with a password or even using encryption would make
things more difficult for your "users" but by no means impossible.
You give them the application that contains the password or encryption
key. They just need to find it in your application then, w
InnoDB_consistent_read.html
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424
'%apple%'
> and loop against the items in the set?
>
I never worked with sets, but you could try something like this:
select
sum(sign(find_in_set('apple', favourite_fruits))) as apples,
sum(sign(find_in_set('pear', favourite_fruits))) as pears
from Kids;
This would
1 - 100 of 243 matches
Mail list logo
