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
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
t of your tables, so
you want to try this with real-world data.
If the optimizer chooses the wrong index, you can tell it from which
indexes to choose by using 'USE (myindex)'. Use this e.g. to force it to
use the same index as for an ORDER BY. If it decides to use NO index, I
think you
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
> >
>
>
> --
> MySQL General Mailing List
> For list archives: http://li
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
for the additional index.
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 Netherlands
--
MySQL G
.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
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.
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
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
- It's always darkest before the dawn. So if you are going to
> >steal the neighbor's newspaper, that's the time to do it.
> > (53kr33t w0rdz: sql table query)
> >
> >
> > --
> > MySQL General Mailing List
>
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
list, not a newsgroup.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 3
' (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
w.python.org/topics/database/
http://www.python.org/topics/database/modules.html
http://sourceforge.net/projects/mysql-python
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400
field='somevalue' ...
> > >
> > > The key to the problem is not the replace into, but the fact that we
> > > are connected to one database and working on another.
>
>
>
>
> -
Remi, Michael,
On Fri, Jan 03, 2003 at 11:39:44AM -0500, Michael T. Babcock wrote:
> Fred van Engen wrote:
>
> >SET TIMESTAMP=1039489014;
> >
> >Each time with the current timestamp of course. I haven't checked
> >if it is actually used by the slave however.
&
instead of the
> value, this causes a difference in my 2 databases.
>
In my 3.23.52 binlog I see this before each time related update:
SET TIMESTAMP=1039489014;
Each time with the current timestamp of course. I haven't checked
if it is actually used by the slave however.
Regards,
D]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php
x27;s right. It has the same problem regarding optimization and it
gives you another column in your result set (which you may or may not
want).
Regards,
Fred.
> Fred van Engen wrote:
> >On Tue, Dec 10, 2002 at 03:32:13PM +0500, Tariq Murtaza wrote:
> >
> >>I want to ach
A'),category);
Only problem is that it won't optimize, so use this on small tables only.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400
, but is used to group
several rows (apples and pears) together. In that case, you can use:
SELECT id, SUM(price) FROM mytable WHERE id = 2 GROUP BY id;
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]T
INSERT INTO A VALUES(NULL, ...);
INSERT INTO B VALUES(LAST_INSERT_ID(), ...);
You need one query per table. LAST_INSERT_ID is kept per connection,
not per table, so you can safely use it like this.
Regards,
Fred.
--
Fred van Engen XB Networks B
d type:
> grant all on *.* to root@localhost;
And restart your MySQL daemon again. I never tried this, but I guess
it should work.
Good luck!
Fred.
--
Fred van Engen XO Communications B.V.
email: [EMAIL PROTECTED] Televisieweg 2
tel: +31 36 5462400
p with -A
>
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 2 to server version: 3.23.32
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer
>
> mysql>
>
Correct. You told the mysql cl
however still insist on having unique values for
> all of the four columns...
>
> MySQL said:
> Duplicate entry '127-30-127-1' for key 2
>
Did you check with a SELECT if there really is a duplicate 127.30.127.1 ?
Regards,
Fred.
--
Fred van Engen
their latest auto_increment ID. I believe there is also a
command you can use to reset the auto_increment ID, but you would
still need to take care to not insert negative values.
Regards,
Fred.
> > -Original Message-
> > From: Fred van Engen [mailto:[EMAIL PROTECTED]]
> >
rement columns.
Regards,
Fred.
PS: filter, filter, are you there? (sql, query)
--
Fred van Engen XO Communications B.V.
email: [EMAIL PROTECTED] Televisieweg 2
tel: +31 36 5462400 1322 A
y problems.
Regards,
Fred.
The stupid filter needs sql,query
--
Fred van Engen XO Communications B.V.
email: [EMAIL PROTECTED] Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424
; don't use dashes, fixing the SQL parser.
>
Or use quotes around the hostname:
grant all on *.* to "my-user"@"my-host.com";
Fred.
--
Fred van Engen XO Communications B.V.
email: [EMAIL PROTECTED] Televisieweg 2
tel: +31 36
ent column of type 'tiny int'. This allows
values between -128 and 127. You should choose a different column type.
Regards,
Fred.
--
Fred van Engen XO Communications B.V.
email: [EMAIL PROTECTED] Televisiewe
SULT ... instead of
SELECT ... . Note that SELECT SQL_BIG_RESULT doesn't work in 3.22.x,
though it is accepted by the parser. You don't mention which version
you use. 'set SQL_BIG_TABLES' works fine in 3.22.x.
Note that if I'm correct, you're using a very o
or
>
Hi, you just mailed your root password to an open mailing list.
Take care. You might want to change your password now.
Fred.
--
Fred van Engen XO Communications B.V.
email: [EMAIL PROTECTED] Televisieweg 2
tel: +31 36 5462400
table anyway, it is kept per session.
Regards,
Fred.
--
Fred van Engen XO Communications B.V.
email: [EMAIL PROTECTED] Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424
ame:
create table test (`key` varchar(255), value varchar(255));
You might want to reconsider using reserved names like this
because you will need to use the back-quotes in all your
queries.
Fred.
--
Fred van Engen XO Communications B.V.
email
this thread, e-mail <[EMAIL PROTECTED]>
> >To unsubscribe, e-mail
> ><[EMAIL PROTECTED]>
> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
> -
> Before po
column` CHAR(60) ///Here there is a space
);
> When I use ' or ", it does not work.
>
That's correct. There would be no way for the SQL parser to determine
between constant strings like 'some value' and column names like
'this
that they work only on MyISAM tables and only if
you have never deleted any rows from them.
Fred.
--
Fred van Engen XO Communications B.V.
email: [EMAIL PROTECTED] Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
t per connection and until
another INSERT is done.
Regards,
Fred.
> >What does your INSERT query look like? It should specify NULL
> >for ID_ordine, e.g.:
>
> >INSERT INTO ordinit(ID_ordine, Cod_Cliente) VALUES (NULL, 10);
>
> >Any other
1 - 100 of 177 matches
Mail list logo
