I came up with a solution: using special "md5" to deal with conflicts
steps to insert a url
1. insert into table(md5,url) values('md5 of url', url)
2. if get a duplicate entry for primary key
2.1 select md5,url from table where md5 like '%' for update
2.2 if url really exists, don't nee
The odds against the eventuality you are worried about are astronomically
high. Much serious work on the internet would fall apart were that not
true. Collision is simply not going to happen within the next several
hundred thousand years.
On Nov 5, 2013 9:59 PM, "Li Li" wrote:
> I prefer your s
I prefer your solution in that it's something like Optimistic Locking.
but the problem is that if I define md5 as unique key and there exists
2 different urls with the same md5. I can't insert the second url
anymore
On Tue, Nov 5, 2013 at 11:55 PM, Dan Nelson wrote:
> In the last episode (Nov 05)
.
> -Original Message-
> From: Dan Nelson [mailto:dnel...@allantgroup.com]
> Sent: Tuesday, November 05, 2013 7:56 AM
> To: Li Li
> Cc: mysql@lists.mysql.com
> Subject: Re: how to create unique key for long varchar?
>
> In the last episode (Nov 05), Li Li said:
> >
In the last episode (Nov 05), Li Li said:
> I want to create a table with a long varchar column, maybe it's the url.
> according to dns spec, the url's max length is fixed. but I have
> to deal with url having long params such as
> a.html?q=&fl=bb
hi all
I want to create a table with a long varchar column, maybe it's the url.
according to dns spec, the url's max length is fixed. but I have
to deal with url having long params such as
a.html?q=&fl=
I want the url is unique whe
Can any body help me how to create new instance at the same mysql databas
server in 5.0.85 community version ?
You might find useful:
http://code.openark.org/blog/mysql/manually-installing-multiple-mysql-instances-on-linux-howto
At least i used that last time i had to set 2 instances on my
Hi,
Can any body help me how to create new instance at the same mysql databas
server in 5.0.85 community version ?
Thanks
Jeetendra Ranjan
I'm having a hard time trying to find the best way to create a
relationship between two rows in the same table.
I have a database that describes network equipment.
There is a table called devices that contains information about the
device.
There is another table called ports that describ
How to Create a Test Case
http://forge.mysql.com/wiki/How_to_Create_a_Test_Case
This Thursday (April 2nd, 14:00 UTC), Patrick Crews will give a MySQL
University session on How to Create a Test Case. This is an updated
session of a talk we had in 2007, but this time it will be recorded
(slides and
Hi.
I have the following test db/tbl setup.
stateTBL
+--+
| stateName|
| stateID |>>>+
+--+ V
V
V
collegeTBL V
+--+ V
| collegeName | V
| stateID |<<<+
| college
I'm not at all familiar with SQL Server, but you need to make sure that the
encoding/charset you use in MySQL is the same as used in SQL S.
If not the same, then you might need to transcode the data before migrating.
Collation is less important than encoding. - if you get the charset wrong,
then
>-Original Message-
>From: Ali, Saqib [mailto:[EMAIL PROTECTED]
>Sent: Thursday, December 04, 2008 1:02 PM
>To: mysql@lists.mysql.com
>Subject: Re: How to create a unicode capable table??
>
>Hello,
>
>Any thoughts on this? Thanks.
>
[JS] I'll be inte
Hello,
Any thoughts on this? Thanks.
On Tue, Nov 25, 2008 at 8:14 PM, Ali, Saqib <[EMAIL PROTECTED]> wrote:
> What Charset and Collation should I use while creating a mysql table
> such that it can take data from unicode SQL Server DB table?
>
> Thanks
> saqib
> http://doctrina.wordpress.com/
>
What Charset and Collation should I use while creating a mysql table
such that it can take data from unicode SQL Server DB table?
Thanks
saqib
http://doctrina.wordpress.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[E
No advice? Anyway after monitoring slow queries for few days, I found most
likely the following queries caused bad performance and locked table for
long time:
LIMIT 16780, 20
A big offset! Even the index is properly used.
After restricting offset value within the software, eg, return er
Hi All,
I need advice for creating proper INDEX for a query.
The table is like:
mysql> desc article;
++--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
++--+--+-+-
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
I have 2 databases: production_db and test_db. Both databases have the
same tables. Now, I want to do as follows:
If a new record is inserted to the production_db interst the same recort
into the test_db.
I am pretty sure, it's a case fo a trigg
There is no way that I know of to reference every field in a table
without using a stored procedure. If you really need to do something
like that, and you will be adding new columns frequently, then it's
most likely an indication that your table structure is not normalized.
Those columns sh
Dear MySQL specialists,
this is a MySQL-newbie question: I want to create a view of a table,
where all NULL-values are substituted by 0. Therefore I tried:
SELECT *,
IFNULL(*,0)
FROM table
Unfortunately IFNULL seems not to accept any wildcards like * as
placeholder for the column-name. REGEXP d
Hi,
I want to change an existing table to StorageType "federated"
according to http://dev.mysql.com/doc/refman/5.1/en/federated-create.html
I've just created this sample table, now I can't even have a look at
the scheme with mySQL Administrator, only the "mySQL Query Browser"
works and shows me th
ut only from the
host whitehouse.gov.
The third account can access the customer database, but only from the host
server.domain.
> Mogens Melander wrote:
>>
>> GRANT CREATE,INSERT,DELETE,UPDATE,SELECT PRIVILEGES ON pauldb.*
>> TO [EMAIL PROTECTED] IDENTIFIED BY 'mysec
;
>
> On Tue, May 8, 2007 13:57, sunisundar wrote:
>>
>> how to create new username n password in mysql using commands.
>>
>> followed these steps::
>> mysql> create database pauldb;
>> Query OK, 1 row affected (0.00 sec)
>>
>> #
>> #
GRANT CREATE,INSERT,DELETE,UPDATE,SELECT PRIVILEGES ON pauldb.*
TO [EMAIL PROTECTED] IDENTIFIED BY 'mysecretpassword';
On Tue, May 8, 2007 13:57, sunisundar wrote:
>
> how to create new username n password in mysql using commands.
>
> followed these steps::
> mysq
how to create new username n password in mysql using commands.
followed these steps::
mysql> create database pauldb;
Query OK, 1 row affected (0.00 sec)
#
# Now we create the user paul and give him full
# permissions on the new database
mysql> grant CREATE,INSERT,DELETE,UPDATE,SELECT on
>So if the date range is '2001-01-15' to '2003-04-01' then it
would generate
>approx 800 rows with dates between these 2 ranges. I can't seem to
figure
>out how to do it without writing a program.
See Dates/'Make a calendar table at
http://www.artfulsoftware.com/queries.php.
PB
-
mos
This one has me puzzled. All I need to do is create a table of dates, one
date per row, from a starting to ending date.
So if the date range is '2001-01-15' to '2003-04-01' then it would generate
approx 800 rows with dates between these 2 ranges. I can't seem to figure
out how to do it without
Hello NG,
how can I implement a reference in phpmyadmin between two fields from
two different tables, so that the two fields of the two different tables
have the same values? And if I have to fill this two tables by building and
executing
the insert into command, which default value of the refere
Hello,
I hope someone can help me with my problem. I want to join 2 tables. One
contains data about start and finish dates of a machine install, the
second table conatins data of install costs and a commencing date.
Table 1:
+-+++-+-+
| Machine
Thank you Shawn!
2006/2/7, [EMAIL PROTECTED] <[EMAIL PROTECTED]>:
>
>
> Célio Cidral Junior <[EMAIL PROTECTED]> wrote on 02/05/2006 02:20:48
> PM:
>
> There already IS a users table that you can either send CRUD statements to
> or manage through the GRANT and REVOKE statements. Since MySQL securit
Célio Cidral Junior <[EMAIL PROTECTED]> wrote on 02/05/2006
02:20:48 PM:
> 2006/2/4, sol beach <[EMAIL PROTECTED]>:
> > What other C# applications have you previously written?
> > Do you know anything more than how to spell SQL?
> > Have you ever installed and administered MYSQL?
>
> I have been
2006/2/4, sol beach <[EMAIL PROTECTED]>:
> What other C# applications have you previously written?
> Do you know anything more than how to spell SQL?
> Have you ever installed and administered MYSQL?
I have been working as a professional programmer for around five
years, and have been writing ente
>I would like to write an application in C# to let someone to manage
>users of a MySQL database. It should be able to create, edit and
>delete users. Can someone point me out to how I can do that? I really
>want to *write* such an application; I don't want to use an existing
>client or somethin
Hi,
I would like to write an application in C# to let someone to manage
users of a MySQL database. It should be able to create, edit and
delete users. Can someone point me out to how I can do that? I really
want to *write* such an application; I don't want to use an existing
client or something.
Chris Guo wrote:
Chris,
We are using mysql as backend database for one of the application in our
company server, and there are too many data in the Mysql database. So I
wonder how I create a database on different location.
How do you define too much data in the MySQL database?
Do you want to
) 636-9239
-Original Message-
From: prathima rao [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 14, 2005 6:04 AM
To: mysql@lists.mysql.com
Subject: how to create binary logging for a database
hello,
how can i create a binary log in a new database
- Original Message
hello,
how can i create a binary log in a new database
- Original Message -
From: "Adam Lipscombe" <[EMAIL PROTECTED]>
To:
Sent: 14/12/2005 3:50 PM
Subject: Mysqldump INSERT statements (Was Mysqldump line endings)
>> (--result-file) option to save your output but use the > output
redi
Hi,
We are using mysql as backend database for one of the application in our
company server, and there are too many data in the Mysql database. So I
wonder how I create a database on different location.
Any help would be highly appreciated.
Chris
Raymond,
>I am new to Mysql and am working a project where I want a user
to
>be able to see some records but not all records in a particular
table.
That's what the WHERE clause of SQL's SELECT statement is for. Read the
MySQL tutorial (http://dev.mysql.com/doc/mysql/en/tutorial.html) and
the
Hi,
This is a design question.
the selection of data types must be intergrated to your application.
If you have a table with :
name type
apple fruit
redcolor
a simple query like
select * from tbl where type ='fruit' will give only fruits to the users.
You can if you have mysql 5.x create
I am new to Mysql and am working a project where I want a user to be able to
see some records but not all records in a particular table.
I am assuming that I would need to create a subset table based on the original
table and give the user access to only the subset table.
Is it possible to do thi
MySQL supports Stored procedures from version 5.0 onwards...for more
information see
http://dev.mysql.com/doc/mysql/en/stored-procedures.html
Rgds
Manoj
- Original Message -
From: "Winanjaya" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, April 12, 2005 2:23 PM
Subject: NewB
Dear All,
I am very new to MySQL, I am using MySQL 4.1 Adminstrator, my question is
very simple: how to create store procedure? ..I saw the "Create New
Procedure/Function" menu but it disabled? .. please advise ..
thanks
Regards
Winanjaya
--
MySQL General Mailing List
For list arch
Mauricio Pellegrini wrote:
Hi,
I'm using MySql 4.1.4 gamma and there are certain circumstances in
wich I need to create tables with random names from within querys.
And after using them I need to drop them; so I need a way to *remember*
these table names so I can dispose them later.
Is that po
At 06:56 AM 12/18/2004, you wrote:
Hi,
I'm using MySql 4.1.4 gamma and there are certain circumstances in
wich I need to create tables with random names from within querys.
And after using them I need to drop them; so I need a way to *remember*
these table names so I can dispose them later.
Is t
Hi,
I'm using MySql 4.1.4 gamma and there are certain circumstances in
wich I need to create tables with random names from within querys.
And after using them I need to drop them; so I need a way to *remember*
these table names so I can dispose them later.
Is that possible with MySql?
Thank
On Sunday 21 November 2004 08:38 am, Dayakar wrote:
> Can any one help me in creating view using mysql4.1. If we cannot then any
> other alternative. It would be great if anyone give me an example for that.
Thats a 5.0 feature.. Your not gonna get to far with 4.1..
Jeff
--
=
- Original Message -
From: "Dayakar" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, November 21, 2004 9:38 AM
Subject: how to create views in mysql4.1
> Hello friends,
>
> Can any one help me in creating view using mysql4.1. If we cannot then
Hello friends,
Can any one help me in creating view using mysql4.1. If we cannot then any
other alternative. It would be great if anyone give me an example for that.
regards
dayakar
SMILE ALL THE WHILE..
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubs
mber 2004 2:21 PM
To: '[EMAIL PROTECTED] '
Subject: how to create a user with limited privileges
Hi all,
I would like to know the mysql command to do the following:
Create a user (who will access mysql database), with privilaeges so
that, he can only retrieve the information in the da
Hi all,
I would like to know the mysql command to do the following:
Create a user (who will access mysql database), with privilaeges so
that, he can only retrieve the information in the data base (values in
the tables), he should not be able to alter, update, delete any table
values.
Kindly h
esday, July 14, 2004 8:29 AM
To: 'Roy Brown'; [EMAIL PROTECTED]
Subject: RE: How to create an Installation Package using VB.NET?
I'm sure there is some subset of files that you can include, based on what
features you want to make available to your clients.
-reggie
> -Origi
ett'; [EMAIL PROTECTED]
> Subject: RE: How to create an Installation Package using VB.NET?
>
> Reggie
>
> I was hoping to perform the mysql installation myself. I was also hoping
> that I don't have to install the full suite as available on the site, but
> a
> subset
e Burnett [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 13, 2004 8:15 PM
To: 'Roy Brown'; [EMAIL PROTECTED]
Subject: RE: How to create an Installation Package using VB.NET?
Roy
I don't think we provide any merge module for our ODBC installation yet, but
the changes that the odbc
text file in temp and feed that to the server.
Are you using the Vs.net installer stuff or wix?
-reggie
> -Original Message-
> From: Roy Brown [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 13, 2004 3:54 PM
> To: [EMAIL PROTECTED]
> Subject: How to create an Installation
From: Roy Brown [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 13, 2004 4:54 PM
To: [EMAIL PROTECTED]
Subject: How to create an Installation Package using VB.NET?
Hi, I am very new to MySQL and using it as the backend of my VB.NET
application. Now, I am trying to create an installation package
Hi, I am very new to MySQL and using it as the backend of my VB.NET
application. Now, I am trying to create an installation package from within
VB and don't know what files from MySQL & MyODBC 3.51 I need to add to my
installation package. Can anyone provide some help in this regards?
Also, I will
Thank you Harald. That's exactly what I was looking for.
-Andy.
On Monday 26 April 2004 05:37 am, Harald Fuchs wrote:
> In article <[EMAIL PROTECTED]>,
>
> If you're sure that the people and things entries for one place are
> distinct, you can use, well, count(distinct):
>
> SELECT pl.name AS '
try restarting mysql service ..
Cheers
Binay
- Original Message -
From: "ads mysql" <[EMAIL PROTECTED]>
To: "Duke, Brian" <[EMAIL PROTECTED]>; "Nitin"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, December 16, 2003 2:07 PM
S
luck.
Help appreciated.
"Duke, Brian"
wrote:
try this:
grant ALL on abc.* to 'abc'@'localhost' identified by 'abc';
>I have created database 'abc' .
>mysql> grant ALL on abc.table to 'abc' identified by 'abc';
- Original Message -
From: "Nitin" <[EMAIL PROTECTED]>
To: "ads mysql" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, December 16, 2003 2:01 PM
Subject: Re: How to create mysql user?
> did u do a
> flush privilege
>
>
>
ble to 'abc' identified by 'abc';
>Query OK, 0 rows affected (0.00 sec)
-Original Message-
From: ads mysql [mailto:[EMAIL PROTECTED]
Sent: Monday, December 15, 2003 11:21 PM
To: Nitin; [EMAIL PROTECTED]
Subject: Re: How to create mysql user?
O K.
I accessed to my
did u do a
flush privilege
- Original Message -
From: "ads mysql" <[EMAIL PROTECTED]>
To: "Nitin" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, December 16, 2003 1:00 PM
Subject: Re: How to create mysql user?
> O K. I have tried
mysql -u abc -p abc
where last abc is ur database name.
Nitin
- Original Message -
From: "ads mysql"
To: "Nitin" ;
Sent: Tuesday, December 16, 2003 11:51 AM
Subject: Re: How to create mysql user?
> O K.
> I accessed to mysql as root user and tried to created
t; <[EMAIL PROTECTED]>
To: "Nitin" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, December 16, 2003 11:51 AM
Subject: Re: How to create mysql user?
> O K.
> I accessed to mysql as root user and tried to created user 'abc' as folows
:
>
>
&
inal Message-
From: ads mysql [mailto:[EMAIL PROTECTED]
Sent: Monday, December 15, 2003 11:21 PM
To: Nitin; [EMAIL PROTECTED]
Subject: Re: How to create mysql user?
O K.
I accessed to mysql as root user and tried to created user 'abc' as folows :
[EMAIL PROTECTED] mysql]# mysql -u root
ECTED]> wrote:
right now, u r trying to connect t omyql with uer abc, not creating it.
to create user abc
grant
on dbname.tablename to 'abc' identified by 'abc';
you can view the list of privileges available on myql website at
http://www.mysql.com/doc/en/GRANT.html
Enjoy
Nit
--- Original Message -
From: "ads mysql" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, December 16, 2003 11:09 AM
Subject: How to create mysql user?
>
> Hi,
> I have installed mysql. As per documentation with user as 'root'.
>
> I can crea
Syntax I got from Documentation for GRANT as follows:
###
4.4.1 GRANT and REVOKE Syntax
GRANT priv_type [(column_list)] [, priv_type [(column_list)] ...]
ON {tbl_name | * | *.* | db_name.*}
TO user_name [IDENTIFIED BY [PASSWORD] 'password']
[, user_name [IDENTIFIED BY [PAS
I have a table "members" in the MySQL database. I am
going to supply a String "editor" and search the
"members" table. All those who are "editor" will be
picked up and their name will enter the array I want
to create.
How do I code it and return this array?
Here is a sketch of my code. I do n
ifferent under
Linux and windows. The commands are not exactly the same.
Even if it is the same MySQL version.
Yours sincerely
Morten Gulbrandsen
-Ursprüngliche Nachricht-
Von: Caroline Jen [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 10. September 2003 22:33
An: [EMAIL PROTECTED]
com/doc/en/User_Account_Management.html
)
> -Original Message-
> From: Caroline Jen [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 10, 2003 4:33 PM
> To: [EMAIL PROTECTED]
> Subject: How To Create Users In MySQL?
>
>
> I have the MySQL-3.23.55 installed in my PC.
> Therefore,
I have the MySQL-3.23.55 installed in my PC.
Therefore, I am the DBA without the required DBA
knowledge.
First, how do I create users in the MySQL database?
Second, how do I grant table creation privilege to
users? Is
GRANT ALL PRIVILEGES ON databasename TO someuser
IDENTIFIED BY 'somepassword';
ft_stopword_file The file from which to read the list of stopwords for full-
text searches. All the words from the file will be used; comments are not
honored. By default, built-in list of stopwords is used (as defined in
`myisam/ft_static.c'). Setting this parameter to an empty string ("") will
di
At 10:12 +1000 8/22/03, <[EMAIL PROTECTED]> wrote:
sorry to be vague but what is the ft_stopword_file i havent been able to be
up to speed on that variable.
Read the page referenced below:
http://www.mysql.com/doc/en/SHOW_VARIABLES.html
It describes what the variable is for.
At 15:53 -0300 8/2
sorry to be vague but what is the ft_stopword_file i havent been able to be
up to speed on that variable.
> At 15:53 -0300 8/21/03, Cleber Hostalácio de Melo wrote:
>>Hi,
>>
>>I need to change the stop word file used by the MySQL in fulltext
>>seach.
>>
>>The documentation (www.mysql.com/doc/en/Fu
At 15:53 -0300 8/21/03, Cleber Hostalácio de Melo wrote:
Hi,
I need to change the stop word file used by the MySQL in fulltext seach.
The documentation (www.mysql.com/doc/en/Fulltext_Fine-tuning.html)
explains how to inform to MySQL the new stop word file through the
"ft_stopword_file" variable.
> how to separate each stop word in the list
A different word on each line.
-steve-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I need to change the stop word file used by the MySQL in fulltext seach.
The documentation (www.mysql.com/doc/en/Fulltext_Fine-tuning.html)
explains how to inform to MySQL the new stop word file through the
"ft_stopword_file" variable.
But I could not find any reference to the layout of thi
Thank you very much. That information is very helpful as I am just starting
to use/learn MySQL.
Raju Ganapathiraju
From: "Roger Baklund" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
CC: "Ayyaparaju Ganapathiraju" <[EMAIL PROTECTED]>
Subject: Re: How to
* Ayyaparaju Ganapathiraju
> 1). Is there an equivalent to creating a schema in MySQL. I would like to
> create tables in multiple schemas within the same database. Some of the
> tables will have foregign keys across schemas.
No, there is no consept of 'schema' in mysql, other than the implicit
's
AIL PROTECTED]>
(BTo: <[EMAIL PROTECTED]>
(BSent: Wednesday, February 19, 2003 10:30 AM
(BSubject: How to create a schema
(B
(B
(B> Hi,
(B>
(B> I have two questions here, please.
(B>
(B> 1). Is there an equivalent to creating a schema in MySQL. I would like to
(B>
Hi,
I have two questions here, please.
1). Is there an equivalent to creating a schema in MySQL. I would like to
create tables in multiple schemas within the same database. Some of the
tables will have foregign keys across schemas.
I'm aware that I can create multiple databases and switch betw
://www.mysql.com/doc/en/CREATE_INDEX.html
[5] http://www.mysql.com/doc/en/Cannot_create.html
[6] http://www.mysql.com/doc/en/SHOW_CREATE_TABLE.html
This was an automated reply to your message about 'how to create database'.
I used 'create database' as a keyword to query t
CREATE TABLE TableC SELECT tableA.field1,table1.field2,tableB.field1
FROM tableA,tableB WHERE joinCondition
That should do it, if I got the syntax correct. You do want to use the
create/select combo though.
On Thursday, September 26, 2002, at 12:59 AM, Jack wrote:
> Dear all
> i had two table
Hi!
It sounds like a simple UNION ALL thing, but I think I don'tunderstand well
what your problem is. Can you give an example?
Daniel
At 12:59 2002.09.26. +0800, you wrote:
>Dear all
>i had two tables, tableA & Table B.
>I want to create a permanent table call Table C which the first two field
Dear all
i had two tables, tableA & Table B.
I want to create a permanent table call Table C which the first two field
will be equal to Table A's first 2 field and last field will be equal to
Table B's first field.
can anyone pls tell me what query should i use?
it will be nice if you can provid
Ilyas,
Wednesday, September 25, 2002, 3:09:34 PM, you wrote:
IK> I am using MacOSX SERVER. When I want to start MySQL it says:
IK> [HostPowerBook:/] ilyas% mysql
IK> ERROR 2002: Can't connect to local MySQL server through socket
IK> '/tmp/mysql.sock' (61)
IK> According to Mysql documentation t
Hi there
I am using MacOSX SERVER. When I want to start MySQL it says:
[HostPowerBook:/] ilyas% mysql
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (61)
According to Mysql documentation this means that mysqld doesn't
started. Just when I want to start mysql
Brian,
Monday, August 19, 2002, 11:48:16 PM, you wrote:
BJ> I have a SQL statement to create a PostgreSQL table that include a line 'id serial'
BJ> This line creates a integer field with a sequence atached to it to create an
autonumber
In MySQL you can use AUTO_INCREMENT:
http://www.mysql.
I have a SQL statement to create a PostgreSQL table that include a line 'id serial'
This line creates a integer field with a sequence atached to it to create an autonumber
Is there a way to create a SQL statement to accomplish this that would work with
both MySQL and PostgreSQL
---
Hi,
There is a bug in GRANT for CREATE TEMPORARY TABLE privilege which is fixed
now in the 4.0.3 tree.
Regards,
Jocelyn
- Original Message -
From: "Philip Mak" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 13, 2002 7:38 PM
Subject: How to
>I can't get CREATE TEMPORARY TABLE to work due to a privilege problem.
Run the mysql_fix_privilege_tables script. There are new privileges
in 4.0.2, one of which applies to temporary tables.
>Does anyone know what I'm doing wrong?
>
>mysql> update user set create_tmp_table_priv='Y';
>Query OK,
I can't get CREATE TEMPORARY TABLE to work due to a privilege problem.
Does anyone know what I'm doing wrong?
mysql> update user set create_tmp_table_priv='Y';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 2 Changed: 0 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.00 s
At 6:11 + 6/29/02, toby - wrote:
>thnx a million paul
>
>got that :)
>
>>So ... why do you want to do this?
>
>well i get really irretated of seein row# 66 right after 5
So basically, it's just a psychological thing on your part, right?
>but seriously i dont know the + or - points of th
thnx a million paul
got that :)
>So ... why do you want to do this?
well i get really irretated of seein row# 66 right after 5
but seriously i dont know the + or - points of the types
besides my project supervisor just declared v DONT NEED isam
since v dont NEED row 6 after 5 n not
At 5:29 + 6/29/02, toby - wrote:
>hi guyz
>
>i va all my tables " myisam " since its da default type
>
>how can i make isam tables
Add
TYPE = ISAM
to the end of your CREATE TABLE statement.
>
>1. will someone plz guide me with about the syntex
>
>2. how can i change the type of my my
hi guyz
i va all my tables " myisam " since its da default type
how can i make isam tables
1. will someone plz guide me with about the syntex
2. how can i change the type of my myisam tables to isam
:( without having to drop them
thnx a million
toby .
sql, query
___
I need some help creating a Primary Key in MySQL with autoincrement
Hello, how can i do a concatenated primary key index of:
date,"NOTA",id
e.g. 05042002NOTA1
which the id is generated daily, everyday start with id=1 and increments
Azul
-
Hello list,
I need to write a small perl skript to insert a record (email, timestamp)
into a table. Two problems:
1. Since email is unique I don't want to get the "duplicate record" message.
If email already exist, the perl program should continue silent.
2. How do I create a datetime-compatibl
1 - 100 of 134 matches
Mail list logo
