Since RACE supports multiple queries in a database tag, you can insert the line of data, then select the last auto_increment ID back from the database: lt;database name="dbfoo" query="INSERT INTO foo (auto,text) VALUES(NULL,'text'); SELECT LAST_INSERT_ID() as LASTID from foo"> See similar questions...

Use the UNIQUEKEY(table_name) function. For example, INSERT INTO MyTable ( my_unique_id, my_value ) VALUES ( UNIQUEKEY('MyTable'), 'record value' ) With a clever use of the DEFAULT clause when creating a table you can make it automatic. eg. CREATE TABLE MyTable ( my_unique_id NUMERIC DEFAULT UNIQUEKEY('MyTable'), my_value LONGVARCHAR(1000) ) The UNIQUEKEY function is an atomic operation that will return a set of sequential numbers for a table on a first serve basis. See similar questions...

Propel supports only native id generation. That means that for MySQL Propel will use AUTO_INCREMENT, IDENTITY() for MS SQL Server, CREATE SEQUENCE ... for PostgreSQL, etc. See similar questions...

i. Only losers and idiots use i++. This is different if your native language would idiomatically use ''i increment'', but in English and related languages, you must use ++i. Note that a modern program must use both, dependent on the current locale. See similar questions...

We do not give out shell accounts by default for security and resource usage reasons. Additionally (and for similar reasons) we like to personally set up MySQL databases only for customers who request them. If you'd like to put in a request, contact customer support for more information. Additionally, remember that only Domain and Super accounts can use CGI, MySQL, PHP, etc. See similar questions...

MySQL is an open source database server that employs Structured Query Language (SQL). A database server is a program that can store large amounts of information in an organized format that's easily accessible through scripting languages like PHP. See similar questions...

Many scientists use a 2.1mm ID and smaller columns for LCMS which have optimal flow rates of approximately 0.3ml/min. This is fine for isocratic analysis but when you must use a gradient method, specialized pumps and mixing valves are necessary that can reproduce the very small changes in the mobile phase's composition. 3.0mm ID columns use more traditional flow rates and can be used easily on LCMS without specialized pumps for both gradient and isocratic methods. See similar questions...

We are now allowing MySQL databases again. To create yourself a database, run the "mysqlme" located in "/usr/local/bin/". The program will create a MySQL user entry for your userid and then create a database for you with the name of your userid. You can have more than one database by specifying a database name with the "-db dbname" option. A database will then be created called "userid_dbname". See similar questions...

Yes. You will have your own domain name with any of our hosting packages with no ads or other junk cluttering your pages. Please note that we give all of our clients their own unique IP address. Many other hosting companies provide only one IP that must be shared with thousands of users. We do not use that system. See similar questions...

No. Both are included as features in our hosting package. However, due to the special nature of database design, we recommend users contact http://mysql.com and http://php.net for answers to questions concerning either product. See similar questions...

If you're using MySQL 5.x on Windows and you can't get past the Database Setup Step in the installer and get a message like The database privileges test did not complete successfully. Failed to create a DB test sequence.Check the returned error message and README.html for missing privileges and clean up the database. Then you most probably have a MySQL InnoDB Engine issue. To resolve it, try: Delete BOTH your MySQL DATA and LOG files at the same time and restart the server. Step 2. See similar questions...

Yes; any desktop MySQL management software which supports secure SSH connections (or "SSH Tunnels") such as NaviCat will work with the J2-VDS service and above. See similar questions...

By default the module will list all of the databases on your system on the main page, even if some are not actually usable by the logged-in user. To change this, follow these steps : In the Database access control list field, remove the existing *: * line and enter one line per user, containing the username, a colon and list of databases he is allowed to use. See similar questions...

The system we use requires some high-level programming knowledge. We use a relational database, MySQL, along with our own customized programs and storage system. You can read about our image retrieval system here: http://calphotos.berkeley.edu/retrieval.html. Our programs are freely available to other developers who want to build similar systems. The page above contains instructions on how to do that. There are several commercial image databases. See similar questions...

MySQL Cluster supports all of the usual MySQL column types, with the exception of those associated with MySQL's Chapitre 18, Donn??es spatiales avec MySQL. In addition, there are some differences with regard to indexes when used with NDB tables. Note: In MySQL 4.1 and 5.0, Cluster tables (that is, tables created with ENGINE=NDBCLUSTER) have only fixed-width rows. See similar questions...