Search Results

Search found 15376 results on 616 pages for 'mysql triggers'.

Page 121/616 | < Previous Page | 117 118 119 120 121 122 123 124 125 126 127 128  | Next Page >

• MySQL National Stock Numbers (NSN) for identification of assets

  - by sammysmall

  In MySQL are there any restrictions (and/or) practical reasons against using a numbering system similiar to the National Stock Number format as follows 3728-01-234-5678 (this format includes the use of the hyphen between groups of characters within the structure) Would this require the use of a specific engine like InnoDB A newbie student

  Read the article

• Connect to MySQL in Ruby using NetBeans

  - by Varun

  I've downloaded the "dbd-mysql-0.4.4.zip" and linked it to my project. While I try to run a demo code from NetBeans the very first line require "dbi" gives me an error. Is there a different way to do it? I also tried jruby setup.rb config --with=dbi,dbd_mysql from the command prompt and it gave me the following error: config: unknown option --with=dbi,dbd_mysql Try 'ruby setup.rb --help' for detailed usage. Any suggestions please?

  Read the article

• Easy C library to access MySQL

  - by Pyrite

  Any suggestions for a real simple C library to query a single MySQL table, nothing fancy here. Just doing a single select * from a table. Any help is appreciated.

  Read the article

• How do I generate site map from MySQL database

  - by mathew

  Hi all I am new to Php and working on a project which needs to generate sitemaps from URLS which stored in MySQL database. how can I do this?? Is there any one have any idea?? site maps can be in php extension too and only requirement is list of sites display in each page

  Read the article

• MySQL: Updating entry WITHOUT updating timestamp

  - by Yongho

  I have a timestamp in a mysql table with attribute "ON UPDATE CURRENT_TIMESTAMP". Is there a way to manually disable updating the timestamp on a special occasion? (eg: updating the entry to revise a blog post, but not to re-date it)

  Read the article

• Native language problem in mysql with tinyMCE

  - by jasmine

  I have turkish character problem in mysql database when adding content with tinymce from admin panel. Charset is: <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-9"" /> How can I solve this? Thanks in advance

  Read the article

• How to kill locked mysql queries

  - by jcure

  Hi, I am creating and testing a mysql join query but each time so far it causes the database tables to lockup and the site hangs. I have to then call the host and they kill the locked queries. Is this something I can do from phpmyadmin so not to bother them while I tweak the script to work? Thanks for any reply.

  Read the article

• MPTT to select root element mysql

  - by bah

  Hi, What mysql query should i use to select root elements? Let's say i have tree structure like this: http://www.ipix.lt/desc/18496369 And i want to select (Vaisiai, Daržoves) elements.

  Read the article

• php date will not insert into mysql database

  - by Piers Blinco

  this is a strange one. I have a date, that is converted to mm-dd-yyyy when posting it to mysql i have re-ordered it to yyyy-mm-dd but yet it still will not insert $date = date("Y-m-d", strtotime($_POST['leaving_date']) ); any advice? Cheers EDIT The actual query: mysql_query("INSERT INTO booking_info (customer_id, booking_ref, date_of_travel) VALUES (".mysql_real_escape_string($_POST['customer_id']).", ".mysql_real_escape_string($rnd).", ".mysql_real_escape_string($date).")");

  Read the article

• isValid() call never returns on MySQL JDBC Connection

  - by sfaiz

  Hi, I have trying to check whether connection is valid or not and using isValid() method of java.sql.Connection. But this method doesn't return and hangs. Is there anything I am missing or this method requires any configuration? Using mysql-connector-java-5.0.7-bin.jar Thanks, Shahid

  Read the article

• Repeating events in a MySQL DB

  - by kylex

  I'm needing to create a MySQL database that is capable repeating events in the exact same way that google calendar repeats events. What is the best way to structure the table(s) to do this?

  Read the article

• MySQL : Insert Exactly Same Data Multiple Rows Without PHP Loop

  - by Robert Hanson

  I need to insert same data to my MySQL table without having PHP loop. The reason why I'm doing this is that because I have a column with Auto_Increment feature and that column associates with other table. So, I just need to insert some exactly same data and it's multiple rows (dynamic) but by using single INSERT syntax below : INSERT INTO outbox_multipart (TextDecoded) VALUES ('$SMSMessage') how to have this single INSERT syntax, but produce n number of rows?

  Read the article

• data caching in mysql

  - by Praveen Prasad

  can we cache queries in mysql with php. or please suggest me some ways to do so.

  Read the article

• Sphinx Mysql Tutorial Help

  - by Frederico

  I have just implemented the Sphinx Storage Engine, and created my first Sphinx table, I'm trying to convert from using my Fulltext MyISAM table, so I figured I would just dump all the data into a sphinx table.. obviously I was wrong. Are there any great tutorials that really take you through transforming a fulltext search on MySQL to a sphinx table? Thanks in advance.

  Read the article

• fastest way to copy a table in mysql

  - by Anon

  which one is the fastest way to completely copy a table on mysql ? CREATE TABLE copy LIKE original; INSERT INTO copy SELECT * FROM original; or CREATE TABLE copy SELECT * FROM original; ALTER TABLE copy ADD PRIMARY KEY (id); or theres another way ? PS. can't use command-line tools like mysqldump, must be on-the-fly.

  Read the article

• passing LIMIT as parameters to MySQL sproc

  - by Kyle

  I'm creating a paging class and need to pass in two parameters to my MySQL stored procedure for the LIMIT clause. I'm passing them in as INTs and trying something like this SELECT * FROM `MyTable` LIMIT MyFirstParamInt, MySecondParamInt it gives me an error when I try and save the sproc though. Is there a way to do this that I'm just missing? Or am I going to have to EVAL the whole query and EXECUTE it?

  Read the article

• opening pdf file using php that take data from mysql

  - by Sahar

  hello, anyone can plz help me? i wanted to create pdf file using php and have done it. now i want to create pdf file that get data from mysql table.. i've searched for the sample code for long time but didnt find even a single code related to my query.. thanx in advance

  Read the article

• PHP MySQL JavaScript or AJAX Image Slideshow

  - by medoix

  Hi all, i have searched Google and also searched Stack Overflow to no avail. I am looking for a PHP / MySQL driven dynamic image slideshow. One similar to 'lightcyclers.com', i have information stored in the DB and i just want to display random or popular content etc. I am also not interested in coding one myself as i am busy working on other features. Any links or help would be much appreciated.

  Read the article

• Error in connecting to MySql Host

  - by Mark

  Can anyone tell me on how this error arise? 'Unable to connect to any of the specified MySQL hosts.'

  Read the article

• connect java application to mysql server in netbeans 6.8

  - by Avadhesh sharma

  i am beginner in java as well as in netbeans .please give me complete procedure how i can connect my java application to mysql to insert data .

  Read the article

• mysql circular dependency in foreign key constraints

  - by Flavius

  Given the schema: What I need is having every user_identities.belongs_to reference an users.id. At the same time, every users has a primary_identity as shown in the picture. However when I try to add this reference with ON DELETE NO ACTION ON UPDATE NO ACTION, MySQL says #1452 - Cannot add or update a child row: a foreign key constraint fails (yap.#sql-a3b_1bf, CONSTRAINT #sql-a3b_1bf_ibfk_1 FOREIGN KEY (belongs_to) REFERENCES users (id) ON DELETE NO ACTION ON UPDATE NO ACTION) I suspect this is due to the circular dependency, but how could I solve it (and maintain referential integrity)?

  Read the article

• MYSQL Order By Sum of Columns

  - by djs22

  Hi all, Any idea on how to order the results of a MYSQL query by the sum of two columns rather than by a single column? Select * FROM table ORDER BY (col1+col2) desc I know that won't work., but I hope it conveys what I want to do fairly well. Thanks!

  Read the article

• mysql search number in table

  - by Sanjay

  hi, i am using php/mysql. i have a product table . in which most product have starting name with number. i want to listout all products start with any number. any one have idea about it....

  Read the article

• How to get the exact string within the brackets in mysql

  - by sreenath

  In my mysql table a field values are as follows: table name - "clients" field name - "accent" values are - "Eastern(Northern,Southern),Scottish(East Coast)" "Eastern(South,North,Southern),Scottish(East Coast)" If I give select accent from clients where accent like '%north%' if more than 100 records not in the same order. Strings with in the brackets are not in the same order means. It will give above two values. How should i get only second value? Please help me, thanks.

  Read the article

• Maximum number of records in a MySQL database table

  - by pepernik

  What is the upper limit of records for MySQL database table. I'm wondering about autoincrement field. What would happen if I add milions of records? How to handle this kind of situations? Thx!

  Read the article

< Previous Page | 117 118 119 120 121 122 123 124 125 126 127 128  | Next Page >