I\'m trying to write a php script that will load a tab-delimited CSV file into a MySQL database table so that I can set up a cron job to automate the process.
A PHP script is generating the following table panel based on the data from a mysql DB. Each cell of the table contains a checkbox which sets the access to some \'areas\'. The name of my checkboxes ar
I need to set a field value, actually a flag, in a record to either 0 or 1 depending on whether the id field (int(10) auto_increment, primary key) is even or odd. I know I can determine the value afte
I wasnt quite sure how to word the title so sorry about that. I am trying to load some start and stop schedule times into a database but sometimes a start and stop time for the same system will overla
I\'m creating a simple session based app in PHP/MySQL. I\'m storing a session for each user connected to app in mysql table with their associated session_id. What I want to do is stop recording once a
I wish to wri开发者_C百科te a query that inserts a file that resides on the client (C# web server) into a column in the database server (SQL Server), something like INSERT … SELECT * FROM OPENRO
typedef struct treeNode { treeNode* left; treeNode* right; int data; treeNode(int d) {开发者_开发知识库
I have got the type Word with the property Topics which is a List object. I have two tables in the database: Words and Topics. I want write a word in Words table and store each topic with its correspo
I am inserting some words into a two-column table with this command: INSERT IGNORE INTO terms (term) VALUES (\'word1\'), (\'word2\'), (\'word3\');
I\'m having some difficulty putting a conditional into MySQL. I\'ve been trying to create a query that will go through all of the column titled email and if it exists I want to do something like this: